APPS.WIP_RES_USAGE_SUBSTITUTIONS SQL Statements

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

Line: 14

    SELECT operation_seq_num, resource_seq_num
    FROM WIP_JOB_DTLS_INTERFACE
    WHERE group_id = p_group_id
      AND process_phase = WIP_CONSTANTS.ML_VALIDATION
      AND process_status = WIP_CONSTANTS.RUNNING
      AND wip_entity_id = p_wip_entity_id
      AND organization_id = p_organization_id
      AND load_type = WIP_JOB_DETAILS.WIP_RES_USAGE
      AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
      ORDER BY operation_seq_num, resource_seq_num;

Line: 47

  Cursor Usage_Update (p_group_id number, p_wip_entity_id number,
                       p_organization_id number, p_operation_seq_num number,
                       p_resource_seq_num number) IS

   SELECT distinct wip_entity_id , organization_id, operation_seq_num,
          resource_seq_num, start_date, completion_date, assigned_units,
          last_update_date, last_updated_by, creation_date, created_by,
         last_update_login, program_application_id, request_id, program_id,
          program_update_date, substitution_type
   FROM WIP_JOB_DTLS_INTERFACE
   WHERE group_id = p_group_id
   AND   wip_entity_id = p_wip_entity_id
   AND  organization_id = p_organization_id
   AND  operation_seq_num = p_operation_seq_num
   AND  resource_seq_num = p_resource_seq_num
   AND  load_type = WIP_JOB_DETAILS.WIP_RES_USAGE
   ORDER BY start_date;

Line: 92

       DELETE FROM WIP_OPERATION_RESOURCE_USAGE
       WHERE wip_entity_id = p_wip_entity_id
       AND   organization_id = p_organization_id
       AND   operation_seq_num = p_operation_seq_num
       AND   resource_seq_num = p_resource_seq_num;

Line: 98

/**********************DELETE ALL EXISTING RECORDS BEFORE ADD *************/

   FOR cur_update IN Usage_Update(p_group_id , p_wip_entity_id,
                       p_organization_id, p_operation_seq_num,
                       p_resource_seq_num ) LOOP

      IF cur_update.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

        INSERT INTO WIP_OPERATION_RESOURCE_USAGE
         ( WIP_ENTITY_ID  ,
          ORGANIZATION_ID,
          OPERATION_SEQ_NUM,
           RESOURCE_SEQ_NUM,
          START_DATE ,
          COMPLETION_DATE,
          ASSIGNED_UNITS ,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_LOGIN,
          REQUEST_ID,
	  PROGRAM_APPLICATION_ID,
	  PROGRAM_ID,
          PROGRAM_UPDATE_DATE )
       VALUES
       ( cur_update.wip_entity_id,
         cur_update.organization_id,
         cur_update.operation_seq_num,
         cur_update.resource_seq_num,
         cur_update.start_date,
         cur_update.completion_date,
         cur_update.assigned_units,
         cur_update.last_update_date,
         cur_update.last_updated_by,
         cur_update.creation_date,
         cur_update.created_by,
         cur_update.last_update_login,
         cur_update.request_id,
         cur_update.program_application_id,
         cur_update.program_id,
         cur_update.program_update_date);