APPS.GL_CONS_ACCOUNTS_PKG dependencies on GL_CONSOLIDATION_ACCOUNTS

Line 15: FROM GL_CONSOLIDATION_ACCOUNTS glca

11: X_From_Ledger_Id NUMBER) RETURN BOOLEAN IS
12: cons_run_id NUMBER;
13: CURSOR accts is
14: SELECT consolidation_id
15: FROM GL_CONSOLIDATION_ACCOUNTS glca
16: WHERE glca.consolidation_id = X_Consolidation_Id
17: AND glca.consolidation_run_id = cons_run_id ;
18:
19: dummy NUMBER;

Line 32: LOCK TABLE gl_consolidation_accounts IN SHARE UPDATE MODE;

28: FETCH accts INTO dummy;
29:
30: IF (accts%FOUND) THEN
31: CLOSE accts;
32: LOCK TABLE gl_consolidation_accounts IN SHARE UPDATE MODE;
33: INSERT INTO GL_CONSOLIDATION_ACCOUNTS
34: (consolidation_run_id, consolidation_id, last_update_date,
35: last_updated_by, from_ledger_id, element_sequence,
36: segment1_low, segment1_high, segment2_low, segment2_high,

Line 33: INSERT INTO GL_CONSOLIDATION_ACCOUNTS

29:
30: IF (accts%FOUND) THEN
31: CLOSE accts;
32: LOCK TABLE gl_consolidation_accounts IN SHARE UPDATE MODE;
33: INSERT INTO GL_CONSOLIDATION_ACCOUNTS
34: (consolidation_run_id, consolidation_id, last_update_date,
35: last_updated_by, from_ledger_id, element_sequence,
36: segment1_low, segment1_high, segment2_low, segment2_high,
37: segment3_low, segment3_high, segment4_low, segment4_high,

Line 68: FROM GL_CONSOLIDATION_ACCOUNTS

64: segment23_low, segment23_high, segment24_low, segment24_high,
65: segment25_low, segment25_high, segment26_low, segment26_high,
66: segment27_low, segment27_high, segment28_low, segment28_high,
67: segment29_low, segment29_high, segment30_low, segment30_high
68: FROM GL_CONSOLIDATION_ACCOUNTS
69: WHERE X_Consolidation_Id = consolidation_id
70: AND consolidation_run_id =
71: (select max(consolidation_run_id)
72: from gl_consolidation_accounts

Line 72: from gl_consolidation_accounts

68: FROM GL_CONSOLIDATION_ACCOUNTS
69: WHERE X_Consolidation_Id = consolidation_id
70: AND consolidation_run_id =
71: (select max(consolidation_run_id)
72: from gl_consolidation_accounts
73: where consolidation_id = X_Consolidation_Id);
74: RETURN TRUE;
75: ELSE
76: CLOSE accts;

Line 95: FROM GL_CONSOLIDATION_ACCOUNTS gca

91: X_Element_Sequence NUMBER) IS
92:
93: CURSOR elem_seq IS
94: SELECT 'x'
95: FROM GL_CONSOLIDATION_ACCOUNTS gca
96: WHERE gca.consolidation_id = X_Consolidation_Id
97: AND gca.consolidation_run_id = X_Consolidation_Run_Id
98: AND gca.element_sequence = X_Element_Sequence
99: AND (X_Rowid is null OR X_Rowid <> gca.rowid);

Line 184: FROM GL_CONSOLIDATION_ACCOUNTS

180: X_Segment30_High VARCHAR2
181: ) IS
182: CURSOR Account_Ranges_Overlap IS
183: SELECT 'x'
184: FROM GL_CONSOLIDATION_ACCOUNTS
185: WHERE consolidation_id = X_Consolidation_Id
186: AND consolidation_run_id = X_Consolidation_Run_Id
187: AND (X_Rowid is null OR X_Rowid <> rowid)
188: AND ( nvl(segment1_low, 'x') <= nvl(X_Segment1_High, 'x')

Line 271: FROM GL_CONSOLIDATION_ACCOUNTS gca

267: X_Consolidation_Run_Id NUMBER) RETURN BOOLEAN IS
268:
269: CURSOR range_count IS
270: SELECT 'y'
271: FROM GL_CONSOLIDATION_ACCOUNTS gca
272: WHERE gca.consolidation_id = X_Consolidation_Id
273: AND gca.consolidation_run_id = X_Consolidation_Run_Id;
274:
275: var1 VARCHAR2(2);

Line 300: INSERT INTO GL_CONSOLIDATION_ACCOUNTS(

296: ConsolidationId NUMBER,
297: SourceRunId NUMBER,
298: TargetRunId NUMBER) IS
299: BEGIN
300: INSERT INTO GL_CONSOLIDATION_ACCOUNTS(
301: consolidation_run_id,
302: consolidation_id,
303: last_update_date,
304: last_updated_by,

Line 440: FROM gl_consolidation_accounts

436: segment29_low,
437: segment29_high,
438: segment30_low,
439: segment30_high
440: FROM gl_consolidation_accounts
441: WHERE NOT EXISTS (SELECT 1
442: FROM gl_consolidation_accounts
443: WHERE consolidation_id = ConsolidationId
444: AND consolidation_run_id = TargetRunId)

Line 442: FROM gl_consolidation_accounts

438: segment30_low,
439: segment30_high
440: FROM gl_consolidation_accounts
441: WHERE NOT EXISTS (SELECT 1
442: FROM gl_consolidation_accounts
443: WHERE consolidation_id = ConsolidationId
444: AND consolidation_run_id = TargetRunId)
445: AND consolidation_id = ConsolidationId
446: AND consolidation_run_id = SourceRunId;

Line 457: DELETE FROM GL_CONSOLIDATION_ACCOUNTS

453: StdRunId NUMBER,
454: AvgRunId NUMBER) IS
455: BEGIN
456:
457: DELETE FROM GL_CONSOLIDATION_ACCOUNTS
458: WHERE consolidation_id = ConsolidationId
459: AND (consolidation_run_id = StdRunId OR
460: consolidation_run_id = AvgRunId);
461: