API TO 更新工单题头信息

最新推荐文章于 2024-02-22 12:02:30 发布

huangwenkangz

最新推荐文章于 2024-02-22 12:02:30 发布

阅读量350

点赞数

分类专栏： WIP 文章标签：工单API 更新工单

本文链接：https://blog.csdn.net/huangwenkangz/article/details/80337598

版权

WIP 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

--AB-8CXB-A7B10-091
declare
   p_group_id NUMBER;
   l_schedule_iface_rec wip_job_schedule_interface%ROWTYPE;
   x_error_status  VARCHAR2(200);

   x_error_message VARCHAR2(200);
begin
    select wip_job_schedule_interface_s.nextval into l_schedule_iface_rec.group_id from dual;
    p_group_id := l_schedule_iface_rec.group_id ;

--

    l_schedule_iface_rec.last_update_date := SYSDATE;

    l_schedule_iface_rec.last_updated_by := 1111;

    l_schedule_iface_rec.creation_date := SYSDATE;

    l_schedule_iface_rec.created_by := 1111;
    
    l_schedule_iface_rec.load_type := 3; --Update standard or non-standard Discrete Job
    
    l_schedule_iface_rec.process_phase := 2; --Validation
    
    l_schedule_iface_rec.process_status := 1; --Pending
    l_schedule_iface_rec.first_unit_start_date := sysdate;    
    l_schedule_iface_rec.wip_entity_id := 60260;

    l_schedule_iface_rec.organization_id := 118;
    
    INSERT INTO wip.wip_job_schedule_interface VALUES l_schedule_iface_rec;

          wip_massload_pub.massloadjobs(p_groupid => p_group_id, -- Group ID

                                        p_validationlevel => 2, -- Validation Level

                                        p_commitflag => 1, -- Commit 1 =Yes , 0 ='No'

                                        x_returnstatus => x_error_status,

                                        x_errormsg => x_error_message);
end;