APPS.BOM_RESOURCE_SHIFTS_PKG dependencies on BOM_RESOURCE_SHIFTS

Line 1: PACKAGE BODY BOM_RESOURCE_SHIFTS_PKG as

1: PACKAGE BODY BOM_RESOURCE_SHIFTS_PKG as
2: /* $Header: bompbrsb.pls 115.6 2002/11/19 03:12:09 lnarveka ship $ */
3:
4: PROCEDURE Check_References (X_department_Id NUMBER,
5: X_Resource_Id NUMBER,

Line 50: CURSOR C IS SELECT rowid FROM BOM_RESOURCE_SHIFTS

46: X_Attribute13 VARCHAR2 DEFAULT NULL,
47: X_Attribute14 VARCHAR2 DEFAULT NULL,
48: X_Attribute15 VARCHAR2 DEFAULT NULL
49: ) IS
50: CURSOR C IS SELECT rowid FROM BOM_RESOURCE_SHIFTS
51: WHERE department_id = X_Department_Id
52: AND resource_id = X_Resource_Id
53: AND shift_num = X_Shift_Num;
54: BEGIN

Line 55: INSERT INTO BOM_RESOURCE_SHIFTS(

51: WHERE department_id = X_Department_Id
52: AND resource_id = X_Resource_Id
53: AND shift_num = X_Shift_Num;
54: BEGIN
55: INSERT INTO BOM_RESOURCE_SHIFTS(
56: department_id,
57: resource_id,
58: shift_num,
59: Capacity_Units,

Line 141: CURSOR C IS SELECT * FROM BOM_RESOURCE_SHIFTS

137: X_Attribute13 VARCHAR2 DEFAULT NULL,
138: X_Attribute14 VARCHAR2 DEFAULT NULL,
139: X_Attribute15 VARCHAR2 DEFAULT NULL
140: ) IS
141: CURSOR C IS SELECT * FROM BOM_RESOURCE_SHIFTS
142: WHERE rowid = X_Rowid
143: FOR UPDATE of Department_Id NOWAIT;
144: Recinfo C%ROWTYPE;
145: BEGIN

Line 244: UPDATE BOM_RESOURCE_SHIFTS

240: X_Attribute14 VARCHAR2 DEFAULT NULL,
241: X_Attribute15 VARCHAR2 DEFAULT NULL
242: ) IS
243: BEGIN
244: UPDATE BOM_RESOURCE_SHIFTS
245: SET
246: department_id = X_Department_Id,
247: resource_id = X_Resource_Id,
248: shift_num = X_Shift_Num,

Line 279: DELETE FROM BOM_RESOURCE_SHIFTS

275:
276:
277: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
278: BEGIN
279: DELETE FROM BOM_RESOURCE_SHIFTS
280: WHERE rowid = X_Rowid;
281: if (SQL%NOTFOUND) then
282: Raise NO_DATA_FOUND;
283: end if;

Line 288: END BOM_RESOURCE_SHIFTS_PKG;

284: END Delete_Row;
285:
286:
287:
288: END BOM_RESOURCE_SHIFTS_PKG;