PACKAGE: APPS.FA_FASINSVR_XMLP_PKG

Source

1 PACKAGE FA_FASINSVR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: FASINSVRS.pls 120.1 2009/07/19 08:59:57 glchen ship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_COMPANY_FROM	varchar2(30);
5 	P_ASSET_BOOK	varchar2(40);
6 	P_LOCATION_FLEX_FROM	varchar2(240);
7 	P_COMPANY_TO	varchar2(30);
8 	P_LOCATION_FLEX_TO	varchar2(240);
9 	P_ASSET_NUMBER_FROM	varchar2(40);
10 	P_ASSET_NUMBER_TO	varchar2(40);
11 	P_CATEGORY_FLEX_FROM	varchar2(40);
12 	P_CATEGORY_FLEX_TO	varchar2(40);
13 	C_SET_OF_BOOKS_ID	number;
14 	P_INSURANCE_COMPANY_FROM	varchar2(80);
15 	P_INSURANCE_COMPANY_TO	varchar2(80);
16 	P_CAL_METHOD_FROM	varchar2(32767);
17 	P_CAL_METHOD_TO	varchar2(32767);
18 	P_YEAR	varchar2(32767);
19 	P_REPORT_TYPE	varchar2(32767);
20 	c_acct_flex_struct	number;
21 	c_acct_flex_bal_seg	varchar2(2000) := 'gcc.segment1' ;
22 	c_cat_flex_struct	number;
23 	c_where_cat_flex	varchar2(1000);
24 	c_cat_flex_seg	varchar2(100) := 'cat.segment1' ;
25 	C_SOB_NAME	varchar2(40);
26 	c_book_class	varchar2(20);
27 	c_book_type_code	varchar2(30);
28 	c_distribution_source_book	varchar2(30);
29 	C_currency_code	varchar2(32767);
30 	c_precision	number;
31 	c_locn_flex_struct	number;
32 	c_loc_flex_seg	varchar2(1000) := 'loc.segment1' ;
33 	c_where_locn_flex	varchar2(1000);
34 	c_acct_flex_bal_where	varchar2(1000);
35 	C_NO_DATA_FOUND	varchar2(2);
36 	C_TODAYS_DATE	varchar2(25);
37 	c_where_cal_method	varchar2(400):='AND 1=1';
38 	c_where_ins_company	varchar2(1000):='AND 1=1';
39 	c_where_asset_number	varchar2(400):='AND 1=1';
40 	C_WHERE_OLD_INS_DATA	varchar2(1000);
41 	C_CURRENT_FISCAL_YEAR	varchar2(32767);
42 	L_count	number;
43 	CP_insurance_from	varchar2(240);
44 	CP_insurance_to	varchar2(240);
45 	function AfterReport return boolean  ;
46 	function BeforeReport return boolean  ;
47 	function CF_NO_DATA_FOUNDFormula return Number  ;
48 	Function c_acct_flex_struct_p return number;
49 	Function c_acct_flex_bal_seg_p return varchar2;
50 	Function c_cat_flex_struct_p return number;
51 	Function c_where_cat_flex_p return varchar2;
52 	Function c_cat_flex_seg_p return varchar2;
53 	Function C_SOB_NAME_p return varchar2;
54 	Function c_book_class_p return varchar2;
55 	Function c_book_type_code_p return varchar2;
56 	Function c_distribution_source_book_p return varchar2;
57 	Function C_currency_code_p return varchar2;
58 	Function c_precision_p return number;
59 	Function c_locn_flex_struct_p return number;
60 	Function c_loc_flex_seg_p return varchar2;
61 	Function c_where_locn_flex_p return varchar2;
62 	Function c_acct_flex_bal_where_p return varchar2;
63 	Function C_NO_DATA_FOUND_p return varchar2;
64 	Function C_TODAYS_DATE_p return varchar2;
65 	Function c_where_cal_method_p return varchar2;
66 	Function c_where_ins_company_p return varchar2;
67 	Function c_where_asset_number_p return varchar2;
68 	Function C_WHERE_OLD_INS_DATA_p return varchar2;
69 	Function C_CURRENT_FISCAL_YEAR_p return varchar2;
70 	Function L_count_p return number;
71 	Function CP_insurance_from_p return varchar2;
72 	Function CP_insurance_to_p return varchar2;
73 END FA_FASINSVR_XMLP_PKG;
74