DBA Data[Home] [Help]

PACKAGE: APPS.GL_GLXUSA_XMLP_PKG

Source


1 PACKAGE GL_GLXUSA_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GLXUSAS.pls 120.0 2007/12/27 15:24:43 vijranga noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_CONSOLIDATION_ID	number;
5 	P_PERIOD_NAME	varchar2(15);
6 	P_PERIOD_TYPE	varchar2(32767);
7 	P_FLEXDATA	varchar2(1000);
8 	P_ORDERBY	varchar2(750);
9 	P_BALJOIN	varchar2(1000) := 'glb.period_net_dr = 0';
10 	P_BALJOINAB	varchar2(1000) := 'gdb.period_average_to_date_num <> 0';
11 	P_N	varchar2(1) := 'N';
12 	P_A	varchar2(1) := 'A';
13 	P_Y	varchar2(1) := 'Y';
14 	PZ	varchar2(2) := 'ZZ';
15 	P_Accounts	varchar2(25000) := '( 1 = 1 )';
16 	P_Accounts_Clause	varchar2(1) := 'N';
17 	P_Accounts_ADB	varchar2(25000) := '( 1 = 1 )';
18 	P_Accounts_Clause_ADB	varchar2(1) := 'N';
19 	STRUCT_NUM	varchar2(115);
20 	CONSOLIDATION_NAME	varchar2(33);
21 	ParentLedgerName	varchar2(30);
22 	SubsidLedgerName	varchar2(30);
23 	ConsCurrencyCode	varchar2(15);
24 	SubsidLedgerId	number;
25 	FromCurrencyCode	varchar2(15);
26 	PeriodSetName	varchar2(16);
27 	function AfterReport return boolean  ;
28 	function BeforeReport return boolean  ;
29 	procedure gl_get_consolidation_info(
30                            cons_id number, cons_name out nocopy varchar2,
31                            method out varchar2, curr_code out nocopy varchar2,
32                            from_ledid out number, to_ledid out nocopy number,
33                            description out nocopy varchar2,
34                            errbuf out nocopy varchar2)  ;
35 	procedure gl_check_cons_accounts(
36                            cons_id  number,
37                            avg_flag varchar2,
38                            actual_flag varchar2,
39                            amount_type varchar2,
40                            records_present out nocopy varchar2
41                            )  ;
42 	Function STRUCT_NUM_p return varchar2;
43 	Function CONSOLIDATION_NAME_p return varchar2;
44 	Function ParentLedgerName_p return varchar2;
45 	Function SubsidLedgerName_p return varchar2;
46 	Function ConsCurrencyCode_p return varchar2;
47 	Function SubsidLedgerId_p return number;
48 	Function FromCurrencyCode_p return varchar2;
49 	Function PeriodSetName_p return varchar2;
50 END GL_GLXUSA_XMLP_PKG;
51 
52