APPS.WIP_RES_USAGE_SUBSTITUTIONS dependencies on WIP_JOB_DETAILS

Line 21: AND load_type = WIP_JOB_DETAILS.WIP_RES_USAGE

17: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
18: AND process_status = WIP_CONSTANTS.RUNNING
19: AND wip_entity_id = p_wip_entity_id
20: AND organization_id = p_organization_id
21: AND load_type = WIP_JOB_DETAILS.WIP_RES_USAGE
22: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
23: ORDER BY operation_seq_num, resource_seq_num;
24:
25:

Line 22: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD

18: AND process_status = WIP_CONSTANTS.RUNNING
19: AND wip_entity_id = p_wip_entity_id
20: AND organization_id = p_organization_id
21: AND load_type = WIP_JOB_DETAILS.WIP_RES_USAGE
22: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
23: ORDER BY operation_seq_num, resource_seq_num;
24:
25:
26: Begin

Line 62: AND load_type = WIP_JOB_DETAILS.WIP_RES_USAGE

58: AND wip_entity_id = p_wip_entity_id
59: AND organization_id = p_organization_id
60: AND operation_seq_num = p_operation_seq_num
61: AND resource_seq_num = p_resource_seq_num
62: AND load_type = WIP_JOB_DETAILS.WIP_RES_USAGE
63: ORDER BY start_date;
64:
65: l_start_date date;
66: l_end_date date;

Line 104: IF cur_update.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

100: FOR cur_update IN Usage_Update(p_group_id , p_wip_entity_id,
101: p_organization_id, p_operation_seq_num,
102: p_resource_seq_num ) LOOP
103:
104: IF cur_update.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
105:
106: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
107: ( WIP_ENTITY_ID ,
108: ORGANIZATION_ID,