APPS.WIP_JDI_UTILS SQL Statements

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

Line: 20

      Update WIP_JOB_DTLS_INTERFACE
      SET interface_id = WIP_INTERFACE_S.NEXTVAL,
          process_status = WIP_CONSTANTS.RUNNING
      WHERE group_id = p_group_id
      AND   process_status =  WIP_CONSTANTS.PENDING
      AND   process_phase =  WIP_CONSTANTS.ML_VALIDATION;

Line: 27

      Update WIP_JOB_DTLS_INTERFACE
      SET interface_id = WIP_INTERFACE_S.NEXTVAL,
          process_status = WIP_CONSTANTS.RUNNING
      WHERE group_id = p_group_id
      AND   parent_header_id = p_parent_header_id
      AND   process_status =  WIP_CONSTANTS.PENDING
      AND   process_phase =  WIP_CONSTANTS.ML_VALIDATION;

Line: 53

 	' select interface_id
          from wip_job_dtls_interface WJDI' ||
	' where WJDI.group_id = :x_group_id'||
        ' and WJDI.process_phase = '|| WIP_CONSTANTS.ML_VALIDATION ||
        ' and WJDI.process_status in ('|| WIP_CONSTANTS.RUNNING||
                                ','||WIP_CONSTANTS.PENDING||
                                ','||WIP_CONSTANTS.WARNING ||') and '||
        replace(p_where_clause, '    ',' ');

Line: 135

              ' UPDATE  WIP_JOB_DTLS_INTERFACE WJDI'||
              ' SET PROCESS_STATUS = :x_New_Process_Status ' ||
              ' WHERE   GROUP_ID =   :x_Group_Id ' ||
              ' AND     PROCESS_PHASE = ' || WIP_CONSTANTS.ML_VALIDATION || '
                AND     PROCESS_STATUS IN ('|| WIP_CONSTANTS.RUNNING||
                                           ','||WIP_CONSTANTS.PENDING||
                                           ','||WIP_CONSTANTS.WARNING ||')'||
              ' AND  ' || replace(p_where_clause, '    ',' ');

Line: 165

      select count(*) into x_count
      from wip_job_dtls_interface
      where wip_entity_id = p_wip_entity_id
      and organization_id = p_organization_id
      and process_phase = WIP_CONSTANTS.ML_VALIDATION
      and process_status = WIP_CONSTANTS.ERROR ;

Line: 204

      Update WIP_JOB_DTLS_INTERFACE
      SET process_status = WIP_CONSTANTS.ERROR
      WHERE wip_entity_id = p_wip_entity_id
      AND   organization_id = p_organization_id;

Line: 211

     Update WIP_JOB_DTLS_INTERFACE
     SET process_status = WIP_CONSTANTS.ERROR
     WHERE group_id = p_group_id
     AND   parent_header_id = p_parent_header_id;

Line: 237

     select group_id, header_id
     into x_group_id, x_header_id
     from wip_job_schedule_interface
     where rowid = p_row_id
     and   load_type in (WIP_CONSTANTS.CREATE_JOB,WIP_CONSTANTS.RESCHED_JOB,
                   WIP_CONSTANTS.CREATE_NS_JOB);

Line: 244

     Update WIP_JOB_DTLS_INTERFACE
     SET process_status = WIP_CONSTANTS.PENDING,
         group_id = p_group_id
     WHERE group_id = x_group_id
     AND   parent_header_id = x_header_id;