APPS.CST_COST_TYPES_PKG dependencies on CST_COST_TYPES

Line 1: PACKAGE BODY CST_COST_TYPES_PKG as

1: PACKAGE BODY CST_COST_TYPES_PKG as
2: /* $Header: cstpcctb.pls 115.2 2002/11/11 23:05:48 awwang ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Cost_Type_Id IN OUT NOCOPY NUMBER,

Line 44: CURSOR C IS SELECT rowid FROM cst_cost_types

40: X_Attribute14 VARCHAR2 DEFAULT NULL,
41: X_Attribute15 VARCHAR2 DEFAULT NULL,
42: X_Alternate_Bom_Designator VARCHAR2 DEFAULT NULL
43: ) IS
44: CURSOR C IS SELECT rowid FROM cst_cost_types
45:
46: WHERE cost_type_id = X_Cost_Type_Id;
47:
48:

Line 52: CURSOR C2 IS SELECT cst_cost_types_s.nextval FROM sys.dual;

48:
49:
50:
51:
52: CURSOR C2 IS SELECT cst_cost_types_s.nextval FROM sys.dual;
53: BEGIN
54:
55: if (X_Cost_Type_Id is NULL) then
56: OPEN C2;

Line 63: INSERT INTO cst_cost_types(

59: end if;
60: if (X_Default_Cost_Type_Id is NULL) then
61: X_Default_Cost_Type_Id := X_Cost_Type_Id;
62: end if;
63: INSERT INTO cst_cost_types(
64: cost_type_id,
65: last_update_date,
66: last_updated_by,
67: creation_date,

Line 189: FROM cst_cost_types

185: X_Alternate_Bom_Designator VARCHAR2 DEFAULT NULL
186: ) IS
187: CURSOR C IS
188: SELECT *
189: FROM cst_cost_types
190: WHERE rowid = X_Rowid
191: FOR UPDATE of Cost_Type_Id NOWAIT;
192: Recinfo C%ROWTYPE;
193: BEGIN

Line 348: UPDATE cst_cost_types

344: X_Attribute15 VARCHAR2 DEFAULT NULL,
345: X_Alternate_Bom_Designator VARCHAR2 DEFAULT NULL
346: ) IS
347: BEGIN
348: UPDATE cst_cost_types
349: SET
350:
351: cost_type_id = X_Cost_Type_Id,
352: last_update_date = X_Last_Update_Date,

Line 397: DELETE FROM cst_cost_types

393: END Update_Row;
394:
395: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
396: BEGIN
397: DELETE FROM cst_cost_types
398: WHERE rowid = X_Rowid;
399:
400: if (SQL%NOTFOUND) then
401: RAISE NO_DATA_FOUND;

Line 405: END CST_COST_TYPES_PKG;

401: RAISE NO_DATA_FOUND;
402: end if;
403: END Delete_Row;
404:
405: END CST_COST_TYPES_PKG;