APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1060: INSERT INTO WIP_OP_RESOURCE_INSTANCES (

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

Line 1142: UPDATE WIP_OP_RESOURCE_INSTANCES

1138: P_SERIAL_NUMBER => CUR_ROW.RESOURCE_SERIAL_NUMBER,
1139: P_ORGANIZATION_ID => P_ORGANIZATION_ID
1140: );
1141:
1142: UPDATE WIP_OP_RESOURCE_INSTANCES
1143: SET serial_number = nvl(cur_row.resource_serial_number,serial_number),
1144: last_update_date = sysdate,/*BUG 6721823*/
1145: last_updated_by = nvl(cur_row.last_updated_by,last_updated_by),
1146: creation_date = nvl(cur_row.creation_date,creation_date),

Line 1222: DELETE FROM WIP_OP_RESOURCE_INSTANCES

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