PACKAGE: APPS.PAY_PYNZSOE_XMLP_PKG

Source

1 PACKAGE PAY_PYNZSOE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PYNZSOES.pls 120.0 2007/12/13 12:12:54 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_CONC_REQUEST_ID	number;
5 	P_Payroll_Id	number;
6 	P_Payroll_Action_Id	number;
7 	P_SORT_ORDER_1	varchar2(60);
8 	P_SORT_ORDER_2	varchar2(60);
9 	P_SORT_ORDER_3	varchar2(60);
10 	P_SORT_ORDER_4	varchar2(60);
11 	P_Location_Id	number;
12 	P_ORGANISATION_NAME	varchar2(60);
13 	P_Assignment_id	number;
14 	P_Address_Line_1	varchar2(28);
15 	P_Address_Line_2	varchar2(28);
16 	P_Address_Line_3	varchar2(28);
17 	P_Town_City	varchar2(28);
18 	P_PostCode	varchar2(28);
19 	P_Country	varchar2(28);
20 	P_Position_Name	varchar2(30);
21 	CP_non_tax_allow_this_pay	number;
22 	CP_non_tax_allow_ytd	number;
23 	CP_gross_ytd	number;
24 	CP_gross_this_pay	number;
25 	CP_other_deductions_ytd	number;
26 	CP_other_deductions_this_pay	number;
27 	CP_tax_deductions_ytd	number;
28 	CP_pre_tax_deductions_this_pay	number;
29 	CP_pre_tax_deductions_ytd	number;
30 	CP_tax_deductions_this_pay	number;
31 	P_Cumulative_Leave_Bal	number := 0 ;
32 	CP_Where_Clause	varchar2(2000);
33 	CP_Payroll_Name	varchar2(80);
34 	CP_Payment_Run	varchar2(80);
35 	CP_ORDER_BY	varchar2(2000);
36 	function BeforeReport return boolean  ;
37 	function AfterReport return boolean  ;
38 	--function f_get_detailsformula(ass_number in varchar2, assignment_id in number, date_earned in date, home_office_ind in varchar2, person_id1 in number, location_id1 in number) return number  ;
39 	function f_get_detailsformula(ass_number in varchar2, v_assignment_id in number, date_earned in date, home_office_ind in varchar2, person_id1 in number, location_id1 in number) return number  ;
40 	function f_get_cumulative_leave_balform(leave_balance_absence_type in varchar2, leave_balance_assignment_id in number, leave_balance_payroll_id in number, leave_balance_bus_grp_id in number, leave_balance_accrual_plan_id in number,
41 	period_end_date in date) return number  ;
42 	function cf_amount_paidformula(classification_name in varchar2, earnings_element_value in number) return number  ;
43 	function cf_get_miscellaneous_valuesfor(assignment_id in number, run_ass_action_id_link_from_q1 in number, date_earned in date) return number  ;
44 	function CF_net_this_payFormula return Number  ;
45 	function CF_net_ytdFormula return Number  ;
46 	function CF_CURRENCY_FORMAT_MASKFormula return VARCHAR2  ;
47 	function G_Asg_Payments_Break_GGroupFil return boolean  ;
48 	Function P_Address_Line_1_p return varchar2;
49 	Function P_Address_Line_2_p return varchar2;
50 	Function P_Address_Line_3_p return varchar2;
51 	Function P_Town_City_p return varchar2;
52 	Function P_PostCode_p return varchar2;
53 	Function P_Country_p return varchar2;
54 	Function P_Position_Name_p return varchar2;
55 	Function CP_non_tax_allow_this_pay_p return number;
56 	Function CP_non_tax_allow_ytd_p return number;
57 	Function CP_gross_ytd_p return number;
58 	Function CP_gross_this_pay_p return number;
59 	Function CP_other_deductions_ytd_p return number;
60 	Function CP_other_deductions_this_pay_p return number;
61 	Function CP_tax_deductions_ytd_p return number;
62 	Function CP_pre_tax_deductions_this_pa return number;
63 	Function CP_pre_tax_deductions_ytd_p return number;
64 	Function CP_tax_deductions_this_pay_p return number;
65 	Function P_Cumulative_Leave_Bal_p return number;
66 	Function CP_Where_Clause_p return varchar2;
67 	Function CP_Payroll_Name_p return varchar2;
68 	Function CP_Payment_Run_p return varchar2;
69 	Function CP_ORDER_BY_p return varchar2;
70 END PAY_PYNZSOE_XMLP_PKG;