APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1061: INSERT INTO WIP_OP_RESOURCE_INSTANCES (

1057: p_wip_entity_id,
1058: p_organization_id) LOOP
1059:
1060: /* insert into table */
1061: INSERT INTO WIP_OP_RESOURCE_INSTANCES (
1062: WIP_ENTITY_ID,
1063: OPERATION_SEQ_NUM,
1064: RESOURCE_SEQ_NUM,
1065: ORGANIZATION_ID,

Line 1143: UPDATE WIP_OP_RESOURCE_INSTANCES

1139: P_SERIAL_NUMBER => CUR_ROW.RESOURCE_SERIAL_NUMBER,
1140: P_ORGANIZATION_ID => P_ORGANIZATION_ID
1141: );
1142:
1143: UPDATE WIP_OP_RESOURCE_INSTANCES
1144: SET serial_number = nvl(cur_row.resource_serial_number,serial_number),
1145: last_update_date = sysdate,/*BUG 6721823*/
1146: /*FP BUG 13406111 :BUG 12814417 @Start */
1147: last_updated_by = fnd_global.user_id,

Line 1225: DELETE FROM WIP_OP_RESOURCE_INSTANCES

1221: P_SERIAL_NUMBER => CUR_ROW.RESOURCE_SERIAL_NUMBER,
1222: P_ORGANIZATION_ID => P_ORGANIZATION_ID
1223: );
1224:
1225: DELETE FROM WIP_OP_RESOURCE_INSTANCES
1226: WHERE wip_entity_id = p_wip_entity_id
1227: AND organization_id = p_organization_id
1228: AND operation_seq_num = cur_row.operation_seq_num
1229: AND resource_seq_num = cur_row.resource_seq_num