APPS.CST_DEPARTMENT_OVERHEADS_PKG dependencies on CST_DEPARTMENT_OVERHEADS

Line 1: PACKAGE BODY CST_DEPARTMENT_OVERHEADS_PKG as

1: PACKAGE BODY CST_DEPARTMENT_OVERHEADS_PKG as
2: /* $Header: cstpcdob.pls 115.3 2002/11/11 23:20:11 awwang ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Department_Id NUMBER,

Line 35: CURSOR C IS SELECT rowid FROM CST_DEPARTMENT_OVERHEADS

31: X_Attribute14 VARCHAR2 DEFAULT NULL,
32: X_Attribute15 VARCHAR2 DEFAULT NULL
33:
34: ) IS
35: CURSOR C IS SELECT rowid FROM CST_DEPARTMENT_OVERHEADS
36: WHERE cost_type_id = X_Cost_Type_Id
37:
38: AND department_id = X_Department_Id
39:

Line 47: INSERT INTO CST_DEPARTMENT_OVERHEADS(

43:
44: BEGIN
45:
46:
47: INSERT INTO CST_DEPARTMENT_OVERHEADS(
48: department_id,
49: cost_type_id,
50: overhead_id,
51: last_update_date,

Line 146: FROM CST_DEPARTMENT_OVERHEADS

142:
143: ) IS
144: CURSOR C IS
145: SELECT *
146: FROM CST_DEPARTMENT_OVERHEADS
147: WHERE rowid = X_Rowid
148: FOR UPDATE of Cost_Type_Id NOWAIT;
149: Recinfo C%ROWTYPE;
150: BEGIN

Line 259: UPDATE CST_DEPARTMENT_OVERHEADS

255: X_Attribute15 VARCHAR2 DEFAULT NULL
256:
257: ) IS
258: BEGIN
259: UPDATE CST_DEPARTMENT_OVERHEADS
260: SET
261: department_id = X_Department_Id,
262: cost_type_id = X_Cost_Type_Id,
263: overhead_id = X_Overhead_Id,

Line 297: DELETE FROM CST_DEPARTMENT_OVERHEADS

293: END Update_Row;
294:
295: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
296: BEGIN
297: DELETE FROM CST_DEPARTMENT_OVERHEADS
298: WHERE rowid = X_Rowid;
299:
300: if (SQL%NOTFOUND) then
301: Raise NO_DATA_FOUND;

Line 305: END CST_DEPARTMENT_OVERHEADS_PKG;

301: Raise NO_DATA_FOUND;
302: end if;
303: END Delete_Row;
304:
305: END CST_DEPARTMENT_OVERHEADS_PKG;