APPS.CST_RESOURCE_OVERHEADS_PKG dependencies on CST_RESOURCE_OVERHEADS

Line 1: PACKAGE BODY CST_RESOURCE_OVERHEADS_PKG as

1: PACKAGE BODY CST_RESOURCE_OVERHEADS_PKG as
2: /* $Header: cstrovhb.pls 115.3 2002/11/11 23:21:14 awwang ship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 32: CURSOR C IS SELECT rowid FROM cst_resource_overheads

28: X_Attribute13 VARCHAR2 DEFAULT NULL,
29: X_Attribute14 VARCHAR2 DEFAULT NULL,
30: X_Attribute15 VARCHAR2 DEFAULT NULL
31: ) IS
32: CURSOR C IS SELECT rowid FROM cst_resource_overheads
33: WHERE cost_type_id = X_Cost_Type_Id
34: AND resource_id = X_Resource_Id
35: AND overhead_id = X_Overhead_Id;
36:

Line 39: INSERT INTO cst_resource_overheads(

35: AND overhead_id = X_Overhead_Id;
36:
37: BEGIN
38:
39: INSERT INTO cst_resource_overheads(
40: cost_type_id,
41: resource_id,
42: overhead_id,
43: last_update_date,

Line 127: FROM cst_resource_overheads

123: X_Attribute15 VARCHAR2 DEFAULT NULL
124: ) IS
125: CURSOR C IS
126: SELECT *
127: FROM cst_resource_overheads
128: WHERE rowid = X_Rowid
129: FOR UPDATE of Cost_Type_Id NOWAIT;
130: Recinfo C%ROWTYPE;
131: BEGIN

Line 235: UPDATE cst_resource_overheads

231: X_Attribute15 VARCHAR2 DEFAULT NULL
232: ) IS
233: BEGIN
234:
235: UPDATE cst_resource_overheads
236: SET
237: cost_type_id = X_Cost_Type_Id,
238: resource_id = X_Resource_Id,
239: overhead_id = X_Overhead_Id,

Line 270: DELETE FROM cst_resource_overheads

266: END Update_Row;
267:
268: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
269: BEGIN
270: DELETE FROM cst_resource_overheads
271: WHERE rowid = X_Rowid;
272:
273: if (SQL%NOTFOUND) then
274: RAISE NO_DATA_FOUND;

Line 278: END CST_RESOURCE_OVERHEADS_PKG;

274: RAISE NO_DATA_FOUND;
275: end if;
276: END Delete_Row;
277:
278: END CST_RESOURCE_OVERHEADS_PKG;