APPS.CE_SYSTEM_PARAMETERS_PKG dependencies on CE_SYSTEM_PARAMETERS

Line 1: PACKAGE BODY CE_SYSTEM_PARAMETERS_PKG as

1: PACKAGE BODY CE_SYSTEM_PARAMETERS_PKG as
2: /* $Header: cesyspab.pls 120.6 2006/01/12 18:49:28 eliu ship $ */
3: FUNCTION body_revision RETURN VARCHAR2 IS
4: BEGIN
5:

Line 54: CURSOR C IS SELECT rowid FROM CE_SYSTEM_PARAMETERS

50: X_Attribute13 VARCHAR2,
51: X_Attribute14 VARCHAR2,
52: X_Attribute15 VARCHAR2
53: ) IS
54: CURSOR C IS SELECT rowid FROM CE_SYSTEM_PARAMETERS
55: WHERE set_of_books_id = X_Set_Of_Books_Id;
56: BEGIN
57:
58:

Line 59: INSERT INTO CE_SYSTEM_PARAMETERS(

55: WHERE set_of_books_id = X_Set_Of_Books_Id;
56: BEGIN
57:
58:
59: INSERT INTO CE_SYSTEM_PARAMETERS(
60: legal_entity_id,
61: set_of_books_id,
62: cashbook_begin_date,
63: show_cleared_flag,

Line 177: FROM CE_SYSTEM_PARAMETERS

173: X_Attribute15 VARCHAR2
174: ) IS
175: CURSOR C IS
176: SELECT *
177: FROM CE_SYSTEM_PARAMETERS
178: WHERE rowid = X_Rowid
179: FOR UPDATE of Set_Of_Books_Id NOWAIT;
180: Recinfo C%ROWTYPE;
181:

Line 322: UPDATE CE_SYSTEM_PARAMETERS

318: X_Attribute15 VARCHAR2
319:
320: ) IS
321: BEGIN
322: UPDATE CE_SYSTEM_PARAMETERS
323: SET
324: set_of_books_id = X_Set_Of_Books_Id,
325: cashbook_begin_date = X_Cashbook_Begin_Date,
326: show_cleared_flag = X_Show_Cleared_Flag,

Line 365: DELETE FROM CE_SYSTEM_PARAMETERS

361: END Update_Row;
362:
363: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
364: BEGIN
365: DELETE FROM CE_SYSTEM_PARAMETERS
366: WHERE rowid = X_Rowid;
367:
368: if (SQL%NOTFOUND) then
369: Raise NO_DATA_FOUND;

Line 374: END CE_SYSTEM_PARAMETERS_PKG;

370: end if;
371: END Delete_Row;
372:
373:
374: END CE_SYSTEM_PARAMETERS_PKG;