APPS.WIP_RES_USAGE_SUBSTITUTIONS dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 92: DELETE FROM WIP_OPERATION_RESOURCE_USAGE

88: CHECK THAT IF GROUP_ID, ORGANIZATION_ID, WIP_ENTITY_ID,
89: OPERATION_SEQ_NUM AND RESOURCE_SEQ_NUM IS NULL
90: **********************************************************************/
91:
92: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
93: WHERE wip_entity_id = p_wip_entity_id
94: AND organization_id = p_organization_id
95: AND operation_seq_num = p_operation_seq_num
96: AND resource_seq_num = p_resource_seq_num;

Line 106: INSERT INTO WIP_OPERATION_RESOURCE_USAGE

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,
109: OPERATION_SEQ_NUM,
110: RESOURCE_SEQ_NUM,