1 package pay_nz_soe_pkg AUTHID CURRENT_USER as
2 /* $Header: pynzsoe.pkh 120.0.12000000.1 2007/01/17 23:22:14 appldev noship $ */
3
4 /*
5 **
6 ** Copyright (C) 1999 Oracle Corporation
7 ** All Rights Reserved
8 **
9 ** NZ HRMS statement of earnings package
10 **
11 ** Change List
12 ** ===========
13 **
14 ** Date Author Reference Description
15 ** -----------+--------+---------+-------------
16 ** 10 MAY 2000 JMHATRE N/A Created
17 ** 04 AUG 2000 NDOMA N/A Added two procedures which is required
18 ** for NZ SOE window(get_details and
19 ** get_asg_latest_pay).
20 ** 21 AUG 2000 NDOMA N/A Added new procedure(final_balance_totals)
21 ** Which is used to get the cumulative run
22 ** balances if the prepayments is run for
23 ** selected run or prepayments.
24 ** 03 DEC 2002 SRRAJAGO 2689221 Included 'nocopy' options for the 'out' and 'in out'
25 ** parameters of all the procedures.
26 */
27
28 -------------------------------------------------------------------------------
29 procedure get_home_address(p_person_id IN NUMBER,
30 p_addr_line1 OUT NOCOPY VARCHAR2,
31 p_addr_line2 OUT NOCOPY VARCHAR2,
32 p_addr_line3 OUT NOCOPY VARCHAR2,
33 p_town_city OUT NOCOPY VARCHAR2,
34 p_postal_code OUT NOCOPY VARCHAR2,
35 p_country_name OUT NOCOPY VARCHAR2);
36
37 -------------------------------------------------------------------------------
38
39 procedure get_work_address(p_location_id IN NUMBER,
40 p_addr_line1 OUT NOCOPY VARCHAR2,
41 p_addr_line2 OUT NOCOPY VARCHAR2,
42 p_addr_line3 OUT NOCOPY VARCHAR2,
43 p_town_city OUT NOCOPY VARCHAR2,
44 p_postal_code OUT NOCOPY VARCHAR2,
45 p_country_name OUT NOCOPY VARCHAR2);
46
47 -------------------------------------------------------------------------------
48
49 FUNCTION get_tax_code(p_run_assignment_action_id number) return varchar2 ;
50
51 -------------------------------------------------------------------------------
52
53 function get_salary ( p_pay_basis_id number,
54 p_assignment_id number,
55 p_effective_date date )
56 return varchar2;
57
58 -------------------------------------------------------------------------------
59
60 procedure balance_totals
61 (p_assignment_id in per_all_assignments_f.assignment_id%type,
62 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
63 p_effective_date in date,
64 p_gross_this_pay out nocopy number,
65 p_other_deductions_this_pay out nocopy number,
66 p_tax_deductions_this_pay out nocopy number,
67 p_gross_ytd out nocopy number,
68 p_other_deductions_ytd out nocopy number,
69 p_tax_deductions_ytd out nocopy number,
70 p_non_tax_allow_this_pay out nocopy number,
71 p_non_tax_allow_ytd out nocopy number,
72 p_pre_tax_deductions_this_pay out nocopy number,
73 p_pre_tax_deductions_ytd out nocopy number);
74
75
76 function business_currency_code
77 (p_business_group_id in hr_organization_units.business_group_id%type)
78 return fnd_currencies.currency_code%type;
79
80 procedure run_and_ytd_balances
81 (p_assignment_id in per_all_assignments_f.assignment_id%type,
82 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
83 p_effective_date in date,
84 p_balance_name in pay_balance_types.balance_name%type,
85 p_run_balance out nocopy number,
86 p_ytd_balance out nocopy number);
87
88 procedure get_asg_latest_pay(p_session_date in date,
89 p_payroll_exists in out nocopy varchar2,
90 p_assignment_action_id in out nocopy number,
91 p_run_assignment_action_id in out nocopy number,
92 p_assignment_id in number,
93 p_payroll_id out nocopy number,
94 p_payroll_action_id in out nocopy number,
95 p_date_earned in out nocopy varchar2,
96 p_time_period_id out nocopy number,
97 p_period_name out nocopy varchar2,
98 p_pay_advice_date out nocopy date,
99 p_pay_advice_message out nocopy varchar2);
100
101 procedure get_details (p_assignment_action_id in out nocopy number,
102 p_run_assignment_action_id in out nocopy number,
103 p_assignment_id in out nocopy number,
104 p_payroll_id out nocopy number,
105 p_payroll_action_id in out nocopy number,
106 p_date_earned in out nocopy date,
107 p_time_period_id out nocopy number,
108 p_period_name out nocopy varchar2,
109 p_pay_advice_date out nocopy date,
110 p_pay_advice_message out nocopy varchar2);
111 procedure final_balance_totals
112 (p_assignment_id in per_all_assignments_f.assignment_id%type,
113 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
114 p_effective_date in date,
115 p_gross_this_pay out nocopy number,
116 p_other_deductions_this_pay out nocopy number,
117 p_tax_deductions_this_pay out nocopy number,
118 p_gross_ytd out nocopy number,
119 p_other_deductions_ytd out nocopy number,
120 p_tax_deductions_ytd out nocopy number,
121 p_non_tax_allow_this_pay out nocopy number,
122 p_non_tax_allow_ytd out nocopy number,
123 p_pre_tax_deductions_this_pay out nocopy number,
124 p_pre_tax_deductions_ytd out nocopy number);
125
126 END pay_nz_soe_pkg ;