APPS.WSMPWROT dependencies on WIP_OPERATION_RESOURCES

Line 1055: FROM WIP_OPERATION_RESOURCES

1051: l_stmt_num := 130;
1052:
1053: SELECT max(resource_seq_num)
1054: INTO x_max_resc_seq_num
1055: FROM WIP_OPERATION_RESOURCES
1056: WHERE wip_entity_id = p_wip_entity_id
1057: and organization_id = p_organization_id
1058: and operation_seq_num = x_operation_seq_num;
1059:

Line 1074: FROM WIP_OPERATION_RESOURCES

1070: program_application_id, program_id, program_update_date
1071: INTO x_last_update_date, x_last_updated_by, x_creation_date,
1072: x_created_by, x_last_update_login, x_request_id,
1073: x_program_application_id, x_program_id, x_program_update_date
1074: FROM WIP_OPERATION_RESOURCES
1075: WHERE wip_entity_id = p_wip_entity_id
1076: and organization_id = p_organization_id
1077: and resource_seq_num = x_max_resc_seq_num
1078: and operation_seq_num = x_operation_seq_num;

Line 1096: * information to WIP_OPERATION_RESOURCES *

1092: end;
1093:
1094: /* --------------------------------------------------------- *
1095: * GO through the cursor. Populate phantom resources *
1096: * information to WIP_OPERATION_RESOURCES *
1097: * ----------------------------------------------------------*/
1098: l_stmt_num := 160;
1099: FOR cur_resc IN phan_resc_cursor LOOP
1100: /* set resource_seq_num to be unique */

Line 1115: INSERT INTO WIP_OPERATION_RESOURCES(

1111:
1112: l_stmt_num := 180;
1113:
1114: /* insert phantom resources */
1115: INSERT INTO WIP_OPERATION_RESOURCES(
1116: wip_entity_id,
1117: operation_seq_num,
1118: resource_seq_num,
1119: organization_id,