APPS.CST_ITEM_OVERHEAD_DEFAULTS_PKG dependencies on CST_ITEM_OVERHEAD_DEFAULTS

Line 1: PACKAGE BODY CST_ITEM_OVERHEAD_DEFAULTS_PKG as

1: PACKAGE BODY CST_ITEM_OVERHEAD_DEFAULTS_PKG as
2: /* $Header: CSTPOVDB.pls 115.2 2002/11/11 19:20:13 awwang ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Organization_Id NUMBER,

Line 39: CURSOR C IS SELECT rowid FROM cst_item_overhead_defaults

35: X_Attribute14 VARCHAR2 DEFAULT NULL,
36: X_Attribute15 VARCHAR2 DEFAULT NULL
37:
38: ) IS
39: CURSOR C IS SELECT rowid FROM cst_item_overhead_defaults
40: WHERE organization_id = X_Organization_Id
41: AND ( (item_type = X_Item_Type)
42: or (item_type is NULL and X_Item_Type is NULL))
43: AND ( (category_id = X_Category_Id)

Line 54: INSERT INTO cst_item_overhead_defaults(

50:
51: BEGIN
52:
53:
54: INSERT INTO cst_item_overhead_defaults(
55: organization_id,
56: category_set_id,
57: category_id,
58: material_overhead_id,

Line 165: FROM cst_item_overhead_defaults

161:
162: ) IS
163: CURSOR C IS
164: SELECT *
165: FROM cst_item_overhead_defaults
166: WHERE rowid = X_Rowid
167: FOR UPDATE of Organization_Id,Item_Type,Category_Id,Material_Overhead_Id,
168: Activity_Id NOWAIT;
169: Recinfo C%ROWTYPE;

Line 303: UPDATE cst_item_overhead_defaults

299: X_Attribute15 VARCHAR2 DEFAULT NULL
300:
301: ) IS
302: BEGIN
303: UPDATE cst_item_overhead_defaults
304: SET
305: organization_id = X_Organization_Id,
306: category_set_id = X_Category_Set_Id,
307: category_id = X_Category_Id,

Line 345: DELETE FROM cst_item_overhead_defaults

341: END Update_Row;
342:
343: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
344: BEGIN
345: DELETE FROM cst_item_overhead_defaults
346: WHERE rowid = X_Rowid;
347:
348: if (SQL%NOTFOUND) then
349: Raise NO_DATA_FOUND;

Line 353: END CST_ITEM_OVERHEAD_DEFAULTS_PKG;

349: Raise NO_DATA_FOUND;
350: end if;
351: END Delete_Row;
352:
353: END CST_ITEM_OVERHEAD_DEFAULTS_PKG;