DBA Data[Home] [Help]

APPS.GL_CONS_MAPPING_SET_PKG dependencies on GL_CONSOLIDATION_SETS

Line 41: CURSOR C IS SELECT rowid FROM GL_CONSOLIDATION_SETS

37: X_Attribute13 VARCHAR2,
38: X_Attribute14 VARCHAR2,
39: X_Attribute15 VARCHAR2
40: ) IS
41: CURSOR C IS SELECT rowid FROM GL_CONSOLIDATION_SETS
42: WHERE consolidation_set_id = X_Consolidation_Set_Id;
43:
44: BEGIN
45:

Line 46: INSERT INTO GL_CONSOLIDATION_SETS(

42: WHERE consolidation_set_id = X_Consolidation_Set_Id;
43:
44: BEGIN
45:
46: INSERT INTO GL_CONSOLIDATION_SETS(
47: consolidation_set_id,
48: to_ledger_id,
49: name,
50: last_update_date,

Line 158: UPDATE GL_CONSOLIDATION_SETS

154: ) IS
155:
156: BEGIN
157:
158: UPDATE GL_CONSOLIDATION_SETS
159: SET
160: consolidation_set_id = X_Consolidation_Set_Id,
161: to_ledger_id = X_parent_ledger_id,
162: name = X_Consolidation_Set_Name,

Line 233: CURSOR C IS SELECT * FROM GL_CONSOLIDATION_SETS

229: X_Attribute13 VARCHAR2,
230: X_Attribute14 VARCHAR2,
231: X_Attribute15 VARCHAR2
232: ) IS
233: CURSOR C IS SELECT * FROM GL_CONSOLIDATION_SETS
234: WHERE rowid = X_Rowid
235: FOR UPDATE of consolidation_set_id NOWAIT;
236: Recinfo C%ROWTYPE;
237:

Line 375: DELETE FROM GL_CONSOLIDATION_SETS

371: X_Security_Flag VARCHAR2
372: ) IS
373: BEGIN
374:
375: DELETE FROM GL_CONSOLIDATION_SETS
376: WHERE rowid = X_Rowid;
377:
378: IF ( SQL%NOTFOUND ) THEN
379: RAISE NO_DATA_FOUND;

Line 388: FROM GL_CONSOLIDATION_SETS glc

384: PROCEDURE Check_Unique_Name(X_Rowid VARCHAR2,
385: X_Name VARCHAR2) IS
386: CURSOR check_dups IS
387: SELECT 1
388: FROM GL_CONSOLIDATION_SETS glc
389: WHERE glc.name = X_Name
390: AND ( X_Rowid is NULL
391: OR glc.rowid <> X_Rowid);
392: