APPS.WIP_RES_USAGE_DEFAULT dependencies on WIP_JOB_DETAILS

Line 23: (WIP_JOB_DETAILS.WIP_RES_USAGE, WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)

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

Line 24: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD

20: AND wip_entity_id = p_wip_entity_id
21: AND organization_id = p_organization_id
22: AND load_type in
23: (WIP_JOB_DETAILS.WIP_RES_USAGE, WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
24: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
25: ORDER BY operation_seq_num, resource_seq_num;
26:
27: Begin
28:

Line 37: WIP_JOB_DETAILS.WIP_ADD,

33: p_parent_header_id,p_wip_entity_id,
34: p_organization_id,
35: cur_row.operation_seq_num,
36: cur_row.resource_seq_num,
37: WIP_JOB_DETAILS.WIP_ADD,
38: x_err_code,
39: x_err_msg,
40: x_return_status);
41:

Line 88: IF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

84: x_return_status := FND_API.G_RET_STS_ERROR;
85: return;
86: END IF;
87:
88: IF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
89:
90: IF WIP_JOB_DETAILS.std_alone = 0 THEN
91:
92: SELECT COUNT(*) INTO l_parent_header

Line 90: IF WIP_JOB_DETAILS.std_alone = 0 THEN

86: END IF;
87:
88: IF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
89:
90: IF WIP_JOB_DETAILS.std_alone = 0 THEN
91:
92: SELECT COUNT(*) INTO l_parent_header
93: FROM WIP_JOB_SCHEDULE_INTERFACE
94: WHERE header_id = p_parent_header_id

Line 156: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,

152: AND wip_entity_id = p_wip_entity_id
153: AND organization_id = p_organization_id
154: AND operation_seq_num = p_operation_seq_num
155: AND resource_seq_num = p_resource_seq_num
156: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
157: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
158: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
159:
160: END IF;

Line 157: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)

153: AND organization_id = p_organization_id
154: AND operation_seq_num = p_operation_seq_num
155: AND resource_seq_num = p_resource_seq_num
156: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
157: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
158: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
159:
160: END IF;
161:

Line 158: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;

154: AND operation_seq_num = p_operation_seq_num
155: AND resource_seq_num = p_resource_seq_num
156: AND load_type in (WIP_JOB_DETAILS.WIP_RES_USAGE,
157: WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE)
158: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD;
159:
160: END IF;
161:
162: exception