APPS.WIP_MASSLOAD_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 35

      select 1
        from wip_job_schedule_interface
       where group_id = p_groupID
         and process_status = wip_constants.pending
         and process_phase = wip_constants.ml_validation
         and load_type <> wip_constants.create_sched
      for update nowait;

Line: 44

      select rowid,
             header_id,
             interface_id
        from wip_job_schedule_interface
       where group_id = p_groupID
         and process_phase = wip_constants.ml_validation
         and process_status in (wip_constants.running, wip_constants.warning)
         and load_type <> wip_constants.create_sched;

Line: 69

    select count(*) into l_requestCount
        from wip_job_schedule_interface
       where group_id = p_groupID
         and process_status = wip_constants.pending
         and process_phase = wip_constants.ml_validation
         and load_type <> wip_constants.create_sched;

Line: 87

    update wip_job_schedule_interface
       set interface_id = wip_interface_s.nextval,
           process_status = wip_constants.running
     where group_id = p_groupID
       and process_status = wip_constants.pending
       and process_phase = wip_constants.ml_validation
       and load_type <> wip_constants.create_sched;

Line: 122

        select count(*)
          into l_totalNum
          from wip_job_schedule_interface wjsi,
               wip_job_dtls_interface wjdi
         where wjdi.parent_header_id = wjsi.header_id
           and wjdi.group_id = wjsi.group_id
           and wjdi.process_phase = wip_constants.ml_validation
           and wjdi.process_status = wip_constants.pending
           and wjsi.rowid = wjsi_rec.rowid
           and wjsi.load_type in (wip_constants.create_job,
                                  wip_constants.create_ns_job,
                                  wip_constants.resched_job);

Line: 161

 select wdj.status_type,
        wjsi.status_type,
        wdj.wip_entity_id,
        wdj.organization_id
        into l_wdj_old_status_type,
             l_wjsi_new_status_type,
             l_wdj_wip_entity_id,
             l_wdj_organization_id
         from wip_discrete_jobs wdj,
             wip_job_schedule_interface wjsi
       where wjsi.rowid = wjsi_rec.rowid
         and wdj.wip_entity_id = wjsi.wip_entity_id
         and wdj.organization_id = wjsi.organization_id
         and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB,
                                WIP_CONSTANTS.CREATE_NS_JOB,
                                WIP_CONSTANTS.CREATE_EAM_JOB,
                                WIP_CONSTANTS.RESCHED_EAM_JOB,
                                WIP_CONSTANTS.RESCHED_JOB) ;

Line: 205

    update wip_job_schedule_interface
       set process_status = wip_constants.completed,
           process_phase = wip_constants.ml_complete
     where group_id = p_groupID
       and process_status in (wip_constants.running, wip_constants.warning)
       and process_phase = wip_constants.ml_validation
       and load_type <> wip_constants.create_sched;

Line: 217

    select count(*) into l_errRecCount
      from wip_job_schedule_interface
     where group_id = p_groupID
       and process_status = wip_constants.error;

Line: 275

      select 1
        from wip_job_schedule_interface
       where interface_id = p_interfaceID
      for update nowait;

Line: 294

    select rowid, group_id, header_id
      into l_rowid, l_groupID, l_headerID
      from wip_job_schedule_interface
     where interface_id = p_interfaceID;

Line: 299

    select count(*)
      into l_totalNum
      from wip_job_schedule_interface
     where interface_id = p_interfaceID
       and process_status = wip_constants.pending
       and process_phase = wip_constants.ml_validation
       and load_type in (wip_constants.create_job, wip_constants.create_ns_job);

Line: 313

    select count(*)
      into l_totalNum
      from wip_job_schedule_interface wjsi
     where wjsi.group_id = l_groupID;

Line: 330

    update wip_job_schedule_interface
       set process_status = wip_constants.running
     where interface_id = p_interfaceID;

Line: 343

    select count(*)
      into l_totalNum
      from wip_job_schedule_interface
     where interface_id = p_interfaceID
       and process_status in (wip_constants.running, wip_constants.warning);

Line: 360

    select count(*)
      into l_totalNum
      from wip_job_schedule_interface wjsi,
           wip_job_dtls_interface wjdi
     where wjdi.parent_header_id = wjsi.header_id
       and wjdi.group_id = wjsi.group_id
       and wjdi.process_phase = wip_constants.ml_validation
       and wjdi.process_status = wip_constants.pending
       and wjsi.rowid = l_rowid;

Line: 396

    select wip_entity_id
      into x_wipEntityID
      from wip_job_schedule_interface
     where rowid = l_rowid;

Line: 401

    update wip_job_schedule_interface
       set process_status = wip_constants.completed
     where rowid = l_rowid;

Line: 460

      select operation_seq_num
        from wip_operations
       where wip_entity_id = v_wipEntityID;

Line: 468

    select wip_entity_id,
           serialization_start_op,
           load_type,
           primary_item_id,
           organization_id
      into l_wipEntityID,
           l_wjsiSerOp,
           l_loadType,
           l_primaryItemID,
           l_orgID
      from wip_job_schedule_interface
     where rowid = p_rowid;

Line: 483

      update wip_discrete_jobs wdj
         set serialization_start_op = null
       where wip_entity_id = l_wipEntityID
         and serialization_start_op <> 1
         and not exists(select 1
                          from wip_operations wo
                         where wo.wip_entity_id = wdj.wip_entity_id
                           and wo.operation_seq_num = wdj.serialization_start_op);

Line: 498

    select serialization_start_op
      into l_wdjSerOp
      from wip_discrete_jobs
     where wip_entity_id = l_wipEntityID;

Line: 508

    select 1
      into l_dummy
      from wip_discrete_jobs wdj,
           mtl_system_items msi
     where wdj.primary_item_id = msi.inventory_item_id
       and wdj.organization_id = msi.organization_id
       and wdj.wip_entity_id = l_wipEntityID
       and msi.serial_number_control_code = wip_constants.full_sn;

Line: 541

      select 1
        into l_dummy
        from wip_discrete_jobs
      where wip_entity_id = l_wipEntityID
        and status_type = wip_constants.unreleased;