1 package pay_au_soe_pkg AUTHID CURRENT_USER as
2 /* $Header: pyausoe.pkh 120.11.12020000.2 2012/12/21 07:54:49 ruihuang ship $ */
3
4 procedure get_home_address
5 (p_person_id in per_addresses.person_id%type,
6 p_address_line1 out NOCOPY per_addresses.address_line1%type,
7 p_address_line2 out NOCOPY per_addresses.address_line2%type,
8 p_address_line3 out NOCOPY per_addresses.address_line3%type,
9 p_town_city out NOCOPY per_addresses.town_or_city%type,
10 p_postal_code out NOCOPY per_addresses.postal_code%type,
11 p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
12
13 procedure get_work_address
14 (p_location_id in hr_locations.location_id%type,
15 p_address_line1 out NOCOPY hr_locations.address_line_1%type,
16 p_address_line2 out NOCOPY hr_locations.address_line_2%type,
17 p_address_line3 out NOCOPY hr_locations.address_line_3%type,
18 p_town_city out NOCOPY hr_locations.town_or_city%type,
19 p_postal_code out NOCOPY hr_locations.postal_code%type,
20 p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
21
22 function get_salary
23 (p_pay_basis_id in per_pay_bases.pay_basis_id%type,
24 p_assignment_id in pay_element_entries_f.assignment_id%type,
25 p_effective_date in date)
26 return varchar2;
27
28 function business_currency_code
29 (p_business_group_id in hr_organization_units.business_group_id%type)
30 return fnd_currencies.currency_code%type;
31
32 /* Bug 4169557 - Introduced procedure for populating LE dimension Defined Balance ID's
33 */
34 procedure populate_defined_balances;
35
36 procedure balance_totals
37 (p_assignment_id in per_all_assignments_f.assignment_id%type,
38 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
39 p_effective_date in date,
40 p_gross_this_pay out NOCOPY number,
41 p_other_deductions_this_pay out NOCOPY number,
42 p_tax_deductions_this_pay out NOCOPY number,
43 p_gross_ytd out NOCOPY number,
44 p_other_deductions_ytd out NOCOPY number,
45 p_tax_deductions_ytd out NOCOPY number,
46 p_non_tax_allowances_run out NOCOPY number,
47 p_non_tax_allowances_ytd out NOCOPY number,
48 p_pre_tax_deductions_run out NOCOPY number,
49 p_pre_tax_deductions_ytd out NOCOPY number,
50 p_super_run out NOCOPY number,
51 p_super_ytd out NOCOPY number,
52 p_taxable_income_this_pay out NOCOPY number,
53 p_taxable_income_ytd out NOCOPY number,
54 p_direct_payments_run out NOCOPY number,
55 p_direct_payments_ytd out NOCOPY number,
56 p_get_le_level_bal in varchar2 ,
57 p_fetch_only_ytd_value in varchar2);
58
59 /* bug 3935483 2 new parameters added to balance_totals and final_balance_totals p_get_le_level_bal when Y the le level balances,run and ytd, would be fetched
60 p_fetch_only_ytd_value when Y ytd balances would be fetched and run balances would not be fetched*/
61
62 procedure get_asg_latest_pay(p_session_date in date,
63 p_payroll_exists in out NOCOPY varchar2,
64 p_assignment_action_id in out NOCOPY number,
65 p_run_assignment_action_id in out NOCOPY number,
66 p_assignment_id in number,
67 p_payroll_id out NOCOPY number,
68 p_payroll_action_id in out NOCOPY number,
69 p_date_earned in out NOCOPY varchar2,
70 p_time_period_id out NOCOPY number,
71 p_period_name out NOCOPY varchar2,
72 p_pay_advice_date out NOCOPY date,
73 p_pay_advice_message out NOCOPY varchar2);
74
75 procedure get_details (p_assignment_action_id in out NOCOPY number,
76 p_run_assignment_action_id in out NOCOPY number,
77 p_assignment_id in out NOCOPY number,
78 p_payroll_id out NOCOPY number,
79 p_payroll_action_id in out NOCOPY number,
80 p_date_earned in out NOCOPY date,
81 p_time_period_id out NOCOPY number,
82 p_period_name out NOCOPY varchar2,
83 p_pay_advice_date out NOCOPY date,
84 p_pay_advice_message out NOCOPY varchar2);
85 procedure final_balance_totals
86 (p_assignment_id in per_all_assignments_f.assignment_id%type,
87 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
88 p_effective_date in date,
89 p_gross_this_pay out NOCOPY number,
90 p_other_deductions_this_pay out NOCOPY number,
91 p_tax_deductions_this_pay out NOCOPY number,
92 p_gross_ytd out NOCOPY number,
93 p_other_deductions_ytd out NOCOPY number,
94 p_tax_deductions_ytd out NOCOPY number,
95 p_non_tax_allow_this_pay out NOCOPY number,
96 p_non_tax_allow_ytd out NOCOPY number,
97 p_pre_tax_deductions_this_pay out NOCOPY number,
98 p_pre_tax_deductions_ytd out NOCOPY number,
99 p_super_this_pay out NOCOPY number,
100 p_super_ytd out NOCOPY number,
101 p_taxable_income_this_pay out NOCOPY number,
102 p_taxable_income_ytd out NOCOPY number,
103 p_direct_payments_this_pay out NOCOPY number,
104 p_direct_payments_ytd out NOCOPY number,
105 p_get_le_level_bal in varchar2 ,
106 p_fetch_only_ytd_value in varchar2);
107
108
109 function super_fund_name
110 (p_source_id in number,
111 p_element_reporting_name in pay_element_types_f.reporting_name%type,
112 p_date_earned in pay_payroll_actions.date_earned%type,
113 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
114 p_assignment_id in per_all_assignments_f.assignment_id%type,
115 p_element_entry_id in pay_element_entries_f.PERSONAL_PAYMENT_METHOD_ID%TYPE,
116 p_business_group_id per_all_assignments_f.business_group_id%TYPE)
117
118 return varchar2;
119
120 /* Bug 5591333 - Function is used to compute Hours for Elements.
121 */
122
123 FUNCTION get_element_payment_hours
124 (
125 p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
126 p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
127 p_pay_bases_id IN per_all_assignments_f.pay_basis_id%TYPE,
128 p_run_result_id IN pay_run_results.run_result_ID%TYPE,
129 p_effective_date IN pay_payroll_actions.effective_date%TYPE
130 )
131 RETURN NUMBER;
132
133 /* 5599310 */
134
135 FUNCTION get_element_payment_rate
136 (
137 p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
138 p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
139 p_run_result_id IN pay_run_results.run_result_ID%TYPE,
140 p_effective_date IN pay_payroll_actions.effective_date%TYPE
141 )
142 RETURN NUMBER;
143
144 /* Bug 5597052 - Function added to compute Hours for pay_au_asg_leave_taken_v */
145
146 FUNCTION get_leave_taken_hours
147 (
148 p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
149 p_run_result_id IN pay_run_results.run_result_ID%TYPE,
150 p_effective_date IN pay_payroll_actions.effective_date%TYPE
151 )
152 RETURN NUMBER;
153
154 /*Bug 5689508 Function to get Currency Code */
155 FUNCTION get_currency_code
156 (p_business_group_id in hr_organization_units.business_group_id%type,
157 p_payroll_id in pay_payrolls_f.payroll_id%type,
158 p_effective_date in date)
159 RETURN fnd_currencies.currency_code%type;
160
161 /*Bug 9221420 - Function to get payment effective date */
162 FUNCTION get_effective_date
163 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE)
164 RETURN pay_payroll_actions.effective_date%TYPE;
165
166 /* Bug 8344279 - Get flag indicating whether Pay advice for one assignment
167 * should be printed or not */
168 FUNCTION get_doc_eit (p_assignment_id in number,
169 p_payroll_action_id in number)
170 RETURN varchar2;
171
172 end pay_au_soe_pkg;