1 PACKAGE PSB_HR_POPULATE_DATA_PVT AS
2 /* $Header: PSBVHRPS.pls 120.6 2005/10/27 16:09:58 matthoma ship $ */
3
4 /*-------------------------------------------------------------*/
5 /* Define Global Variables for the Incremental Extract Process */
6
7 g_psb_budget_group_id NUMBER;
8 g_psb_worksheet_id NUMBER;
9 g_psb_current_form VARCHAR2(20);
10 g_psb_data_extract_id NUMBER;
11 g_psb_business_group_id NUMBER;
12 g_psb_application_id NUMBER;
13 g_psb_org_id NUMBER;
14 g_psb_revision_start_date DATE;
15 g_psb_revision_end_date DATE;
16
17 /* start bug 4153562 */
18 -- This global variable is set in the
19 -- populate_position_assignments API.
20 g_extract_method VARCHAR2(30);
21 /* end bug 4153562 */
22
23 /* start bug 4213882 */
24 g_pop_assignment VARCHAR2(1);
25 /* end bug 4213882 */
26
27
28 Procedure set_global(g_var_name IN varchar2,
29 g_var_value IN varchar2);
30
31 Function get_global(g_var_name IN varchar2) return varchar2;
32
33 Procedure Insert_Position_Txn_Info
34 (
35 p_position_transaction_id in number ,
36 p_action_date in date ,
37 p_position_id in number ,
38 p_availability_status_id in number ,
39 p_business_group_id in number ,
40 p_entry_step_id in number ,
41 p_entry_grade_rule_id in number ,
42 p_job_id in number ,
43 p_location_id in number ,
44 p_organization_id in number ,
45 p_pay_freq_payroll_id in number ,
46 p_position_definition_id in number ,
47 p_prior_position_id in number ,
48 p_relief_position_id in number ,
49 p_entry_grade_id in number ,
50 p_successor_position_id in number ,
51 p_supervisor_position_id in number ,
52 p_amendment_date in date ,
53 p_amendment_recommendation in varchar2 ,
54 p_amendment_ref_number in varchar2 ,
55 p_avail_status_prop_end_date in date ,
56 p_bargaining_unit_cd in varchar2 ,
57 p_comments in long ,
58 p_country1 in varchar2 ,
59 p_country2 in varchar2 ,
60 p_country3 in varchar2 ,
61 p_current_job_prop_end_date in date ,
62 p_current_org_prop_end_date in date ,
63 p_date_effective in date ,
64 p_date_end in date ,
65 p_earliest_hire_date in date ,
66 p_fill_by_date in date ,
67 p_frequency in varchar2 ,
68 p_fte in number ,
69 p_location1 in varchar2 ,
70 p_location2 in varchar2 ,
71 p_location3 in varchar2 ,
72 p_max_persons in number ,
73 p_name in varchar2 ,
74 p_other_requirements in varchar2 ,
75 p_overlap_period in number ,
76 p_overlap_unit_cd in varchar2 ,
77 p_passport_required in varchar2 ,
78 p_pay_term_end_day_cd in varchar2 ,
79 p_pay_term_end_month_cd in varchar2 ,
80 p_permanent_temporary_flag in varchar2 ,
81 p_permit_recruitment_flag in varchar2 ,
82 p_position_type in varchar2 ,
83 p_posting_description in varchar2 ,
84 p_probation_period in number ,
85 p_probation_period_unit_cd in varchar2 ,
86 p_relocate_domestically in varchar2 ,
87 p_relocate_internationally in varchar2 ,
88 p_replacement_required_flag in varchar2 ,
89 p_review_flag in varchar2 ,
90 p_seasonal_flag in varchar2 ,
91 p_security_requirements in varchar2 ,
92 p_service_minimum in varchar2 ,
93 p_term_start_day_cd in varchar2 ,
94 p_term_start_month_cd in varchar2 ,
95 p_time_normal_finish in varchar2 ,
96 p_time_normal_start in varchar2 ,
97 p_transaction_status in varchar2 ,
98 p_travel_required in varchar2 ,
99 p_working_hours in number ,
100 p_works_council_approval_flag in varchar2 ,
101 p_work_any_country in varchar2 ,
102 p_work_any_location in varchar2 ,
103 p_work_period_type_cd in varchar2 ,
104 p_work_schedule in varchar2 ,
105 p_work_term_end_day_cd in varchar2 ,
106 p_work_term_end_month_cd in varchar2 ,
107 p_proposed_fte_for_layoff in number,
108 p_proposed_date_for_layoff in date,
109 p_information1 in varchar2 ,
110 p_information2 in varchar2 ,
111 p_information3 in varchar2 ,
112 p_information4 in varchar2 ,
113 p_information5 in varchar2 ,
114 p_information6 in varchar2 ,
115 p_information7 in varchar2 ,
116 p_information8 in varchar2 ,
117 p_information9 in varchar2 ,
118 p_information10 in varchar2 ,
119 p_information11 in varchar2 ,
120 p_information12 in varchar2 ,
121 p_information13 in varchar2 ,
122 p_information14 in varchar2 ,
123 p_information15 in varchar2 ,
124 p_information16 in varchar2 ,
125 p_information17 in varchar2 ,
126 p_information18 in varchar2 ,
127 p_information19 in varchar2 ,
128 p_information20 in varchar2 ,
129 p_information21 in varchar2 ,
130 p_information22 in varchar2 ,
131 p_information23 in varchar2 ,
132 p_information24 in varchar2 ,
133 p_information25 in varchar2 ,
134 p_information26 in varchar2 ,
135 p_information27 in varchar2 ,
136 p_information28 in varchar2 ,
137 p_information29 in varchar2 ,
138 p_information30 in varchar2 ,
139 p_information_category in varchar2 ,
140 p_attribute1 in varchar2 ,
141 p_attribute2 in varchar2 ,
142 p_attribute3 in varchar2 ,
143 p_attribute4 in varchar2 ,
144 p_attribute5 in varchar2 ,
145 p_attribute6 in varchar2 ,
146 p_attribute7 in varchar2 ,
147 p_attribute8 in varchar2 ,
148 p_attribute9 in varchar2 ,
149 p_attribute10 in varchar2 ,
150 p_attribute11 in varchar2 ,
151 p_attribute12 in varchar2 ,
152 p_attribute13 in varchar2 ,
153 p_attribute14 in varchar2 ,
154 p_attribute15 in varchar2 ,
155 p_attribute16 in varchar2 ,
156 p_attribute17 in varchar2 ,
157 p_attribute18 in varchar2 ,
158 p_attribute19 in varchar2 ,
159 p_attribute20 in varchar2 ,
160 p_attribute21 in varchar2 ,
161 p_attribute22 in varchar2 ,
162 p_attribute23 in varchar2 ,
163 p_attribute24 in varchar2 ,
164 p_attribute25 in varchar2 ,
165 p_attribute26 in varchar2 ,
166 p_attribute27 in varchar2 ,
167 p_attribute28 in varchar2 ,
168 p_attribute29 in varchar2 ,
169 p_attribute30 in varchar2 ,
170 p_attribute_category in varchar2 ,
171 p_object_version_number in number ,
172 p_effective_date in date ,
173 p_pay_basis_id in number ,
174 p_supervisor_id in number
175 );
176
177 PROCEDURE Update_Position_Txn_Info
178 (p_position_transaction_id in NUMBER,
179 p_action_date in DATE ,
180 p_position_id in NUMBER,
181 p_availability_status_id in NUMBER,
182 p_business_group_id in NUMBER,
183 p_entry_step_id in NUMBER,
184 p_entry_grade_rule_id in NUMBER,
185 p_job_id in NUMBER,
186 p_location_id in NUMBER,
187 p_organization_id in NUMBER,
188 p_pay_freq_payroll_id in NUMBER,
189 p_position_definition_id in NUMBER,
190 p_entry_grade_id in NUMBER,
191 p_bargaining_unit_cd in VARCHAR2,
192 p_date_effective in DATE,
193 p_date_end in DATE,
194 p_earliest_hire_date in DATE,
195 p_frequency in VARCHAR2,
196 p_fte in NUMBER,
197 p_name in VARCHAR2,
198 p_position_type in VARCHAR2,
199 p_transaction_status in VARCHAR2,
200 p_working_hours in NUMBER,
201 p_pay_basis_id_o in number ,
202 p_object_version_number in NUMBER,
203 p_effective_date in DATE
204 );
205
206
207 PROCEDURE Insert_Position_Info
208 (p_position_id in NUMBER ,
209 p_effective_start_date in DATE ,
210 p_effective_end_date in DATE ,
211 p_availability_status_id in NUMBER ,
212 p_business_group_id in NUMBER ,
213 p_entry_step_id in NUMBER ,
214 p_entry_grade_rule_id in NUMBER ,
215 p_job_id in NUMBER ,
216 p_location_id in NUMBER ,
217 p_organization_id in NUMBER ,
218 p_position_definition_id in NUMBER ,
219 p_position_transaction_id in NUMBER ,
220 p_entry_grade_id in NUMBER ,
221 p_bargaining_unit_cd in VARCHAR2 ,
222 p_date_effective in DATE ,
223 p_date_end in DATE ,
224 p_earliest_hire_date in DATE ,
225 p_fill_by_date in DATE ,
226 p_frequency in VARCHAR2 ,
227 p_working_hours in NUMBER,
228 p_fte in NUMBER ,
229 p_name in VARCHAR2 ,
230 p_position_type in VARCHAR2 ,
231 p_pay_basis_id in NUMBER ,
232 p_object_version_number in NUMBER
233 );
234
235 PROCEDURE Update_Position_Info
236 (p_position_id in NUMBER ,
237 p_effective_start_date in DATE ,
238 p_effective_end_date in DATE ,
239 p_availability_status_id in NUMBER ,
240 p_business_group_id_o in NUMBER ,
241 p_entry_step_id in NUMBER ,
242 p_entry_grade_rule_id in NUMBER ,
243 p_job_id_o in NUMBER ,
244 p_location_id in NUMBER ,
245 p_organization_id_o in NUMBER ,
246 p_position_definition_id in NUMBER ,
247 p_position_transaction_id in NUMBER ,
248 p_entry_grade_id in NUMBER ,
249 p_bargaining_unit_cd in VARCHAR2 ,
250 p_date_effective in DATE ,
251 p_date_end in DATE ,
252 p_earliest_hire_date in DATE ,
253 p_fill_by_date in DATE ,
254 p_frequency in VARCHAR2 ,
255 p_working_hours in NUMBER,
256 p_fte in NUMBER ,
257 p_name in VARCHAR2 ,
258 p_position_type in VARCHAR2 ,
259 p_pay_basis_id in NUMBER ,
260 p_object_version_number in NUMBER ,
261 p_effective_date in DATE
262 );
263 /*-------------------------------------------------------------*/
264
265
266 TYPE gl_distribution_rec_type is RECORD
267 (ccid NUMBER,
268 project_id NUMBER,
269 task_id NUMBER,
270 award_id NUMBER,
271 expenditure_type VARCHAR2(30),
272 expenditure_org_id NUMBER,
273 description VARCHAR2(185),
274 distr_percent NUMBER,
275 effective_start_date DATE,
276 effective_end_date DATE,
277 exist_flag VARCHAR2(1));
278
279 TYPE gl_distribution_tbl_type IS TABLE OF gl_distribution_rec_type
280 INDEX BY BINARY_INTEGER;
281
282 Cursor G_Employee_Details(p_person_id in number) is
283 Select first_name , last_name
284 from psb_employees_i
285 where hr_employee_id = p_person_id;
286
287 Cursor G_Position_Details(p_position_id in number) is
288 Select name
289 from psb_positions
290 where position_id = p_position_id;
291
292 PROCEDURE Populate_Position_Information
293 ( p_api_version IN NUMBER,
294 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295 p_commit IN VARCHAR2 := FND_API.G_FALSE,
296 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
297 p_return_status OUT NOCOPY VARCHAR2,
298 p_msg_count OUT NOCOPY NUMBER,
299 p_msg_data OUT NOCOPY VARCHAR2,
300 p_data_extract_id IN NUMBER,
301 -- de by org
302 p_extract_by_org IN VARCHAR2,
303 p_extract_method IN VARCHAR2,
304 p_business_group_id IN NUMBER,
305 p_set_of_books_id IN NUMBER
306 );
307
308 PROCEDURE Populate_Employee_Information
309 ( p_api_version IN NUMBER,
310 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
311 p_commit IN VARCHAR2 := FND_API.G_FALSE,
312 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
313 p_return_status OUT NOCOPY VARCHAR2,
314 p_msg_count OUT NOCOPY NUMBER,
315 p_msg_data OUT NOCOPY VARCHAR2,
316 p_data_extract_id IN NUMBER,
317 -- de by org
318 p_extract_by_org IN VARCHAR2,
319 p_extract_method IN VARCHAR2,
320 p_business_group_id IN NUMBER,
321 p_set_of_books_id IN NUMBER
322 );
323
324 PROCEDURE Populate_Element_Information
325 ( p_api_version IN NUMBER,
326 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
327 p_commit IN VARCHAR2 := FND_API.G_FALSE,
328 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
329 p_return_status OUT NOCOPY VARCHAR2,
330 p_msg_count OUT NOCOPY NUMBER,
331 p_msg_data OUT NOCOPY VARCHAR2,
332 p_data_extract_id IN NUMBER,
333 p_extract_method IN VARCHAR2,
334 p_business_group_id IN NUMBER,
335 p_set_of_books_id IN NUMBER
336 );
337
338 PROCEDURE Populate_Costing_Information
339 ( p_api_version IN NUMBER,
340 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
341 p_commit IN VARCHAR2 := FND_API.G_FALSE,
342 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
343 p_return_status OUT NOCOPY VARCHAR2,
344 p_msg_count OUT NOCOPY NUMBER,
345 p_msg_data OUT NOCOPY VARCHAR2,
346 p_data_extract_id IN NUMBER,
347 -- de by org
348 p_extract_by_org IN VARCHAR2,
349 p_extract_method IN VARCHAR2,
350 p_business_group_id IN NUMBER
351 );
352
353 PROCEDURE Populate_Attribute_Values
354 ( p_api_version IN NUMBER,
355 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
356 p_commit IN VARCHAR2 := FND_API.G_FALSE,
357 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
358 p_return_status OUT NOCOPY VARCHAR2,
359 p_msg_count OUT NOCOPY NUMBER,
360 p_msg_data OUT NOCOPY VARCHAR2,
361 p_data_extract_id IN NUMBER,
362 p_extract_method IN VARCHAR2,
363 p_business_group_id IN NUMBER
364 );
365
366 PROCEDURE Populate_Pos_Assignments
367 ( p_api_version IN NUMBER,
368 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
369 p_commit IN VARCHAR2 := FND_API.G_FALSE,
370 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
371 p_return_status OUT NOCOPY VARCHAR2,
372 p_msg_count OUT NOCOPY NUMBER,
373 p_msg_data OUT NOCOPY VARCHAR2,
374 p_data_extract_id IN NUMBER,
375 -- de by org
376 p_extract_by_org IN VARCHAR2,
377 p_extract_method IN VARCHAR2,
378 p_business_group_id IN NUMBER,
379 p_set_of_books_id IN NUMBER
380 );
381
382 /* Bug 4649730 reverted back the changes done for MPA as
383 the following api will be called only
384 as part of Extract process */
385 PROCEDURE Apply_Defaults
386 ( p_api_version IN NUMBER,
387 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388 p_commit IN VARCHAR2 := FND_API.G_FALSE,
389 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390 p_return_status OUT NOCOPY VARCHAR2,
391 p_msg_count OUT NOCOPY NUMBER,
392 p_msg_data OUT NOCOPY VARCHAR2,
393 p_data_extract_id IN NUMBER,
394 p_extract_method IN VARCHAR2
395 );
396
397
398 FUNCTION get_debug RETURN VARCHAR2;
399
400 END PSB_HR_POPULATE_DATA_PVT;
[Home] [Help]