APPS.WPS_CAPACITY_CHANGES_PKG dependencies on BOM_RES_INSTANCE_CHANGES

Line 31: FROM BOM_RES_INSTANCE_CHANGES

27: FROM BOM_RESOURCE_CHANGES
28: WHERE ROWID = X_Rowid;
29:
30: SELECT COUNT(*) INTO l_instance_count
31: FROM BOM_RES_INSTANCE_CHANGES
32: WHERE DEPARTMENT_ID = l_department_id AND
33: RESOURCE_ID = l_resource_id AND
34: SHIFT_NUM = l_shift_num AND
35: FROM_DATE = l_from_date AND

Line 40: DELETE FROM BOM_RES_INSTANCE_CHANGES

36: SIMULATION_SET = l_simulation_set AND
37: ACTION_TYPE = l_action_type;
38:
39: if( l_instance_count <> 0 ) then
40: DELETE FROM BOM_RES_INSTANCE_CHANGES
41: WHERE DEPARTMENT_ID = l_department_id AND
42: RESOURCE_ID = l_resource_id AND
43: SHIFT_NUM = l_shift_num AND
44: FROM_DATE = l_from_date AND

Line 89: FROM BOM_RES_INSTANCE_CHANGES

85: SIMULATION_SET,ACTION_TYPE,FROM_TIME,TO_TIME
86: INTO l_department_id,l_resource_id,l_shift_num,l_from_date,
87: l_to_date,l_simulation_set,l_action_type,l_from_time,
88: l_to_time
89: FROM BOM_RES_INSTANCE_CHANGES
90: WHERE ROWID = X_Rowid;
91:
92: --Get the schedule to instance flag for the department resource
93: SELECT SCHEDULE_TO_INSTANCE

Line 166: DELETE FROM BOM_RES_INSTANCE_CHANGES

162: ACTION_TYPE = l_action_type;
163: end if;
164: end if;
165:
166: DELETE FROM BOM_RES_INSTANCE_CHANGES
167: WHERE rowid = X_Rowid;
168:
169: COMMIT;
170:

Line 258: UPDATE BOM_RES_INSTANCE_CHANGES

254: reason_code = x_reason_code
255: WHERE ROWID = l_rowid;
256:
257:
258: UPDATE BOM_RES_INSTANCE_CHANGES
259: SET
260: FROM_DATE = l_from_date,
261: TO_DATE = l_to_date,
262: FROM_TIME = l_from_time,

Line 430: INSERT INTO BOM_RES_INSTANCE_CHANGES (

426: if(l_action_type = 0) then
427: l_action_type := 2;
428: end if;
429:
430: INSERT INTO BOM_RES_INSTANCE_CHANGES (
431: DEPARTMENT_ID, RESOURCE_ID, SHIFT_NUM, ACTION_TYPE,
432: CAPACITY_CHANGE, FROM_DATE, TO_DATE, FROM_TIME,
433: TO_TIME, SIMULATION_SET, INSTANCE_ID, SERIAL_NUMBER,
434: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,

Line 497: UPDATE BOM_RES_INSTANCE_CHANGES

493: if (l_action_type = 0) then
494: l_action_type := 2;
495: end if;
496:
497: UPDATE BOM_RES_INSTANCE_CHANGES
498: SET
499: SHIFT_NUM = l_shift_num,
500: ACTION_TYPE = l_action_type,
501: CAPACITY_CHANGE = l_units,