PACKAGE: APPS.PAY_PAYUSTOT_XMLP_PKG

Source

1 PACKAGE PAY_PAYUSTOT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYUSTOTS.pls 120.0.12020000.2 2012/10/25 11:24:52 rmugloo ship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	date;
5 	P_REPORT_TITLE	varchar2(60);
6 	P_CONC_REQUEST_ID	number;
7 	P_END_DATE	date;
8 	P_START_DATE	date;
9 	P_START_DATE_m	date;
10 	P_TAX_UNIT_ID	number;
11 	P_FLAG	varchar2(10);
12 	CP_FED_OTHERS	number;
13 	CP_FWT_SUPP_EARN_NWFIT	number;
14 	CP_FWT_SUPP_EARN_FIT	number;
15 	CP_PRE_TAX_DEDUCTIONS_FOR_FIT	number;
16 	CP_FIT_NON_W2_PRE_TAX_DEDNS	number;
17 	CP_FWT_REGULAR_EARNINGS	number;
18 	CP_PRE_TAX_DEDUCTIONS	number;
19 	CP_FIT_WITHHELD	number;
23 	CP_MEDICARE_EE_WITHHELD	number;
20 	CP_SS_EE_TAXABLE	number;
21 	CP_SS_EE_WITHHELD	number;
22 	CP_MEDICARE_EE_TAXABLE	number;
24 	CP_STATE_WAGES_TIPS_OTHER	number := 0.00 ;
25 	CP_SIT_EE_WITHHELD	number := 0.00 ;
26 	C_BUSINESS_GROUP_NAME	varchar2(240);
27 	C_REPORT_SUBTITLE	varchar2(60);
28 	C_TAX_UNIT_NAME	hr_organization_units.name%TYPE;
29 	CP_state_tax_unit	varchar2(20);
30 	CP_STATE_STATUS	varchar2(1);
31 	CP_FED_STATUS	varchar2(1);
32 	function BeforeReport return boolean  ;
33 	function cf_fed_gross_wagesformula(gre_id in number) return number  ;
34 	function cf_fed_wages_tips_otherformula(gre_id in number) return number  ;
35 	function cf_state_gross_wagesformula(gre_id in number, state_code in varchar2, State in varchar2) return number  ;
36 	FUNCTION GRE_TAX_BALANCE(P_BUSINESS_GROUP_ID IN NUMBER
37                         ,P_GRE_ORG_ID IN NUMBER
38                         ,P_DEF_BAL_ID IN NUMBER
39                         ,P_START_DATE IN DATE
40                         ,P_END_DATE IN DATE) RETURN NUMBER  ;
41 	function cf_1formula(gre_id in number, state in varchar2) return varchar2  ;
42 	function CP_FIT_WITHHELDFormula return Number  ;
43 	function CP_MEDICARE_EE_TAXABLEFormula return Number  ;
44 	function CP_MEDICARE_EE_WITHHELDFormula return Number  ;
45 	function CP_SS_EE_TAXABLEFormula return Number  ;
46 	function CP_SS_EE_WITHHELDFormula return Number  ;
47 	function CP_DEF_COMP_401KFormula return Number  ;
48 	function CP_REGULAR_EARNINGSFormula return Number  ;
49 	function CP_SECTION_125Formula return Number  ;
50 	function CP_FWT_SUPP_EARN_NWFITFormula return Number  ;
51 	function CP_FWT_SUPP_EARN_FITFormula return Number  ;
52 	function CP_DEF_COMP_401K_FOR_FITFormul return Number  ;
53 	function CP_STATE_WAGES_TIPS_OTHERFormu return Number  ;
54 	function CP_SIT_EE_WITHHELDFormula return Number  ;
55 	function cf_message_lineformula(CF_FED_GROSS_WAGES in number) return varchar2  ;
56 	function AfterReport return boolean  ;
57 	Function CP_FED_OTHERS_p return number;
58 	Function CP_FWT_SUPP_EARN_NWFIT_p return number;
59 	Function CP_FWT_SUPP_EARN_FIT_p return number;
60 	--Function CP_PRE_TAX_DEDUCTIONS_FOR_FIT return number;
61 	Function CP_PRE_TAX_DEDUCTIONS_FOR_p return number;
62 	Function CP_FIT_NON_W2_PRE_TAX_DEDNS_p return number;
63 	Function CP_FWT_REGULAR_EARNINGS_p return number;
64 	Function CP_PRE_TAX_DEDUCTIONS_p return number;
65 	Function CP_FIT_WITHHELD_p return number;
66 	Function CP_SS_EE_TAXABLE_p return number;
67 	Function CP_SS_EE_WITHHELD_p return number;
68 	Function CP_MEDICARE_EE_TAXABLE_p return number;
69 	Function CP_MEDICARE_EE_WITH_p return number;
70 	Function CP_STATE_WAGES_TIPS_OTHER_p return number;
71 	Function CP_SIT_EE_WITHHELD_p return number;
72 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
73 	Function C_REPORT_SUBTITLE_p return varchar2;
74 	Function C_TAX_UNIT_NAME_p return varchar2;
75 	Function CP_state_tax_unit_p return varchar2;
76 	Function CP_STATE_STATUS_p return varchar2;
77 	Function CP_FED_STATUS_p return varchar2;
78 
79 END PAY_PAYUSTOT_XMLP_PKG;