APPS.WIP_OPERATION_DEFAULT dependencies on WIP_JOB_DETAILS

Line 34: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION

30: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
31: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
32: AND wip_entity_id = p_wip_entity_id
33: AND organization_id = p_organization_id
34: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION
35: AND substitution_type = p_substitution_type
36: ORDER BY operation_seq_num;
37:
38: Begin

Line 127: IF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN

123: x_return_status := FND_API.G_RET_STS_ERROR;
124: return;
125: END IF;
126:
127: IF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
128:
129: IF p_standard_operation_id IS NOT NULL
130: AND p_standard_operation_id IS NOT NULL THEN
131:

Line 150: IF WIP_JOB_DETAILS.std_alone = 0 THEN

146: END IF;
147:
148: END IF;
149:
150: IF WIP_JOB_DETAILS.std_alone = 0 THEN
151:
152: SELECT COUNT(*) INTO l_parent_header
153: FROM WIP_JOB_SCHEDULE_INTERFACE
154: WHERE header_id = p_parent_header_id

Line 214: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION

210: WHERE group_id = p_group_id
211: AND (parent_header_id = p_parent_header_id OR
212: wip_entity_id = p_wip_entity_id)
213: AND organization_id = p_organization_id
214: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION
215: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
216: AND operation_seq_num = p_operation_seq_num;
217:
218: END Default_Oper;

Line 215: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD

211: AND (parent_header_id = p_parent_header_id OR
212: wip_entity_id = p_wip_entity_id)
213: AND organization_id = p_organization_id
214: AND load_type = WIP_JOB_DETAILS.WIP_OPERATION
215: AND substitution_type = WIP_JOB_DETAILS.WIP_ADD
216: AND operation_seq_num = p_operation_seq_num;
217:
218: END Default_Oper;
219: END WIP_OPERATION_DEFAULT;