[Home] [Help]
PACKAGE: APPS.GL_GLXAVTRB_XMLP_PKG
Source
1 PACKAGE GL_GLXAVTRB_XMLP_PKG AS
2 /* $Header: GLXAVTRBS.pls 120.0 2007/12/27 14:44:49 vijranga noship $ */
3 P_REPORTING_DATE date;
4 P_ENTERED_CURRENCY varchar2(15);
5 P_CURRENCY_TYPE varchar2(1);
6 P_CONC_REQUEST_ID number;
7 P_MAX_FLEX varchar2(2000);
8 P_MIN_FLEX varchar2(2000);
9 P_LEDGER_CURRENCY varchar2(15);
10 P_ACCESS_SET_ID number;
11 P_LEDGER_ID number;
12 WHERE_lexical varchar2(4000) := 'cc.segment11 between ''00'' and ''11''' ;
13 CURR_TYPE varchar2(100) := 'dbs.currency_type = ''E''' ;
14 WHERE_DAS varchar2(600);
15 ACCESS_SET_NAME varchar2(30);
16 STRUCT_NUM varchar2(15);
17 RESULTING_CURRENCY varchar2(15);
18 SELECT_BAL varchar2(4000) := '(segment1||''\n''||segment2 || ''\n'' ||segment3||''\n''||
19 segment4||''\n''||segment5||''\n''||segment6||''\n''||segment7||''\n''||segment8||''\n''||segment9||
20 ''\n''||segment10||''\n''|| segment11||''\n''||segment12||''\n''||segment13||''\n''||segment14||''\n''||
21 segment15||''\n''||segment16||''\n''||segment17||''\n''||segment18||''\n''||segment19||''\n''||
22 segment20||''\n''|| segment21||''\n''||segment22||''\n''||segment23||''\n''||segment24||''\n''||
23 segment25||''\n''||segment26||''\n''||segment27||''\n''||segment28||''\n''||segment29||''\n''||segment30)' ;
24 SELECT_FLEXDATA varchar2(4000) := '(segment1||''\n''||segment2 || ''\n'' ||segment3||''\n''||
25 segment4||''\n''||segment5||''\n''||segment6||''\n''||segment7||''\n''||segment8||''\n''||segment9||
26 ''\n''||segment10||''\n''|| segment11||''\n''||segment12||''\n''||segment13||''\n''||segment14||
27 ''\n''||segment15||''\n''||segment16||''\n''||segment17||''\n''||segment18||''\n''||segment19||''\n''||
28 segment20||''\n''|| segment21||''\n''||segment22||''\n''||segment23||''\n''||segment24||''\n''||
29 segment25||''\n''||segment26||''\n''||segment27||''\n''||segment28||''\n''||segment29||''\n''||segment30)' ;
30 ORDERBY varchar2(2000) := 'cc.segment1' ;
31 PERIOD_NAME varchar2(20);
32 PERIOD_START_DATE date;
33 QUARTER_START_DATE date;
34 YEAR_START_DATE date;
35 PTD_POSITION number := 1 ;
36 QTD_POSITION number := 1 ;
37 YTD_POSITION number := 1 ;
38 MAU number;
39 PRECISION number := 1 ;
40 P_ENDING_BALANCE varchar2(2000) := 'dbs.Period_Aggregate1' ;
41 P_PATD varchar2(2000) := 'dbs.Period_Aggregate1' ;
42 P_QATD varchar2(2000) := 'Period_Aggregate1' ;
43 P_YATD varchar2(2000) := 'Period_Aggregate1' ;
44 P_PTD_AGGREGATE varchar2(2000) := 'dbs.Period_Aggregate1' ;
45 P_QTD_AGGREGATE varchar2(2000) := 'dbs.Quarter_Aggregate1' ;
46 P_YTD_AGGREGATE varchar2(2000) := 'dbs.Year_Aggregate1' ;
47 function BeforeReport return boolean ;
48 FUNCTION AfterReportTrigger return boolean ;
49 function patd(PTD_Aggregate_Total in number) return number ;
50 function qatd(QTD_Aggregate_Total in number) return number ;
51 function yatd(YTD_Aggregate_Total in number) return number ;
52 function end_bal(END_BAL_Total in number) return number ;
53 function g_headergroupfilter(BAL_SECURE in varchar2) return boolean ;
54 function g_detailgroupfilter(FLEX_SECURE in varchar2) return boolean ;
55 Function WHERE_p return varchar2;
56 Function CURR_TYPE_p return varchar2;
57 Function WHERE_DAS_p return varchar2;
58 Function ACCESS_SET_NAME_p return varchar2;
59 Function STRUCT_NUM_p return varchar2;
60 Function RESULTING_CURRENCY_p return varchar2;
61 Function SELECT_BAL_p return varchar2;
62 Function SELECT_FLEXDATA_p return varchar2;
63 Function ORDERBY_p return varchar2;
64 Function PERIOD_NAME_p return varchar2;
65 Function PERIOD_START_DATE_p return date;
66 Function QUARTER_START_DATE_p return date;
67 Function YEAR_START_DATE_p return date;
68 Function PTD_POSITION_p return number;
69 Function QTD_POSITION_p return number;
70 Function YTD_POSITION_p return number;
71 Function MAU_p return number;
72 Function PRECISION_p return number;
73 Function P_ENDING_BALANCE_p return varchar2;
74 Function P_PATD_p return varchar2;
75 Function P_QATD_p return varchar2;
76 Function P_YATD_p return varchar2;
77 Function P_PTD_AGGREGATE_p return varchar2;
78 Function P_QTD_AGGREGATE_p return varchar2;
79 Function P_YTD_AGGREGATE_p return varchar2;
80 END GL_GLXAVTRB_XMLP_PKG;
81
82