APPS.WIP_WPS_CAPACITY_CHANGES_PKG dependencies on BOM_RESOURCE_CHANGES

Line 27: FROM BOM_RESOURCE_CHANGES

23: SELECT DEPARTMENT_ID,RESOURCE_ID,SHIFT_NUM,FROM_DATE,
24: SIMULATION_SET,ACTION_TYPE
25: INTO l_department_id,l_resource_id,l_shift_num,l_from_date,
26: l_simulation_set,l_action_type
27: FROM BOM_RESOURCE_CHANGES
28: WHERE ROWID = X_Rowid;
29:
30: SELECT COUNT(*) INTO l_instance_count
31: FROM BOM_RES_INSTANCE_CHANGES

Line 50: DELETE FROM BOM_RESOURCE_CHANGES

46: ACTION_TYPE = l_action_type;
47:
48: end if;
49:
50: DELETE FROM BOM_RESOURCE_CHANGES
51: WHERE rowid = X_Rowid;
52:
53: COMMIT;
54:

Line 108: FROM BOM_RESOURCE_CHANGES

104: --the resource is scheduled to instance or not
105:
106: --if(l_sch_instance = 1) then
107: SELECT COUNT(*) INTO l_record_exists
108: FROM BOM_RESOURCE_CHANGES
109: WHERE DEPARTMENT_ID = l_department_id AND
110: RESOURCE_ID = l_resource_id AND
111: SHIFT_NUM = l_shift_num AND
112: FROM_DATE = l_from_date AND

Line 122: FROM BOM_RESOURCE_CHANGES

118: --end if;
119:
120: if (l_record_exists <> 0) then
121: SELECT CAPACITY_CHANGE INTO l_capacity_units
122: FROM BOM_RESOURCE_CHANGES
123: WHERE DEPARTMENT_ID = l_department_id AND
124: RESOURCE_ID = l_resource_id AND
125: SHIFT_NUM = l_shift_num AND
126: FROM_DATE = l_from_date AND

Line 140: UPDATE BOM_RESOURCE_CHANGES

136: elsif (l_capacity_units < 1) then
137: l_capacity_units := l_capacity_units - (-1);
138: end if;
139:
140: UPDATE BOM_RESOURCE_CHANGES
141: SET CAPACITY_CHANGE = l_capacity_units
142: WHERE DEPARTMENT_ID = l_department_id AND
143: RESOURCE_ID = l_resource_id AND
144: SHIFT_NUM = l_shift_num AND

Line 153: DELETE FROM BOM_RESOURCE_CHANGES

149: SIMULATION_SET = l_simulation_set AND
150: ACTION_TYPE = l_action_type;
151:
152: elsif( (l_capacity_units = 1) OR (l_capacity_units = -1)) then
153: DELETE FROM BOM_RESOURCE_CHANGES
154: WHERE DEPARTMENT_ID = l_department_id AND
155: RESOURCE_ID = l_resource_id AND
156: SHIFT_NUM = l_shift_num AND
157: FROM_DATE = l_from_date AND

Line 239: FROM BOM_RESOURCE_CHANGES

235: INTO
236: t_resource_id, t_department_id, t_simulation_set, t_shift_num,
237: t_action_type, t_units, t_from_date,
238: t_to_date, t_from_time, t_to_time
239: FROM BOM_RESOURCE_CHANGES
240: WHERE ROWID = l_rowid;
241:
242:
243: UPDATE BOM_RESOURCE_CHANGES

Line 243: UPDATE BOM_RESOURCE_CHANGES

239: FROM BOM_RESOURCE_CHANGES
240: WHERE ROWID = l_rowid;
241:
242:
243: UPDATE BOM_RESOURCE_CHANGES
244: SET
245: SHIFT_NUM = l_shift_num,
246: ACTION_TYPE = l_action_type,
247: CAPACITY_CHANGE = l_units,

Line 330: FROM BOM_RESOURCE_CHANGES

326: l_action_type := 2;
327: end if;
328:
329: SELECT COUNT(*) INTO l_record_count
330: FROM BOM_RESOURCE_CHANGES
331: WHERE DEPARTMENT_ID = l_department_id AND
332: RESOURCE_ID = l_resource_id AND
333: SHIFT_NUM = l_shift_num AND
334: FROM_DATE = l_from_date AND

Line 343: INSERT INTO BOM_RESOURCE_CHANGES (

339: ACTION_TYPE = l_action_type;
340:
341: if (l_record_count = 0) then
342:
343: INSERT INTO BOM_RESOURCE_CHANGES (
344: DEPARTMENT_ID, RESOURCE_ID, SHIFT_NUM, ACTION_TYPE,
345: CAPACITY_CHANGE, FROM_DATE, TO_DATE, FROM_TIME,
346: TO_TIME, SIMULATION_SET, LAST_UPDATE_DATE,
347: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, REASON_CODE)

Line 354: UPDATE BOM_RESOURCE_CHANGES

350: l_units, l_from_date, l_to_date, l_from_time,
351: l_to_time,l_sim_set, sysdate,
352: l_user_id, sysdate, l_user_id, X_REASON_CODE);
353: else
354: UPDATE BOM_RESOURCE_CHANGES
355: SET CAPACITY_CHANGE = CAPACITY_CHANGE + l_units,
356: LAST_UPDATE_DATE = sysdate,
357: LAST_UPDATED_BY = l_user_id
358: WHERE DEPARTMENT_ID = l_department_id AND

Line 576: FROM BOM_RESOURCE_CHANGES

572: WHERE RESOURCE_ID = l_resource_id and
573: DEPARTMENT_ID = l_department_id;
574:
575: SELECT COUNT(*) INTO l_record_count
576: FROM BOM_RESOURCE_CHANGES
577: WHERE DEPARTMENT_ID = l_department_id AND
578: RESOURCE_ID = l_resource_id AND
579: SHIFT_NUM = l_shift_num AND
580: FROM_DATE = l_from_date AND

Line 590: FROM BOM_RESOURCE_CHANGES

586:
587:
588: if(l_record_count <> 0) then
589: SELECT nvl(CAPACITY_CHANGE,999999) into l_current_units
590: FROM BOM_RESOURCE_CHANGES
591: WHERE DEPARTMENT_ID = l_department_id AND
592: RESOURCE_ID = l_resource_id AND
593: SHIFT_NUM = l_shift_num AND
594: SIMULATION_SET = l_sim_set AND