APPS.WIP_FIX_REQ_OPS_PKG dependencies on WIP_REQUIREMENT_OPERATIONS

Line 10: FROM WIP_REQUIREMENT_OPERATIONS WRO

6: X_Repetitive_Schedule_Id NUMBER,
7: X_Entity_Start_Date DATE) IS
8: CURSOR Cdisc IS
9: SELECT DISTINCT ABS(OPERATION_SEQ_NUM) OPERATION_SEQ_NUM
10: FROM WIP_REQUIREMENT_OPERATIONS WRO
11: WHERE WRO.WIP_ENTITY_ID = X_Wip_Entity_Id
12: AND WRO.ORGANIZATION_ID = X_Organization_Id
13: AND NOT EXISTS
14: (SELECT 'op exists'

Line 22: FROM WIP_REQUIREMENT_OPERATIONS WRO

18: AND WO.OPERATION_SEQ_NUM = ABS(WRO.OPERATION_SEQ_NUM));
19: /* Bug fix 1304144*/
20: CURSOR Crep IS
21: SELECT DISTINCT OPERATION_SEQ_NUM
22: FROM WIP_REQUIREMENT_OPERATIONS WRO
23: WHERE WRO.WIP_ENTITY_ID = X_Wip_Entity_Id
24: AND WRO.ORGANIZATION_ID = X_Organization_Id
25: AND WRO.REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
26: AND NOT EXISTS

Line 38: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

34: BEGIN
35: IF X_Repetitive_Schedule_Id IS NULL THEN
36: /* Just update the department and date_required if the op exists */
37:
38: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
39: SET (WRO.DEPARTMENT_ID, WRO.DATE_REQUIRED) =
40: (SELECT DEPARTMENT_ID, FIRST_UNIT_START_DATE
41: FROM WIP_OPERATIONS WO
42: WHERE WO.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID

Line 66: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

62: X_Entity_Start_Date
63: );
64: END LOOP;
65: ELSE
66: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
67: SET (WRO.DEPARTMENT_ID, WRO.DATE_REQUIRED) =
68: (SELECT DEPARTMENT_ID, FIRST_UNIT_START_DATE
69: FROM WIP_OPERATIONS WO
70: WHERE WO.WIP_ENTITY_ID = WRO.WIP_ENTITY_ID