APPS.WIP_RES_USAGE_DEFAULT SQL Statements

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

Line: 15

    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 in
           (WIP_JOB_DETAILS.WIP_RES_USAGE, WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
      AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
      ORDER BY operation_seq_num, resource_seq_num;

Line: 57

    l_last_update_login number;

Line: 61

    l_program_update_date date;

Line: 69

    l_last_update_login := 0;

Line: 73

    l_program_update_date := sysdate;

Line: 92

        SELECT COUNT(*) INTO l_parent_header
        FROM WIP_JOB_SCHEDULE_INTERFACE
        WHERE header_id = p_parent_header_id
        AND   group_id = p_group_id;

Line: 98

         SELECT last_update_login,
                request_id,
                program_application_id,
                program_id,
                program_update_date
         INTO   l_last_update_login,
                l_request_id,
                l_program_application_id,
                l_program_id,
                l_program_update_date
         FROM WIP_JOB_SCHEDULE_INTERFACE
         WHERE wip_entity_id = p_wip_entity_id
         AND   organization_id = p_organization_id
         AND   header_id = p_parent_header_id
         AND   group_id = p_group_id;

Line: 117

       select count(*) into l_oper_resource
        from wip_operation_resources
        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: 125

         SELECT last_update_login,
                request_id,
                program_application_id,
                program_id,
                program_update_date
         INTO   l_last_update_login,
                l_request_id,
                l_program_application_id,
                l_program_id,
                l_program_update_date
         FROM WIP_OPERATION_RESOURCES
         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: 144

    UPDATE WIP_JOB_DTLS_INTERFACE
    SET last_update_login = NVL(last_update_login, l_last_update_login),
        request_id = NVL(request_id, l_request_id),
        program_application_id = NVL(program_application_id,
                                     l_program_application_id ),
        program_id = NVL(program_id, l_program_id),
        program_update_date = NVL(program_update_date,l_program_update_date)
    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 in (WIP_JOB_DETAILS.WIP_RES_USAGE,
                        WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
    AND   substitution_type = WIP_JOB_DETAILS.WIP_ADD;