PACKAGE: APPS.GL_GLXAVADT_XMLP_PKG

Source

1 PACKAGE GL_GLXAVADT_XMLP_PKG AS
2 /* $Header: GLXAVADTS.pls 120.2 2008/01/07 20:08:59 vijranga noship $ */
3 	P_REPORTING_DATE	date;
4 	P_BALANCE_TYPE	varchar2(5);
5 	P_LEDGER_ID	number;
6 	P_CONC_REQUEST_ID	number;
7 	P_MIN_FLEX	varchar2(1000);
8 	P_MAX_FLEX	varchar2(1000);
9 	P_ENTERED_CURRENCY	varchar2(15);
10 	P_ACCESS_SET_ID	number;
11 	P_CURRENCY_TYPE	varchar2(1);
12 	last_eod	number;
13 	STRUCT_NUM	number;
14 	LEDGER_NAME	varchar2(30);
15 	--PERIOD_SET_NAME	varchar2(15);
16 	PERIOD_SET_NAME_1	varchar2(15);
17 	--PERIOD_YEAR	number;
18 	PERIOD_YEAR_1	number;
19 	QUARTER_NUM	number;
20 	PERIOD_NUM	number;
21 	REPORTING_CURR	varchar2(15);
22 	START_DATE	date;
23 	START_PERIOD_NAME	varchar2(15);
24 	SELECT_BAL	varchar2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3 || ''\n'' ||
25 	SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7 || ''\n'' || SEGMENT8
26 	|| ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11 || ''\n'' || SEGMENT12
27 	|| ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15 || ''\n'' || SEGMENT16
28 	|| ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19 || ''\n'' || SEGMENT20
29 	|| ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23 || ''\n'' || SEGMENT24
30 	|| ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27 || ''\n'' || SEGMENT28
31 	|| ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)' ;
32 	WHERE_FLEX_RANGE	varchar2(4000) := 'CC.SEGMENT11 BETWEEN  ''00'' and ''11''' ;
33 	SELECT_ALL	varchar2(1000) := '(CC.SEGMENT1 || ''\n'' || SEGMENT2 || ''\n'' || SEGMENT3
34 	|| ''\n'' || SEGMENT4 || ''\n'' || SEGMENT5 || ''\n'' || SEGMENT6 || ''\n'' || SEGMENT7
35 	|| ''\n'' || SEGMENT8 || ''\n'' || SEGMENT9 || ''\n'' || SEGMENT10 || ''\n'' || SEGMENT11
36 	|| ''\n'' || SEGMENT12 || ''\n'' || SEGMENT13 || ''\n'' || SEGMENT14 || ''\n'' || SEGMENT15
37 	|| ''\n'' || SEGMENT16 || ''\n'' || SEGMENT17 || ''\n'' || SEGMENT18 || ''\n'' || SEGMENT19
38 	|| ''\n'' || SEGMENT20 || ''\n'' || SEGMENT21 || ''\n'' || SEGMENT22 || ''\n'' || SEGMENT23
39 	|| ''\n'' || SEGMENT24 || ''\n'' || SEGMENT25 || ''\n'' || SEGMENT26 || ''\n'' || SEGMENT27
40 	|| ''\n'' || SEGMENT28 || ''\n'' || SEGMENT29 || ''\n'' || SEGMENT30)' ;
41 	ORDERBY_BAL	varchar2(50) := 'CC.SEGMENT10' ;
42 	ORDERBY_ALL	varchar2(800) := 'CC.SEGMENT1, CC.SEGMENT2, CC.SEGMENT3, CC.SEGMENT4, CC.SEGMENT5,
43 	CC.SEGMENT6, CC.SEGMENT7, CC.SEGMENT8, CC.SEGMENT9, CC.SEGMENT10, CC.SEGMENT11, CC.SEGMENT12,
44 	CC.SEGMENT13, CC.SEGMENT14, CC.SEGMENT15, CC.SEGMENT16, CC.SEGMENT17, CC.SEGMENT18, CC.SEGMENT19,
45 	CC.SEGMENT20, CC.SEGMENT21, CC.SEGMENT22, CC.SEGMENT23, CC.SEGMENT24, CC.SEGMENT25, CC.SEGMENT26,
46 	CC.SEGMENT27, CC.SEGMENT28, CC.SEGMENT29, CC.SEGMENT30' ;
47 	ORDERBY_ACCT	varchar2(50) := 'CC.SEGMENT10' ;
48 	--PERIOD_TYPE	varchar2(15);
49 	PERIOD_TYPE_1	varchar2(15);
50 	ACCESS_SET_NAME	varchar2(30);
51 	--WHERE_DAS	varchar2(800);
52         WHERE_DAS	varchar2(800):='';
53 	LEDGER_CURRENCY	varchar2(15);
54 	function BeforeReport return boolean  ;
55 	function opening_balformula(CCID in number) return number  ;
56 	function last_ccidformula(last_ccid in number, ccid in number, opening_bal in number) return number  ;
57 	function daily_activityformula(end_of_date_balance in number) return number  ;
58 	function AfterReport return boolean  ;
59 	procedure gl_get_period_info (ldgrid 		   in number,
60                                 reporting_date     in date,
61                                 calendar_name      in varchar2,
62                                 v_period_year      out NOCOPY number,
63                                 v_quarter_num      out NOCOPY number,
64                                 v_period_num       out NOCOPY number,
65 				errbuf	   	   out NOCOPY varchar2 )
66    ;
67 	procedure gl_get_first_date(ldgrid            in number,
68 			      balance_type     in varchar2,
69                               v_period_year    in number,
70                               v_quarter_num    in number,
71                               v_period_num     in number,
72                               v_period_name    out NOCOPY varchar2,
73                               v_start_date     out NOCOPY date,
74 			      errbuf           out NOCOPY varchar2)
75    ;
76 	function g_balancing_seggroupfilter(BAL_SECURE in varchar2) return boolean  ;
77 	function g_opening_balgroupfilter(ACCT_SECURE in varchar2) return boolean  ;
78 	Function last_eod_p return number;
79 	Function STRUCT_NUM_p return number;
80 	Function LEDGER_NAME_p return varchar2;
81 	Function PERIOD_SET_NAME_p return varchar2;
82 	Function PERIOD_YEAR_p return number;
83 	Function QUARTER_NUM_p return number;
84 	Function PERIOD_NUM_p return number;
85 	Function REPORTING_CURR_p return varchar2;
86 	Function START_DATE_p return date;
87 	Function START_PERIOD_NAME_p return varchar2;
88 	Function SELECT_BAL_p return varchar2;
89 	Function WHERE_FLEX_RANGE_p return varchar2;
90 	Function SELECT_ALL_p return varchar2;
91 	Function ORDERBY_BAL_p return varchar2;
92 	Function ORDERBY_ALL_p return varchar2;
93 	Function ORDERBY_ACCT_p return varchar2;
94 	Function PERIOD_TYPE_p return varchar2;
95 	Function ACCESS_SET_NAME_p return varchar2;
96 	Function WHERE_DAS_p return varchar2;
97 	Function LEDGER_CURRENCY_p return varchar2;
98 END GL_GLXAVADT_XMLP_PKG;