DBA Data[Home] [Help]

PACKAGE: APPS.PA_PAXAUVIT_XMLP_PKG

Source


1 PACKAGE PA_PAXAUVIT_XMLP_PKG AS
2 /* $Header: PAXAUVITS.pls 120.0 2008/01/02 11:19:41 krreddy noship $ */
3 	P_rule_optimizer	varchar2(3);
4 	P_debug_mode	varchar2(3);
5 	P_CONC_REQUEST_ID	number;
6 	P_Report_Type	varchar2(3);
7 	P_FROM_TRANSFER_DATE	date;
8 	P_TO_TRANSFER_DATE	date;
9 	P_FROM_GL_DATE	date;
10 	P_TO_GL_DATE	date;
11 	P_FROM_TRANSFER_DATE1	varchar2(15);
12 	P_TO_TRANSFER_DATE1	varchar2(15);
13 	P_FROM_GL_DATE1	varchar2(15);
14 	P_TO_GL_DATE1	varchar2(15);
15 	P_sob_id	number;
16 	P_coa_id	number;
17 	P_from_account	varchar2(240);
18 	P_TO_ACCOUNT	varchar2(240);
19 	C_select_clause	varchar2(2000);
20 	C_from_clause	varchar2(2000);
21 	C_where_clause	varchar2(2000);
22 	C_where	varchar2(2000);
23 	C_COMPANY_NAME_HEADER	varchar2(50);
24 	C_no_data_found	varchar2(80);
25 	C_dummy_data	number;
26 	C_WHERE_CC	varchar2(4000) := '1=1' ;
27 	QTY_PRECISION varchar2(100);
28 	function get_precision(qty_precision number)return varchar2 ;
29 	FUNCTION  get_cover_page_values   RETURN BOOLEAN  ;
30 	FUNCTION  get_company_name    RETURN BOOLEAN  ;
31 	function BeforeReport return boolean  ;
32 	function account_idformula(dr_code_combination_id in number) return char  ;
33 	function account_flex_idformula(dr_code_combination_id1 in number) return char  ;
34 	procedure get_precision (id IN NUMBER)  ;
35 	function AfterReport return boolean  ;
36 	Function C_COMPANY_NAME_HEADER_p return varchar2;
37 	Function C_no_data_found_p return varchar2;
38 	Function C_dummy_data_p return number;
39 	Function C_WHERE_CC_p return varchar2;
40 END PA_PAXAUVIT_XMLP_PKG;