[Home] [Help]
PACKAGE: APPS.GL_GLXRLHST_XMLP_PKG
Source
1 PACKAGE GL_GLXRLHST_XMLP_PKG AS
2 /* $Header: GLXRLHSTS.pls 120.0 2007/12/27 15:14:35 vijranga noship $ */
3 P_CONC_REQUEST_ID number;
4 P_LEDGER_ID number;
5 P_MIN_PRECISION number;
6 P_FROM_PERIOD varchar2(15);
7 P_TO_PERIOD varchar2(15);
8 P_ACCESS_SET_ID number;
9 STRUCT_NUM varchar2(15);
10 LEDGER_NAME varchar2(30);
11
12 FLEX_SELECT_ALL varchar2(1000) := '(gcc.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10
13 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20 || ''\n'' ||
14 SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
15
16 FLEX_ORDERBY_ALL varchar2(1000) := '(gcc.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n''
17 || SEGMENT10 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20
18 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)';
19
20 --FLEX_SELECT_BAL varchar2(600) := := '(gcc.SEGMENT11 ||'\n' || SEGMENT12)' ;
21 FLEX_SELECT_BAL varchar2(600) := '(gcc.SEGMENT11 ||''\n'' || SEGMENT12)' ;
22 FLEX_ORDERBY_BAL_D varchar2(600) := 'gcc.SEGMENT10' ;
23 --FLEX_SELECT_ACCT varchar2(600) := := '(gcc.SEGMENT11 ||'\n' || SEGMENT12)' ;
24 FLEX_SELECT_ACCT varchar2(600) := '(gcc.SEGMENT11 ||''\n'' || SEGMENT12)' ;
25 FLEX_ORDERBY_ACCT_D varchar2(600) := 'gcc.SEGMENT10' ;
26 FLEX_ORDERBY_BAL_I varchar2(600) := 'gcc.SEGMENT10' ;
27 FLEX_ORDERBY_ACCT_I varchar2(600) := 'gcc.SEGMENT10' ;
28 AVERAGE_BALANCES_FLAG varchar2(30);
29 WHERE_DAS varchar2(800);
30 FROM_EFF_PERIOD_NUM number;
31 TO_EFF_PERIOD_NUM number;
32 FUNCTIONAL_CURRENCY varchar2(15);
33 function BeforeReport return boolean ;
34 function AfterReport return boolean ;
35 Function STRUCT_NUM_p return varchar2;
36 Function LEDGER_NAME_p return varchar2;
37 Function FLEX_SELECT_ALL_p return varchar2;
38 Function FLEX_ORDERBY_ALL_p return varchar2;
39 Function FLEX_SELECT_BAL_p return varchar2;
40 Function FLEX_ORDERBY_BAL_D_p return varchar2;
41 Function FLEX_SELECT_ACCT_p return varchar2;
42 Function FLEX_ORDERBY_ACCT_D_p return varchar2;
43 Function FLEX_ORDERBY_BAL_I_p return varchar2;
44 Function FLEX_ORDERBY_ACCT_I_p return varchar2;
45 Function AVERAGE_BALANCES_FLAG_p return varchar2;
46 Function WHERE_DAS_p return varchar2;
47 Function FROM_EFF_PERIOD_NUM_p return number;
48 Function TO_EFF_PERIOD_NUM_p return number;
49 Function FUNCTIONAL_CURRENCY_p return varchar2;
50 END GL_GLXRLHST_XMLP_PKG;
51
52