APPS.WIP_OPERATIONS_UTILITIES dependencies on WIP_OPERATION_RESOURCES

Line 58: FROM WIP_OPERATION_RESOURCES

54: AND (FM_OPERATION_SEQ_NUM = X_Operation_Seq_Num
55: OR TO_OPERATION_SEQ_NUM = X_Operation_Seq_Num);
56: cursor disc_res_check is
57: SELECT 1
58: FROM WIP_OPERATION_RESOURCES
59: WHERE ORGANIZATION_ID = X_Organization_Id
60: AND WIP_ENTITY_ID = X_Wip_Entity_Id
61: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
62: AND APPLIED_RESOURCE_UNITS <> 0;

Line 79: FROM WIP_OPERATION_RESOURCES

75: AND (FM_OPERATION_SEQ_NUM = X_Operation_Seq_Num
76: OR TO_OPERATION_SEQ_NUM = X_Operation_Seq_Num);
77: cursor rep_res_check is
78: SELECT 1
79: FROM WIP_OPERATION_RESOURCES
80: WHERE ORGANIZATION_ID = X_Organization_Id
81: AND WIP_ENTITY_ID = X_Wip_Entity_Id
82: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
83: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num

Line 351: INSERT INTO WIP_OPERATION_RESOURCES

347: l_wsor_max_res_seq_num number :=0;
348: /* End : -- bug 7371859 */
349:
350: BEGIN
351: INSERT INTO WIP_OPERATION_RESOURCES
352: (WIP_ENTITY_ID, OPERATION_SEQ_NUM,
353: RESOURCE_SEQ_NUM, ORGANIZATION_ID,
354: REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
355: LAST_UPDATED_BY, CREATION_DATE,

Line 787: FROM wip_operation_resources

783: BEGIN
784: IF X_Repetitive_Schedule_Id is NULL THEN
785: SELECT count(resource_id)
786: INTO resct
787: FROM wip_operation_resources
788: WHERE wip_entity_id = X_Wip_Entity_Id
789: AND organization_id = X_Organization_Id
790: AND operation_seq_num = X_Operation_Seq_Num;
791: ELSE

Line 794: FROM wip_operation_resources

790: AND operation_seq_num = X_Operation_Seq_Num;
791: ELSE
792: SELECT count(resource_id)
793: INTO resct
794: FROM wip_operation_resources
795: WHERE wip_entity_id = X_Wip_Entity_Id
796: AND organization_id = X_Organization_Id
797: AND operation_seq_num = X_Operation_Seq_Num
798: AND repetitive_schedule_id = X_Repetitive_Schedule_Id;

Line 1000: UPDATE WIP_OPERATION_RESOURCES

996: X_New_Operation_Seq_Num NUMBER,
997: X_Repetitive_Schedule_Id NUMBER) IS
998: BEGIN
999: IF X_Repetitive_Schedule_Id IS NULL THEN
1000: UPDATE WIP_OPERATION_RESOURCES
1001: SET OPERATION_SEQ_NUM = X_New_Operation_Seq_num
1002: WHERE ORGANIZATION_ID = X_Organization_Id
1003: AND WIP_ENTITY_ID = X_Wip_Entity_Id
1004: AND OPERATION_SEQ_NUM = X_Old_Operation_Seq_Num;

Line 1006: UPDATE WIP_OPERATION_RESOURCES

1002: WHERE ORGANIZATION_ID = X_Organization_Id
1003: AND WIP_ENTITY_ID = X_Wip_Entity_Id
1004: AND OPERATION_SEQ_NUM = X_Old_Operation_Seq_Num;
1005: ELSE
1006: UPDATE WIP_OPERATION_RESOURCES
1007: SET OPERATION_SEQ_NUM = X_New_Operation_Seq_num
1008: WHERE ORGANIZATION_ID = X_Organization_Id
1009: AND WIP_ENTITY_ID = X_Wip_Entity_Id
1010: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id