PACKAGE: APPS.GL_GLXRLACH_XMLP_PKG

Source

1 PACKAGE GL_GLXRLACH_XMLP_PKG AS
2 /* $Header: GLXRLACHS.pls 120.0 2007/12/27 15:10:13 vijranga noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_LEDGER_ID	number;
5 	P_TEMPLATE_ID	number;
6 	P_ACCESS_SET_ID	number;
7 	OLD_DESC	varchar2(240);
8 	LEDGER_NAME	varchar2(30);
9 
10 	P_FLEXDATA_SUM	varchar2(1000) := '(cs1.SEGMENT1||''\n''||cs1.SEGMENT2||''\n''||cs1.SEGMENT3||''\n'' || cs1.SEGMENT4||''\n''||cs1.SEGMENT5||''\n''||cs1.SEGMENT6||''\n''
11 	|| cs1.SEGMENT7||''\n''||cs1.SEGMENT8||''\n''
12 	||cs1.SEGMENT9||''\n'' || cs1.SEGMENT10||''\n''||cs1.SEGMENT11||''\n''||cs1.SEGMENT12||''\n'' || cs1.SEGMENT13||''\n''||cs1.SEGMENT14||''\n''||cs1.SEGMENT15||''\n''
13 	|| cs1.SEGMENT16||''\n''||cs1.SEGMENT17||''\n''||cs1.SEGMENT18||''\n'' || cs1.SEGMENT19||''\n''||cs1.SEGMENT20||''\n''||cs1.SEGMENT21||''\n'' || cs1.SEGMENT22||''\n''
14 	||cs1.SEGMENT23||''\n''||cs1.SEGMENT24||''\n''
15 	|| cs1.SEGMENT25||''\n''||cs1.SEGMENT26||''\n''||cs1.SEGMENT27||''\n'' || cs1.SEGMENT28||''\n''||cs1.SEGMENT29||''\n''||cs1.SEGMENT30)' ;
16 
17 	/*P_FLEXDATA_DET	varchar2(1000) := := '(cd.SEGMENT1||'\n'||cd.SEGMENT2||'\n'||cd.SEGMENT3||'\n' || cd.SEGMENT4||'\n'||cd.SEGMENT5||'\n'||
18 	cd.SEGMENT6||'\n' || cd.SEGMENT7||'\n'||cd.SEGMENT8||'\n'||cd.SEGMENT9||'\n' || cd.SEGMENT10||'\n'||cd.SEGMENT11||'\n'||cd.SEGMENT12||'\n' ||
19 	cd.SEGMENT13||'\n'||cd.SEGMENT14||'\n'||cd.SEGMENT15||'\n' || cd.SEGMENT16||'\n'||cd.SEGMENT17||'\n'||cd.SEGMENT18||'\n' || cd.SEGMENT19||'\n'||
20 	cd.SEGMENT20||'\n'||cd.SEGMENT21||'\n' || cd.SEGMENT22||'\n'||cd.SEGMENT23||'\n'||cd.SEGMENT24||'\n' || cd.SEGMENT25||'\n'||cd.SEGMENT26||'\n'||
21 	cd.SEGMENT27||'\n' || cd.SEGMENT28||'\n'||cd.SEGMENT29||'\n'||cd.SEGMENT30)' ; */
22 	P_FLEXDATA_DET	varchar2(1000) := '(cd.SEGMENT1||''\n''||cd.SEGMENT2||''\n''||cd.SEGMENT3||''\n'' || cd.SEGMENT4||''\n''||cd.SEGMENT5||''\n''
23 	||cd.SEGMENT6||''\n'' || cd.SEGMENT7||''\n''||cd.SEGMENT8||''\n''||cd.SEGMENT9||''\n'' || cd.SEGMENT10||''\n''||cd.SEGMENT11||''\n''||
24 	cd.SEGMENT12||''\n'' || cd.SEGMENT13||''\n''||cd.SEGMENT14||''\n''||cd.SEGMENT15||''\n'' || cd.SEGMENT16||''\n''||cd.SEGMENT17||''\n''||cd.SEGMENT18||
25 	''\n'' || cd.SEGMENT19||''\n''||cd.SEGMENT20||''\n''||cd.SEGMENT21||''\n'' || cd.SEGMENT22||''\n''||cd.SEGMENT23||''\n''||cd.SEGMENT24||''\n'' ||
26 	cd.SEGMENT25||''\n''||cd.SEGMENT26||''\n''||cd.SEGMENT27||''\n'' || cd.SEGMENT28||''\n''||cd.SEGMENT29||''\n''||cd.SEGMENT30)';
27 	P_ORDER_BY_SUM	varchar2(500) := 'cs1.SEGMENT1' ;
28 	P_ORDER_BY_DET	varchar2(500) := 'cd.SEGMENT1' ;
29 	STRUCT_NUM	number;
30 	WHERE_DAS	varchar2(800);
31 	WHERE_TEMPLATE	varchar2(50);
32 	function BeforeReport return boolean  ;
33 	function AfterReport return boolean  ;
34 	function new_descformula(C_DESC_ACCT_DET in varchar2) return varchar2  ;
35 	Function OLD_DESC_p return varchar2;
36 	Function LEDGER_NAME_p return varchar2;
37 	Function P_FLEXDATA_SUM_p return varchar2;
38 	Function P_FLEXDATA_DET_p return varchar2;
39 	Function P_ORDER_BY_SUM_p return varchar2;
40 	Function P_ORDER_BY_DET_p return varchar2;
41 	Function STRUCT_NUM_p return number;
42 	Function WHERE_DAS_p return varchar2;
43 	Function WHERE_TEMPLATE_p return varchar2;
44 END GL_GLXRLACH_XMLP_PKG;
45