[Home] [Help]
PACKAGE: APPS.GL_GLXBTB_XMLP_PKG
Source
1 PACKAGE GL_GLXBTB_XMLP_PKG AS
2 /* $Header: GLXBTBS.pls 120.0 2007/12/27 14:48:21 vijranga noship $ */
3 P_CONC_REQUEST_ID number;
4 P_BUDGET_VERSION_ID number;
5 P_FROM_PERIOD_NAME varchar2(15);
6 P_TO_PERIOD_NAME varchar2(15);
7 P_CURRENCY_TYPE varchar2(1);
8 P_LEDGER_ID number;
9 P_ACCESS_SET_ID number;
10 P_LEDGER_CURRENCY varchar2(32767);
11 P_ENTERED_CURRENCY varchar2(32767);
12 STRUCT_NUM varchar2(15) := '50105' ;
13 ACCESS_SET_NAME varchar2(30);
14 SELECT_BAL varchar2(600) := '(cc.segment11 || ''\n'' || cc.segment12)' ;
15 SELECT_ALL varchar2(600) := '(cc.segment1||''\n''||cc.segment2||''\n''||cc.segment3||''\n''||cc.segment4||''\n''||cc.segment5||''\n''||cc.segment6||''\n''||cc.segment7||''\n''||cc.segment8||''\n''||cc.segment9||''\n''||cc.segment10||
16 ''\n''||cc.segment11||''\n''||cc.segment12||''\n''||cc.segment13||''\n''||cc.segment14||''\n''||cc.segment15||''\n''||cc.segment16||''\n''||cc.segment17||''\n''||cc.segment18||''\n''||cc.segment19||''\n''||cc.segment20||''\n''||
17 cc.segment21||''\n''||cc.segment22||''\n''||cc.segment23||''\n''||cc.segment24||''\n''||cc.segment25||''\n''||cc.segment26||''\n''||cc.segment27||''\n''||cc.segment28||''\n''||cc.segment29||''\n''||cc.segment30)' ;
18 ORDERBY_BAL varchar2(50) := 'cc.segment11' ;
19 ORDERBY_ACCT varchar2(50) := 'cc.segment11' ;
20 ORDERBY_ALL varchar2(600) := 'segment1, segment2, segment3, segment4, segment5, segment6, segment7, segment8, segment9, segment10, segment11, segment12, segment13, segment14, segment15, segment16, segment17, segment18, segment19, segment20,
21 segment21, segment22, segment23, segment24, segment25, segment26, segment27, segment28, segment29, segment30' ;
22 SELECT_ACCT varchar2(600) := '(cc.segment11 || ''\n'' || cc.segment12)' ;
23 TRANS_CHECK_BB varchar2(300) := '(nvl(bb.translated_flag(+),''R'') = ''R'')' ;
24 TRANS_CHECK_BE varchar2(300) := '(be.translated_flag is null OR be.translated_flag <> ''R'')' ;
25 WHERE_DAS varchar2(600);
26 RESULTING_CURRENCY varchar2(20);
27 function period_act_balformula(END_BAL in number, BEGIN_BAL in number) return number ;
28 function BUDGET_NAMEFormula return VARCHAR2 ;
29 function disp_bal_lprompt_w_colonformul(DISP_BAL_LPROMPT in varchar2) return varchar2 ;
30 function AfterReport return boolean ;
31 function BeforeReport return boolean ;
32 function g_balancesgroupfilter(FLEX_SECURE in varchar2, BEGIN_BAL in number, END_BAL in number) return boolean ;
33 function g_page_breakgroupfilter(BAL_SECURE in varchar2) return boolean ;
34 function g_acct_datagroupfilter(ACCT_SECURE in varchar2) return boolean ;
35 function LEDGER_NAMEFormula return VARCHAR2 ;
36 Function STRUCT_NUM_p return varchar2;
37 Function ACCESS_SET_NAME_p return varchar2;
38 Function SELECT_BAL_p return varchar2;
39 Function SELECT_ALL_p return varchar2;
40 Function ORDERBY_BAL_p return varchar2;
41 Function ORDERBY_ACCT_p return varchar2;
42 Function ORDERBY_ALL_p return varchar2;
43 Function SELECT_ACCT_p return varchar2;
44 Function TRANS_CHECK_BB_p return varchar2;
45 Function TRANS_CHECK_BE_p return varchar2;
46 Function WHERE_DAS_p return varchar2;
47 Function RESULTING_CURRENCY_p return varchar2;
48 END GL_GLXBTB_XMLP_PKG;
49
50