DBA Data[Home] [Help]

APPS.GL_GLCRDR_XMLP_PKG dependencies on GL_CONSOLIDATION

Line 4: procedure gl_consolidation_name(cons_id number, cons_name out NOCOPY varchar2,

1: PACKAGE BODY GL_GLCRDR_XMLP_PKG AS
2: /* $Header: GLCRDRB.pls 120.0 2007/12/27 14:21:57 vijranga noship $ */
3:
4: procedure gl_consolidation_name(cons_id number, cons_name out NOCOPY varchar2,
5: curr_code out NOCOPY varchar2,
6: errbuf out NOCOPY varchar2) is
7: begin
8: select name, from_currency_code

Line 10: from gl_consolidation

6: errbuf out NOCOPY varchar2) is
7: begin
8: select name, from_currency_code
9: into cons_name, curr_code
10: from gl_consolidation
11: where consolidation_id = cons_id;
12:
13: EXCEPTION
14: when NO_DATA_FOUND then

Line 95: from gl_consolidation gca

91:
92: begin
93: select gca.to_ledger_id
94: into to_ledid
95: from gl_consolidation gca
96: where gca.consolidation_id = cons_id ;
97:
98: EXCEPTION
99: when NO_DATA_FOUND OR INVALID_NUMBER OR VALUE_ERROR then

Line 244: FROM gl_ledger_relationships glr, gl_consolidation gcs

240:
241: begin
242: SELECT glr.target_ledger_name
243: INTO FROM_LEDGER_NAME
244: FROM gl_ledger_relationships glr, gl_consolidation gcs
245: WHERE glr.target_currency_code = gcs.from_currency_code
246: AND glr.source_ledger_id = gcs.from_ledger_id
247: AND glr.target_ledger_id = gcs.from_ledger_id
248: AND gcs.consolidation_id = cons_id;

Line 284: gl_consolidation_name(cons_id, tmpname, functcurr, errbuf);

280:
281: FROM_CHART_OF_ACCOUNTS_ID := coaid;
282:
283:
284: gl_consolidation_name(cons_id, tmpname, functcurr, errbuf);
285:
286: if (errbuf is not null) then
287:
288:

Line 291: 'ROUTINE', 'gl_consolidation_name');

287:
288:
289: errbuf2 := gl_message.get_message(
290: 'GL_PLL_ROUTINE_ERROR', 'N',
291: 'ROUTINE', 'gl_consolidation_name');
292: /*srw.message('00', errbuf2);*/null;
293:
294: /*srw.message('00', errbuf);*/null;
295: