[Home] [Help]
PACKAGE: APPS.GL_GLXRLVAT_XMLP_PKG
Source
1 PACKAGE GL_GLXRLVAT_XMLP_PKG AS
2 /* $Header: GLXRLVATS.pls 120.0 2007/12/27 15:23:35 vijranga noship $ */
3 P_CONC_REQUEST_ID number;
4 P_LEDGER_ID number;
5 P_PERIOD_NAME varchar2(15);
6 P_CURRENCY_CODE varchar2(15);
7 P_TAX_CODE varchar2(15);
8 P_ACCESS_SET_ID number;
9 STRUCT_NUM varchar2(15);
10 LEDGER_NAME varchar2(30);
11 /*FLEX_SELECT_ALL varchar2(1000) := '(gcc.SEGMENT1 || '\n' || gcc.SEGMENT2 || '\n' || gcc.SEGMENT3 || '\n' || gcc.SEGMENT4 || '\n' ||
12 gcc.SEGMENT5 || '\n' || gcc.SEGMENT6 || '\n' || gcc.SEGMENT7 || '\n' || gcc.SEGMENT8 || '\n' || gcc.SEGMENT9 || '\n' || gcc.SEGMENT10 || '\n'
13 || gcc.SEGMENT11 || '\n' || gcc.SEGMENT12 || '\n' || gcc.SEGMENT13 || '\n' || gcc.SEGMENT14 || '\n' || gcc.SEGMENT15 || '\n' || gcc.SEGMENT16
14 || '\n' || gcc.SEGMENT17 || '\n' || gcc.SEGMENT18 || '\n' || gcc.SEGMENT19 || '\n' || gcc.SEGMENT20 || '\n' || gcc.SEGMENT21 || '\n'
15 || gcc.SEGMENT22 || '\n' || gcc.SEGMENT23 || '\n' || gcc.SEGMENT24 || '\n' || gcc.SEGMENT25 || '\n' || gcc.SEGMENT26 || '\n' || gcc.SEGMENT27
16 || '\n' || gcc.SEGMENT28 || '\n' || gcc.SEGMENT29 || '\n' || gcc.SEGMENT30)' ;
17 FLEX_ORDERBY_ALL varchar2(1000) := '(gcc.SEGMENT1 || '\n' || gcc.SEGMENT2 || '\n' || gcc.SEGMENT3 || '\n' || gcc.SEGMENT4 || '\n'
18 || gcc.SEGMENT5 || '\n' || gcc.SEGMENT6 || '\n' || gcc.SEGMENT7 || '\n' || gcc.SEGMENT8 || '\n' || gcc.SEGMENT9 || '\n' || gcc.SEGMENT10
19 || '\n' || gcc.SEGMENT11 || '\n' || gcc.SEGMENT12 || '\n' || gcc.SEGMENT13 || '\n' || gcc.SEGMENT14 || '\n' || gcc.SEGMENT15 || '\n' ||
20 gcc.SEGMENT16 || '\n' || gcc.SEGMENT17 || '\n' || gcc.SEGMENT18 || '\n' || gcc.SEGMENT19 || '\n' || gcc.SEGMENT20 || '\n' || gcc.SEGMENT21
21 || '\n' || gcc.SEGMENT22 || '\n' || gcc.SEGMENT23 || '\n' || gcc.SEGMENT24 || '\n' || gcc.SEGMENT25 || '\n' || gcc.SEGMENT26 || '\n' ||
22 gcc.SEGMENT27 || '\n' || gcc.SEGMENT28 || '\n' || gcc.SEGMENT29 || '\n' || gcc.SEGMENT30)' ;
23 */
24 FLEX_SELECT_ALL varchar2(1000) := '(gcc.SEGMENT1 || ''\n'' || gcc.SEGMENT2 || ''\n'' || gcc.SEGMENT3 || ''\n'' || gcc.SEGMENT4 || ''\n''
25 || gcc.SEGMENT5 || ''\n'' || gcc.SEGMENT6 || ''\n'' || gcc.SEGMENT7 || ''\n'' || gcc.SEGMENT8 || ''\n'' || gcc.SEGMENT9 || ''\n'' ||
26 gcc.SEGMENT10 || ''\n'' || gcc.SEGMENT11 || ''\n'' || gcc.SEGMENT12 || ''\n'' || gcc.SEGMENT13 || ''\n'' || gcc.SEGMENT14 || ''\n'' ||
27 gcc.SEGMENT15 || ''\n'' || gcc.SEGMENT16 || ''\n'' || gcc.SEGMENT17 || ''\n'' || gcc.SEGMENT18 || ''\n'' || gcc.SEGMENT19 || ''\n'' ||
28 gcc.SEGMENT20 || ''\n'' || gcc.SEGMENT21 || ''\n'' || gcc.SEGMENT22 || ''\n'' || gcc.SEGMENT23 || ''\n'' || gcc.SEGMENT24 || ''\n'' ||
29 gcc.SEGMENT25 || ''\n'' || gcc.SEGMENT26 || ''\n'' || gcc.SEGMENT27 || ''\n'' || gcc.SEGMENT28 || ''\n'' || gcc.SEGMENT29 || ''\n'' ||
30 gcc.SEGMENT30)' ;
31 FLEX_ORDERBY_ALL varchar2(1000) := '(gcc.SEGMENT1 || ''\n'' || gcc.SEGMENT2 || ''\n'' || gcc.SEGMENT3 || ''\n'' || gcc.SEGMENT4 ||
32 ''\n'' || gcc.SEGMENT5 || ''\n'' || gcc.SEGMENT6 || ''\n'' || gcc.SEGMENT7 || ''\n'' || gcc.SEGMENT8 || ''\n'' || gcc.SEGMENT9 || ''\n'' ||
33 gcc.SEGMENT10 || ''\n'' || gcc.SEGMENT11 || ''\n'' || gcc.SEGMENT12 || ''\n'' || gcc.SEGMENT13 || ''\n'' || gcc.SEGMENT14 || ''\n'' ||
34 gcc.SEGMENT15 || ''\n'' || gcc.SEGMENT16 || ''\n'' || gcc.SEGMENT17 || ''\n'' || gcc.SEGMENT18 || ''\n'' || gcc.SEGMENT19 || ''\n'' ||
35 gcc.SEGMENT20 || ''\n'' || gcc.SEGMENT21 || ''\n'' || gcc.SEGMENT22 || ''\n'' || gcc.SEGMENT23 || ''\n'' || gcc.SEGMENT24 || ''\n'' ||
36 gcc.SEGMENT25 || ''\n'' || gcc.SEGMENT26 || ''\n'' || gcc.SEGMENT27 || ''\n'' || gcc.SEGMENT28 || ''\n'' || gcc.SEGMENT29 || ''\n'' ||
37 gcc.SEGMENT30)' ;
38 ACCESS_SET_NAME varchar2(30);
39 WHERE_DAS varchar2(800);
40 function BeforeReport return boolean ;
41 function AfterReport return boolean ;
42 Function STRUCT_NUM_p return varchar2;
43 Function LEDGER_NAME_p return varchar2;
44 Function FLEX_SELECT_ALL_p return varchar2;
45 Function FLEX_ORDERBY_ALL_p return varchar2;
46 Function ACCESS_SET_NAME_p return varchar2;
47 Function WHERE_DAS_p return varchar2;
48 END GL_GLXRLVAT_XMLP_PKG;
49
50