1 PACKAGE pay_us_employee_payslip_web
2 /* $Header: pyusempw.pkh 120.1.12010000.2 2008/08/06 08:29:30 ubhat ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_us_employee_payslip_web
21
22
23 Description : Package contains functions and procedures used
24 by te Online Payslip Views.
25
26 Uses :
27
28 Change List
29 -----------
30 Date Name Vers Bug No Description
31 ---- ---- ---- ------ -----------
32 05-MAR-2008 sudedas 115.17 6739242 New Function get_netpaydistr_segment
33 Added.
34 08-SEP-2005 ppanda 115.16 For Enhanced multi jurisdiction taxation
35 a new function added to derive the
36 full jurisdiction name (State, County, City)
37 using the existing function get_jurisdiction_nmame
38 05-MAY-2005 ahanda 115.15 4246280 Changed Payslip code to check for
39 View Payslip offset before showing
40 Payslip for an employee.
41 Added overloaded function -
42 check_emp_personal_payment with
43 parameter of p_time_period_id
44 19-JAN-2005 sodhingr 115.14 4132132 Changed the function get_term_info
45 05-NOV-2003 pganguly 115.13 Added two pkg variables.
46 19-JUL-2003 ahanda 115.12 Added function format_to_date.
47 14-NOV-2002 tclewis 115.11 Changed order of parameters in
48 get_check_number now AA_ID, PP_ID.
49 27-SEP-2002 sodhingr 115.9 Added check for GSCC compliance.
50 16-JUN-2002 sodhingr 115.8 Added a new function get_term_info
51 to check
52 the terminated employee based
53 on the legislation_field_info
54 13-MAY-2002 pganguly 115.7 2363857 Added a new function
55 get_legislation_code.
56 21-MAR-2002 ekim 115.6 Changed get_doc_eit function.
57 24-JAN-2002 dgarg 115.4 Added get_jurisdiction_name
58 function
59 05-OCT-2001 ekim 115.3 Added get_doc_eit function.
60 21-SEP-2001 ekim 115.2 Added get_format_value function.
61 17-SEP-2001 asasthan 115.1 Added get_check_number for payslip
62 08-FEB-2000 ahanda 115.0 Removed all reference to PRAGMA
63
64 ***********************************************************************
65 ** Removed All reference to PRAGMA for 11i.
66 ***********************************************************************
67
68 01-FEB-2000 ahanda 110.2 Removed element_name parameter from
69 School dsts function.
70 01-FEB-2000 ahanda 110.1 Added function to get School Dst Name.
71 01-JUL-1999 ahanda 110.0 Created.
72
73 *******************************************************************/
74 AS
75
76 -- Global Variable for the Package
77 --
78 g_currency_code varchar2(10) := null;
79 g_legislation_code varchar2(2) := null;
80 g_legislation_rule varchar2(30) := null;
81
82 TYPE eit_rec is RECORD
83 ( t_level varchar2(150),
84 t_id number,
85 t_online varchar2(1),
86 t_print varchar2(1));
87
88 TYPE eit_table is TABLE OF eit_rec INDEX BY BINARY_INTEGER;
89
90 eit_tab eit_table;
91
92 FUNCTION get_doc_eit (p_doc_type in varchar,
93 p_mode in varchar,
94 p_level in varchar,
95 p_id in number,
96 p_effective_date date)
97
98 RETURN varchar2;
99
100
101 FUNCTION get_format_value (p_business_group_id in number,
102 p_value in number)
103 return varchar2;
104
105
106 FUNCTION check_emp_personal_payment
107 (p_assignment_id number,
108 p_payroll_id number,
109 p_time_period_id number,
110 p_assignment_action_id number,
111 p_effective_date date)
112 return varchar2;
113
114 -- Added for Testing
115 --
116 FUNCTION check_emp_personal_payment
117 (p_assignment_id number,
118 p_payroll_id number,
119 p_time_period_id number,
120 p_assignment_action_id number,
121 p_effective_date date,
122 p_payment_category varchar2,
123 p_legislation_code varchar2)
124 return varchar2;
125
126
127 FUNCTION check_emp_personal_payment
128 (p_assignment_id number,
129 p_payroll_id number,
130 p_assignment_action_id number,
131 p_effective_date date)
132 return varchar2;
133
134
135 FUNCTION get_proposed_emp_salary (p_assignment_id in number,
136 p_pay_basis_id in number,
137 p_pay_bases_name in varchar2,
138 p_period_start_date in date,
139 p_period_end_date in date)
140 return varchar2;
141
142
143 FUNCTION get_emp_annualization_factor
144 (p_pay_basis_id in number,
145 p_period_type in varchar2,
146 p_pay_bases_name in varchar2,
147 p_assignment_id in number,
148 p_period_end_date in date)
149 return number;
150
151
152 FUNCTION get_asgn_annual_hours (p_assignment_id in number,
153 p_period_end_date in date)
154 return number;
155
156
157 FUNCTION get_school_dsts_name (p_jurisdiction_code in varchar2)
158 return varchar2;
159
160 FUNCTION get_check_number(p_pre_payment_assact in number
161 ,p_pre_payment_id in number)
162 return varchar2;
163
164
165 FUNCTION get_jurisdiction_name( p_jurisdiction_code in varchar2)
166 return varchar2;
167
168 FUNCTION get_legislation_code( p_business_group_id in number)
169 return varchar2;
170
171 FUNCTION get_term_info (p_business_group_id in number,
172 p_person_id in number,
173 p_action_context_id number)
174 /* for bug 4132132
175 p_effective_start_date date,
176 p_effective_end_date date) */
177 RETURN varchar2;
178
179 FUNCTION get_meaning_payslip_label(p_leg_code in VARCHAR2,
180 p_lookup_code in VARCHAR2)
181 RETURN VARCHAR2;
182
183 FUNCTION format_to_date(p_char_date in varchar2)
184 RETURN date;
185
186 FUNCTION get_full_jurisdiction_name( p_jurisdiction_code in varchar2)
187 return varchar2;
188
189 -- This Function has been Added for Bug# 6739242
190 -- For CA OT Enhancement pay_action_information started getting
191 -- Populated with Account Details that is NOT needed to be displayed
192 -- In Self Service Payslip
193 FUNCTION get_netpaydistr_segment(p_business_grp_id IN NUMBER
194 ,p_org_pay_meth_id IN NUMBER)
195 RETURN VARCHAR2;
196
197 end pay_us_employee_payslip_web;