PACKAGE: APPS.PAY_PAYHKSOE_XMLP_PKG

Source

1 PACKAGE PAY_PAYHKSOE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYHKSOES.pls 120.0 2007/12/13 11:59:14 amakrish noship $ */
3 	P_SORT_ORDER_1	varchar2(60);
4 	P_SORT_ORDER_4	varchar2(60);
5 	P_SORT_ORDER_3	varchar2(60);
6 	P_SORT_ORDER_2	varchar2(60);
7 	P_Consolidation_Set	varchar2(32767);
8 	P_Payroll	varchar2(32767);
9 	P_Payments_From_Date	date;
10 	P_Payments_To_Date	date;
11 	P_Date_MPF_Paid_to_Trustee	date;
12 	P_CONC_REQUEST_ID	number;
13 	P_BUSINESS_GROUP_ID	number;
14 	Print_MPF_Flag	number;
15 	CP_Total_Earnings_This_Pay	number;
16 	CP_Total_Deductions_This_Pay	number;
17 	CP_Net_Pay_This_Pay	number;
18 	CP_Direct_Payments_This_Pay	number;
19 	CP_Total_Payment_This_Pay	number;
20 	CP_Total_Earnings_YTD	number;
21 	CP_Total_Deductions_YTD	number;
22 	CP_Net_Pay_YTD	number;
23 	CP_Direct_Payments_YTD	number;
24 	CP_Total_Payment_YTD	number;
25 	CP_Count	number;
26 	CP_start_date	date;
27 	CP_End_Date	date;
28 	CP_accrual_end_date	date;
29 	CP_accrual	number;
30 	CP_net_entitlement	number;
31 	cp_order_by	varchar2(240);
32 	CP_sort_by	varchar2(4);
33 	CP_where_clause	varchar2(240);
34 	/*ADDED AS FIX*/
35 	      P_PAYMENTS_FROM_DATE_DISP   VARCHAR2(40);
36 	      P_PAYMENTS_TO_DATE_DISP VARCHAR2(40);
37 	function BeforeReport return boolean  ;
38 	PROCEDURE construct_order_by  ;
39 	PROCEDURE construct_where_clause  ;
40 	function cf_get_balances_totalsformula(assignment_action_id4 in number, tax_unit_id1 in number) return number  ;
41 	function AfterReport return boolean  ;
42 	function CF_currency_format_maskFormula return VARCHAR2  ;
43 	function CF_MPF_Flag1Formula return Number  ;
44 	function cf_mpf_flag2formula(CS_Count in number, element_name_sort1 in number) return number  ;
45 	function cf_net_accrualformula(assignment_id3 in number, accrual_plan_id1 in number, payroll_id in number, business_group_id in number, end_date1 in date) return number  ;
46 	Function CP_Total_Earnings_This_Pay_p return number;
47 	Function CP_Total_Deductions_This_Pay_p return number;
48 	Function CP_Net_Pay_This_Pay_p return number;
49 	Function CP_Direct_Payments_This_Pay_p return number;
50 	Function CP_Total_Payment_This_Pay_p return number;
51 	Function CP_Total_Earnings_YTD_p return number;
52 	Function CP_Total_Deductions_YTD_p return number;
53 	Function CP_Net_Pay_YTD_p return number;
54 	Function CP_Direct_Payments_YTD_p return number;
55 	Function CP_Total_Payment_YTD_p return number;
56 	Function CP_Count_p return number;
57 	Function CP_start_date_p return date;
58 	Function CP_End_Date_p return date;
59 	Function CP_accrual_end_date_p return date;
60 	Function CP_accrual_p return number;
61 	Function CP_net_entitlement_p return number;
62 	Function cp_order_by_p return varchar2;
63 	Function CP_sort_by_p return varchar2;
64 	Function CP_where_clause_p return varchar2;
65 	Function PRINT_MPF_FLAG_p return number;
66 END PAY_PAYHKSOE_XMLP_PKG;