1 PACKAGE PAY_PAYUSTOT_XMLP_PKG AS
2 /* $Header: PAYUSTOTS.pls 120.0 2008/01/07 11:56:31 srikrish noship $ */
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;
20 CP_SS_EE_TAXABLE number;
21 CP_SS_EE_WITHHELD number;
22 CP_MEDICARE_EE_TAXABLE number;
23 CP_MEDICARE_EE_WITHHELD 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 varchar2(60);
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;