[Home] [Help]
PACKAGE: APPS.HR_US_REPORTS
Source
1 PACKAGE hr_us_reports AS
2 /* $Header: pyuslrep.pkh 120.0.12010000.2 2008/08/06 08:33:31 ubhat ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
7 * Chertsey, England. *
8 * *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation UK Ltd, *
18 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
19 * England. *
20 * *
21 ******************************************************************
22 Name : hr_us_reports (HEADER)
23 File : pyuslrep.pkh
24 Description : This package declares functions and procedures which are used
25 to return values for the srw2 US Payroll r10 reports.
26
27 Change List
28 -----------
29
30 Version Date Author ER/CR No. Description of Change
31 -------+---------+----------+---------+--------------------------
32 40.0 13-SEP-93 AKelly Date Created
33 40.1 12-NOV-93 AKelly Added get_legislation_code
34 40.2 22-NOV-93 AKelly Added get_defined_balance_id
35 40.3 22-NOV-93 AKelly Added get_startup_defined_balance
36 40.4 11-DEC-93 MSwanson Added 'get_payment_type_name'.
37 Added 'get_element_type_name'.
38 40.5 17-FEB-94 GPayton-McDowall added get_ben_class_name
39 40.6 01-MAR-94 GPayton-McDowall added get_cobra_qualifying_event
40 get_cobra_status
41 40.7 23-Mar-94 MSwanson Added get_org_name, get_est_tax_unit and
42 get_org_hierarchy_name for EEO reporting.
43 40.8 25-Mar-94 MSwanson Added get_county_address for eeo and tax reps.
44 Added get_activity for eeo reps.
45 40.9 03-Jul-94 A Roussel Tidy up for 10G install
46 40.10 12-Oct-94 MSwanson Add get_defined_balance_by_type.
47 Add get_employee_address.
48 Add get_person_name.
49 40. 20-apr-95 MSwanson Add get_career_path_name.
50 40.7 19-oct-95 MSwanson Add get_state_name.
51 40.8 20-Oct-95 MSwanson Add get_new_hire_contact.
52 40.9 25-Oct-95 MSwanson Add get_salary.
53 40.10 21-May-96 nlee Bug 366087 Add new procedure
54 get_address_31.
55 Add function get_location_code.
56 40.11 3-Jul-96 S Desai/G Perry Moved get_address_31 and
57 get_location_code to the bottom of
58 the header file. This innocuous
59 change was required because Oracle Reports
60 stored the function sequence instead of the
61 name. Therefore, checkwriter would execute
62 the wrong function.
63 40.19 05-NOV-1996 hekim Added function get_address_3lines
64 40.20 18-NOV-1996 hekim Added effective_date to get_address_3lines
65 40.26 17-APR-2000 mcpham Added function fnc_get_payee for report PAYRPTPP a
66 nd bug 1063477
67
68
69 115.2 25-FEB-2002 vbanner Added function get_hr_est_tax_unit.
70 Bug 2722353.
71 115.3 25-FEB-2002 vbanner Added dbdrv command etc for GSCC
72 115.4 22-OCT-2003 ynegoro Added nocopy for GSCC
73 115.5 23-OCT-2003 ynegoro 3182433 Added get_top_org_id function
74 115.6 05-MAY-2005 ynegoro 4346783 Added verify_state function
75 115.7 12-MAR-2008 psugumar 6774707 Added get_employee_address40
76 =================================================================
77 */
78 FUNCTION get_salary (p_business_group_id NUMBER,
79 p_assignment_id NUMBER,
80 p_report_date DATE
81 ) return number;
82 --
83 --
84 procedure get_new_hire_contact( p_person_id in number,
85 p_business_group_id in number,
86 p_report_date in date,
87 p_contact_name out nocopy varchar2,
88 p_contact_title out nocopy varchar2,
89 p_contact_phone out nocopy varchar2
90 );
91 --
92 --
93 procedure get_address(p_location_id in number, p_address out nocopy varchar2);
94 --
95 --
96 procedure get_employee_address(p_person_id in number, p_address out nocopy varchar2);
97 --
98 --
99 procedure get_county_address(p_location_id in number, p_address out nocopy varchar2);
100 --
101 --
102 procedure get_activity(p_establishment_id in number, p_activity out nocopy varchar2);
103 --
104 --
105 FUNCTION fnc_get_payee
106 ( IN_payee_id IN NUMBER,
107 IN_payee_type IN VARCHAR2,
108 IN_payment_date IN DATE,
109 IN_business_group_id IN NUMBER)
110 RETURN VARCHAR2;
111
112 PRAGMA RESTRICT_REFERENCES (fnc_get_payee, WNDS);
113 --
114 --
115 FUNCTION get_consolidation_set(p_consolidation_set_id number)
116 return varchar2;
117 --
118 --
119 FUNCTION get_payment_type_name(p_payment_type_id number)
120 return varchar2;
121 --
122 --
123 FUNCTION get_element_type_name(p_element_type_id number)
124 return varchar2;
125 --
126 --
127 FUNCTION get_tax_unit(p_tax_unit_id number)
128 return varchar2;
129 --
130 --
131 FUNCTION get_person_name(p_person_id number)
132 return varchar2;
133 --
134 --
135 FUNCTION get_payroll_action(p_payroll_action_id number)
136 return varchar2;
137 --
138 --
139 FUNCTION get_legislation_code(p_business_group_id number)
140 return varchar2;
141 --
142 --
143 FUNCTION get_defined_balance_id(p_balance_name VARCHAR2,
144 p_dimension_suffix VARCHAR2,
145 p_business_group_id NUMBER)
146 return number;
147 --
148 --
149 FUNCTION get_startup_defined_balance(p_reporting_name VARCHAR2,
150 p_dimension_suffix VARCHAR2)
151 return number;
152 --
153 --
154 --
155 FUNCTION get_defined_balance_by_type(p_box_num VARCHAR2,
156 p_dimension_suffix VARCHAR2)
157 return number;
158 --
159 FUNCTION get_ben_class_name
160 (p_session_date DATE,
161 p_benefit_classification_id NUMBER) return VARCHAR2;
162 --
163 --
164 FUNCTION get_cobra_qualifying_event
165 ( p_qualifying_event VARCHAR2 ) return VARCHAR2;
166 --
167 --
168 FUNCTION get_cobra_status
169 ( p_cobra_status VARCHAR2 ) return VARCHAR2;
170 --
171 --
172 --
173 function get_est_tax_unit (p_starting_org_id number,
174 p_org_structure_version_id number
175 ) RETURN number;
176 --
177 function get_hr_est_tax_unit (p_starting_org_id number,
178 p_org_structure_version_id number
179 ) RETURN number;
180 --
181 function get_org_hierarchy_name (p_org_structure_version_id number
182 ) RETURN varchar2;
183 --
184 function get_state_name (p_state_code varchar2
185 ) RETURN varchar2;
186 --
187 function get_org_name (p_organization_id number, p_business_group_id number
188 ) RETURN varchar2;
189 --
190 FUNCTION get_career_path_name (p_career_path_id number,
191 p_business_group_id number
192 ) RETURN varchar2;
193 --
194 FUNCTION get_aap_org_id (p_aap_name varchar2, p_business_group_id number
195 ) RETURN number;
196 --
197 procedure get_address_31(p_location_id in number, p_address out nocopy varchar2);
198 --
199 --
200 FUNCTION get_location_code (p_location_id number) RETURN varchar2;
201 --
202 procedure get_address_3lines(p_person_id in number,
203 p_effective_date in date,
204 p_addr_line1 out nocopy varchar2,
205 p_addr_line2 out nocopy varchar2,
206 p_city_state_zip out nocopy varchar2);
207 --
208 -- BUG3182433
209 --
210 FUNCTION get_top_org_id
211 (p_business_group_id number
212 ,p_org_structure_version_id number) RETURN number;
213
214 --
215 -- BUG4346783
216 -- For VETS-100 Consolidated Report
217 -- This function is called from Q_2_STATE query
218 --
219 FUNCTION verify_state
220 (p_date_start in date
221 ,p_date_end in date
222 ,p_business_group_id in number
223 ,p_hierarchy_version_id in number
224 ,p_state in varchar2
225 ) return number;
226 --
227 -- end of hr_us_reports
228 --
229 procedure get_employee_address40(p_person_id in number,p_address out nocopy varchar2);
230 end hr_us_reports;