PACKAGE: APPS.PAY_PAYHKMPF_XMLP_PKG

Source

1 PACKAGE PAY_PAYHKMPF_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYHKMPFS.pls 120.0 2007/12/13 11:59:01 amakrish noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_LEGAL_EMPLOYER_ID	number;
5 	P_SCHEME_ID	number;
6 	P_CONTRIBUTIONS_START_DATE	date;
7 	P_CONTRIBUTIONS_END_DATE	date;
8 	P_SURCHARGE_PARTI_MAND	number;
9 	P_SURCHARGE_PARTI_VOL	number;
10 	P_SURCHARGE_PARTII_MAND	number;
11 	P_SURCHARGE_PARTII_VOL	number;
12 	--P_GLOBAL_SEQUENCE_NO	number;
13 	P_GLOBAL_SEQUENCE_NO	number:= 0;
14 	P_BUSINESS_GROUP_ID	number;
15 	CP_display_sequence_1	number;
16 	CP_display_sequence_2	number;
17 	CP_where_current	varchar2(2000);
18 	CP_scheme_name	varchar2(156);
19 	CP_scheme_reg_number	varchar2(51);
20 	CP_employer_name	varchar2(96);
21 	CP_contact	varchar2(96);
22 	CP_address	varchar2(1500);
23 	CP_telephone_no	varchar2(96);
24 	CP_participation_no	varchar2(51);
25 	CP_CURRENCY_FORMAT_MASK_12	varchar2(100);
26 	CP_CURRENCY_FORMAT_MASK_14	varchar2(100);
27 	/*added as fix:*/
28 	P_SURCHARGE_PARTI_MAND_t number;
29 	P_SURCHARGE_PARTI_VOL_t number;
30 	P_SURCHARGE_PARTII_MAND_t number;
31 	P_SURCHARGE_PARTII_VOL_t number;
32 	   P_CONTRIBUTIONS_START_DATE_T varchar(25);
33 	   P_CONTRIBUTIONS_END_DATE_T varchar(25);
34 	   EFFECTIVE_DATE VARCHAR(25);
35 	/* fix ends */
36 	function AfterReport return boolean  ;
37 	function BeforeReport return boolean  ;
38 	PROCEDURE construct_where_clause  ;
39 	PROCEDURE construct_scheme_employer  ;
40 	function cf_total_mandatoryformula(er_mandatory in number, ee_mandatory in number) return number  ;
41 	function cf_total_voluntaryformula(er_voluntary in number, ee_voluntary in number) return number  ;
42 	function cf_part1_mandatoryformula(CS_er_mandatory in number, CS_ee_mandatory in number) return number  ;
43 	function cf_part1_voluntaryformula(CS_er_voluntary in number, CS_ee_voluntary in number) return number  ;
44 	function CF_sequence_noFormula return Number  ;
45 	function CF_CURRENCY_FORMAT_MASKFormula return Number  ;
46 	function cf_total_mandatory1formula(er_mandatory1 in number, ee_mandatory1 in number) return number  ;
47 	function cf_total_voluntary1formula(er_voluntary1 in number, ee_voluntary1 in number) return number  ;
48 	function cf_partii_mandatoryformula(CS_er_mandatory1 in number, CS_ee_mandatory1 in number) return number  ;
49 	function cf_partii_voluntaryformula(CS_er_voluntary1 in number, CS_ee_voluntary1 in number) return number  ;
50 	function cf_overall_mandatoryformula(CF_parti_mandatory in number, CF_partii_mandatory in number) return number  ;
51 	function cf_overall_voluntaryformula(CF_parti_voluntary in number, CF_partii_voluntary in number) return number  ;
52 	function CF_sequence_no1Formula return Number  ;
53 	Function CP_display_sequence_1_p return number;
54 	Function CP_display_sequence_2_p return number;
55 	Function CP_where_current_p return varchar2;
56 	Function CP_scheme_name_p return varchar2;
57 	Function CP_scheme_reg_number_p return varchar2;
58 	Function CP_employer_name_p return varchar2;
59 	Function CP_contact_p return varchar2;
60 	Function CP_address_p return varchar2;
61 	Function CP_telephone_no_p return varchar2;
62 	Function CP_participation_no_p return varchar2;
63 	Function CP_CURRENCY_FORMAT_MASK_12_p return varchar2;
64 	Function CP_CURRENCY_FORMAT_MASK_14_p return varchar2;
65 END PAY_PAYHKMPF_XMLP_PKG;