1 package HR_JP_ID_PKG as
2 /* $Header: hrjpid.pkh 120.0 2005/05/30 20:58:21 appldev noship $ */
3 C_DEFAULT_BUS CONSTANT NUMBER := -1;
4 C_ALL_BUS CONSTANT NUMBER := -2;
5 C_DEFAULT_LEG CONSTANT VARCHAR2(2) := 'X';
6 --------------------------------------------------------------------------------
7 FUNCTION LATEST_SQL RETURN VARCHAR2;
8 --------------------------------------------------------------------------------
9 FUNCTION keyflex_combination_id(
10 p_appl_short_name IN VARCHAR2,
11 p_id_flex_code IN VARCHAR2,
12 p_id_flex_num IN NUMBER,
13 p_concatenated_segments IN VARCHAR2,
14 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
15 --------------------------------------------------------------------------------
16 FUNCTION business_group_rec(
17 p_business_group_id IN NUMBER,
18 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_BUSINESS_GROUPS%ROWTYPE;
19 --------------------------------------------------------------------------------
20 FUNCTION legislation_code(
21 p_business_group_id IN NUMBER,
22 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN VARCHAR2;
23 --------------------------------------------------------------
24 FUNCTION id_flex_num(
25 p_business_group_id IN NUMBER,
26 p_id_flex_code IN VARCHAR2,
27 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
28 --------------------------------------------------------------------------------
29 FUNCTION default_currency_code(
30 p_business_group_id IN NUMBER,
31 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN VARCHAR2;
32 --------------------------------------------------------------------------------
33 FUNCTION default_currency_code(
34 p_legislation_code IN VARCHAR2,
35 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN VARCHAR2;
36 --------------------------------------------------------------------------------
37 -- ID with BUSINESS_GROUP_ID and LEGISLATION_CODE
38 --------------------------------------------------------------------------------
39 FUNCTION element_set_rec(
40 p_element_set_name IN VARCHAR2,
41 p_business_group_id IN NUMBER DEFAULT NULL,
42 p_legislation_code IN VARCHAR2 DEFAULT NULL,
43 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_SETS%ROWTYPE;
44 --------------------------------------------------------------------------------
45 FUNCTION element_set_id(
46 p_element_set_name IN VARCHAR2,
47 p_business_group_id IN NUMBER DEFAULT NULL,
48 p_legislation_code IN VARCHAR2 DEFAULT NULL,
49 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
50 --------------------------------------------------------------------------------
51 FUNCTION backpay_set_rec(
52 p_backpay_set_name IN VARCHAR2,
53 p_business_group_id IN NUMBER DEFAULT NULL,
54 p_legislation_code IN VARCHAR2 DEFAULT NULL,
55 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BACKPAY_SETS%ROWTYPE;
56 --------------------------------------------------------------------------------
57 FUNCTION backpay_set_id(
58 p_backpay_set_name IN VARCHAR2,
59 p_business_group_id IN NUMBER DEFAULT NULL,
60 p_legislation_code IN VARCHAR2 DEFAULT NULL,
61 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
62 --------------------------------------------------------------------------------
63 FUNCTION classification_rec(
64 p_classification_name IN VARCHAR2,
65 p_business_group_id IN NUMBER DEFAULT NULL,
66 p_legislation_code IN VARCHAR2 DEFAULT NULL,
67 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_CLASSIFICATIONS%ROWTYPE;
68 --------------------------------------------------------------------------------
69 FUNCTION classification_id(
70 p_classification_name IN VARCHAR2,
71 p_business_group_id IN NUMBER DEFAULT NULL,
72 p_legislation_code IN VARCHAR2 DEFAULT NULL,
73 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
74 --------------------------------------------------------------------------------
75 FUNCTION element_type_rec(
76 p_element_name IN VARCHAR2,
77 p_business_group_id IN NUMBER DEFAULT NULL,
78 p_legislation_code IN VARCHAR2 DEFAULT NULL,
79 p_effective_date IN DATE DEFAULT hr_api.g_sys,
80 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_TYPES_F%ROWTYPE;
81 --------------------------------------------------------------------------------
82 FUNCTION element_type_id(
83 p_element_name IN VARCHAR2,
84 p_business_group_id IN NUMBER DEFAULT NULL,
85 p_legislation_code IN VARCHAR2 DEFAULT NULL,
86 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
87 --------------------------------------------------------------------------------
88 FUNCTION balance_type_rec(
89 p_balance_name IN VARCHAR2,
90 p_business_group_id IN NUMBER DEFAULT NULL,
91 p_legislation_code IN VARCHAR2 DEFAULT NULL,
92 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_TYPES%ROWTYPE;
93 --------------------------------------------------------------------------------
94 FUNCTION balance_type_id(
95 p_balance_name IN VARCHAR2,
96 p_business_group_id IN NUMBER DEFAULT NULL,
97 p_legislation_code IN VARCHAR2 DEFAULT NULL,
98 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
99 --------------------------------------------------------------------------------
100 FUNCTION balance_dimension_rec(
101 p_dimension_name IN VARCHAR2,
102 p_business_group_id IN NUMBER DEFAULT NULL,
103 p_legislation_code IN VARCHAR2 DEFAULT NULL,
104 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_DIMENSIONS%ROWTYPE;
105 --------------------------------------------------------------------------------
106 FUNCTION balance_dimension_id(
107 p_dimension_name IN VARCHAR2,
108 p_business_group_id IN NUMBER DEFAULT NULL,
109 p_legislation_code IN VARCHAR2 DEFAULT NULL,
110 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
111 --------------------------------------------------------------------------------
112 FUNCTION assignment_status_type_rec(
113 p_user_status IN VARCHAR2,
114 p_business_group_id IN NUMBER DEFAULT NULL,
115 p_legislation_code IN VARCHAR2 DEFAULT NULL,
116 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ASSIGNMENT_STATUS_TYPES%ROWTYPE;
117 --------------------------------------------------------------------------------
118 FUNCTION assignment_status_type_id(
119 p_user_status IN VARCHAR2,
120 p_business_group_id IN NUMBER DEFAULT NULL,
121 p_legislation_code IN VARCHAR2 DEFAULT NULL,
122 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
123 --------------------------------------------------------------------------------
124 FUNCTION user_table_rec(
125 p_user_table_name IN VARCHAR2,
126 p_business_group_id IN NUMBER DEFAULT NULL,
127 p_legislation_code IN VARCHAR2 DEFAULT NULL,
128 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_USER_TABLES%ROWTYPE;
129 --------------------------------------------------------------------------------
130 FUNCTION user_table_id(
131 p_user_table_name IN VARCHAR2,
132 p_business_group_id IN NUMBER DEFAULT NULL,
133 p_legislation_code IN VARCHAR2 DEFAULT NULL,
134 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
135 --------------------------------------------------------------------------------
136 -- ID with BUSINESS_GROUP_ID
137 --------------------------------------------------------------------------------
138 FUNCTION location_rec(
139 p_location_code IN VARCHAR2,
140 p_business_group_id IN NUMBER DEFAULT NULL,
141 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_LOCATIONS_ALL%ROWTYPE;
142 --------------------------------------------------------------------------------
143 FUNCTION location_id(
144 p_location_code IN VARCHAR2,
145 p_business_group_id IN NUMBER DEFAULT NULL,
146 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
147 --------------------------------------------------------------------------------
148 FUNCTION organization_rec(
149 p_name IN VARCHAR2,
150 p_business_group_id IN NUMBER,
151 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_ALL_ORGANIZATION_UNITS%ROWTYPE;
152 --------------------------------------------------------------------------------
153 FUNCTION organization_id(
154 p_name IN VARCHAR2,
155 p_business_group_id IN NUMBER,
156 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
157 --------------------------------------------------------------------------------
158 FUNCTION org_payment_method_rec(
159 p_org_payment_method_name IN VARCHAR2,
160 p_business_group_id IN NUMBER,
161 p_effective_date IN DATE DEFAULT hr_api.g_sys,
162 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAYMENT_METHODS_F%ROWTYPE;
163 --------------------------------------------------------------------------------
164 FUNCTION org_payment_method_id(
165 p_org_payment_method_name IN VARCHAR2,
166 p_business_group_id IN NUMBER,
167 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
168 --------------------------------------------------------------------------------
169 FUNCTION payroll_rec(
170 p_payroll_name IN VARCHAR2,
171 p_business_group_id IN NUMBER,
172 p_effective_date IN DATE DEFAULT hr_api.g_sys,
173 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ALL_PAYROLLS_F%ROWTYPE;
174 --------------------------------------------------------------------------------
175 FUNCTION payroll_id(
176 p_payroll_name IN VARCHAR2,
177 p_business_group_id IN NUMBER,
178 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
179 --------------------------------------------------------------------------------
180 FUNCTION consolidation_set_rec(
181 p_consolidation_set_name IN VARCHAR2,
182 p_business_group_id IN NUMBER,
183 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_CONSOLIDATION_SETS%ROWTYPE;
184 --------------------------------------------------------------------------------
185 FUNCTION consolidation_set_id(
186 p_consolidation_set_name IN VARCHAR2,
187 p_business_group_id IN NUMBER,
188 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
189 --------------------------------------------------------------------------------
190 FUNCTION assignment_set_rec(
191 p_assignment_set_name IN VARCHAR2,
192 p_business_group_id IN NUMBER,
193 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_ASSIGNMENT_SETS%ROWTYPE;
194 --------------------------------------------------------------------------------
195 FUNCTION assignment_set_id(
196 p_assignment_set_name IN VARCHAR2,
197 p_business_group_id IN NUMBER,
198 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
199 --------------------------------------------------------------------------------
200 FUNCTION pay_basis_rec(
201 p_name IN VARCHAR2,
202 p_business_group_id IN NUMBER,
203 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_PAY_BASES%ROWTYPE;
204 --------------------------------------------------------------------------------
205 FUNCTION pay_basis_id(
206 p_name IN VARCHAR2,
207 p_business_group_id IN NUMBER,
208 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
209 --------------------------------------------------------------------------------
210 FUNCTION person_type_rec(
211 p_user_person_type IN VARCHAR2,
212 p_business_group_id IN NUMBER,
213 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_PERSON_TYPES%ROWTYPE;
214 --------------------------------------------------------------------------------
215 FUNCTION person_type_id(
216 p_user_person_type IN VARCHAR2,
217 p_business_group_id IN NUMBER,
218 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
219 --------------------------------------------------------------------------------
220 FUNCTION emp_person_rec(
221 p_employee_number IN VARCHAR2,
222 p_business_group_id IN NUMBER,
223 p_effective_date IN DATE DEFAULT hr_api.g_sys,
224 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE;
225 --------------------------------------------------------------------------------
226 FUNCTION emp_person_id(
227 p_employee_number IN VARCHAR2,
228 p_business_group_id IN NUMBER,
229 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
230 --------------------------------------------------------------------------------
231 FUNCTION apl_person_rec(
232 p_applicant_number IN VARCHAR2,
233 p_business_group_id IN NUMBER,
234 p_effective_date IN DATE DEFAULT hr_api.g_sys,
235 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE;
236 --------------------------------------------------------------------------------
237 FUNCTION apl_person_id(
238 p_applicant_number IN VARCHAR2,
239 p_business_group_id IN NUMBER,
240 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
241 --------------------------------------------------------------------------------
242 FUNCTION emp_assignment_rec(
243 p_assignment_number IN VARCHAR2,
244 p_business_group_id IN NUMBER,
245 p_effective_date IN DATE DEFAULT hr_api.g_sys,
246 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_ASSIGNMENTS_F%ROWTYPE;
247 --------------------------------------------------------------------------------
248 FUNCTION emp_assignment_id(
249 p_assignment_number IN VARCHAR2,
250 p_business_group_id IN NUMBER,
251 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
252 --------------------------------------------------------------------------------
253 FUNCTION rate_id(
254 p_name IN VARCHAR2,
255 p_business_group_id IN NUMBER,
256 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
257 --------------------------------------------------------------------------------
258 FUNCTION job_rec(
259 p_concatenated_segments IN VARCHAR2,
260 p_business_group_id IN NUMBER,
261 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_JOBS%ROWTYPE;
262 --------------------------------------------------------------------------------
263 FUNCTION job_id(
264 p_concatenated_segments IN VARCHAR2,
265 p_business_group_id IN NUMBER,
266 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
267 --------------------------------------------------------------------------------
268 FUNCTION position_rec(
269 p_concatenated_segments IN VARCHAR2,
270 p_business_group_id IN NUMBER,
271 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_POSITIONS%ROWTYPE;
272 --------------------------------------------------------------------------------
273 FUNCTION position_id(
274 p_concatenated_segments IN VARCHAR2,
275 p_business_group_id IN NUMBER,
276 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
277 --------------------------------------------------------------------------------
278 FUNCTION grade_rec(
279 p_concatenated_segments IN VARCHAR2,
280 p_business_group_id IN NUMBER,
281 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_GRADES%ROWTYPE;
282 --------------------------------------------------------------------------------
283 FUNCTION grade_id(
284 p_concatenated_segments IN VARCHAR2,
285 p_business_group_id IN NUMBER,
286 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
287 --------------------------------------------------------------------------------
288 -- ID with special case.
289 --------------------------------------------------------------------------------
290 FUNCTION input_value_rec(
291 p_element_type_id IN NUMBER,
292 p_name IN VARCHAR2,
293 p_effective_date IN DATE DEFAULT hr_api.g_sys,
294 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_INPUT_VALUES_F%ROWTYPE;
295 --------------------------------------------------------------------------------
296 FUNCTION input_value_id(
297 p_element_type_id IN NUMBER,
298 p_name IN VARCHAR2,
299 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
300 --------------------------------------------------------------------------------
301 FUNCTION input_value_rec(
302 p_element_name IN VARCHAR2,
303 p_name IN VARCHAR2,
304 p_business_group_id IN NUMBER DEFAULT NULL,
305 p_legislation_code IN VARCHAR2 DEFAULT NULL,
306 p_effective_date IN DATE DEFAULT hr_api.g_sys,
307 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_INPUT_VALUES_F%ROWTYPE;
308 --------------------------------------------------------------------------------
309 FUNCTION input_value_id(
310 p_element_name IN VARCHAR2,
311 p_name IN VARCHAR2,
312 p_business_group_id IN NUMBER DEFAULT NULL,
313 p_legislation_code IN VARCHAR2 DEFAULT NULL,
314 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
315 --------------------------------------------------------------------------------
316 FUNCTION defined_balance_rec(
317 p_balance_type_id IN NUMBER,
318 p_balance_dimension_id IN NUMBER,
319 p_business_group_id IN NUMBER DEFAULT NULL,
320 p_legislation_code IN VARCHAR2 DEFAULT NULL,
321 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE;
322 --------------------------------------------------------------------------------
323 FUNCTION defined_balance_id(
324 p_balance_type_id IN NUMBER,
325 p_balance_dimension_id IN NUMBER,
326 p_business_group_id IN NUMBER DEFAULT NULL,
327 p_legislation_code IN VARCHAR2 DEFAULT NULL,
328 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
329 --------------------------------------------------------------------------------
330 FUNCTION defined_balance_rec(
331 p_balance_name IN VARCHAR2,
332 p_dimension_name IN VARCHAR2,
333 p_business_group_id IN NUMBER DEFAULT NULL,
334 p_legislation_code IN VARCHAR2 DEFAULT NULL,
335 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE;
336 --------------------------------------------------------------------------------
337 FUNCTION defined_balance_id(
338 p_balance_name IN VARCHAR2,
339 p_dimension_name IN VARCHAR2,
340 p_business_group_id IN NUMBER DEFAULT NULL,
341 p_legislation_code IN VARCHAR2 DEFAULT NULL,
342 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
343 --------------------------------------------------------------------------------
344 FUNCTION balance_feed_rec(
345 p_balance_type_id IN NUMBER,
346 p_input_value_id IN NUMBER,
347 p_business_group_id IN NUMBER DEFAULT NULL,
348 p_legislation_code IN VARCHAR2 DEFAULT NULL,
349 p_effective_date IN DATE DEFAULT hr_api.g_sys,
350 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE;
351 --------------------------------------------------------------------------------
352 FUNCTION balance_feed_id(
353 p_balance_type_id IN NUMBER,
354 p_input_value_id IN NUMBER,
355 p_business_group_id IN NUMBER DEFAULT NULL,
356 p_legislation_code IN VARCHAR2 DEFAULT NULL,
357 p_effective_date IN DATE DEFAULT hr_api.g_sys,
358 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
359 --------------------------------------------------------------------------------
360 FUNCTION balance_feed_rec(
361 p_balance_name IN VARCHAR2,
362 p_element_name IN VARCHAR2,
363 p_name IN VARCHAR2,
364 p_business_group_id IN NUMBER DEFAULT NULL,
365 p_legislation_code IN VARCHAR2 DEFAULT NULL,
366 p_effective_date IN DATE DEFAULT hr_api.g_sys,
367 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE;
368 --------------------------------------------------------------------------------
369 FUNCTION balance_feed_id(
370 p_balance_name IN VARCHAR2,
371 p_element_name IN VARCHAR2,
372 p_name IN VARCHAR2,
373 p_business_group_id IN NUMBER DEFAULT NULL,
374 p_legislation_code IN VARCHAR2 DEFAULT NULL,
375 p_effective_date IN DATE DEFAULT hr_api.g_sys,
376 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
377 --------------------------------------------------------------------------------
378 FUNCTION business_group_rec(
379 p_name IN VARCHAR2,
380 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_BUSINESS_GROUPS%ROWTYPE;
381 --------------------------------------------------------------------------------
382 FUNCTION business_group_id(
383 p_name IN VARCHAR2,
384 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
385 --------------------------------------------------------------------------------
386 FUNCTION formula_type_rec(
387 p_formula_type_name IN VARCHAR2,
388 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FF_FORMULA_TYPES%ROWTYPE;
389 --------------------------------------------------------------------------------
390 FUNCTION formula_type_id(
391 p_formula_type_name IN VARCHAR2,
392 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
393 --------------------------------------------------------------------------------
394 FUNCTION formula_rec(
395 p_formula_name IN VARCHAR2,
396 p_formula_type_name IN VARCHAR2,
397 p_business_group_id IN NUMBER DEFAULT NULL,
398 p_legislation_code IN VARCHAR2 DEFAULT NULL,
399 p_effective_date IN DATE DEFAULT hr_api.g_sys,
400 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FF_FORMULAS_F%ROWTYPE;
401 --------------------------------------------------------------------------------
402 FUNCTION formula_id(
403 p_formula_name IN VARCHAR2,
404 p_formula_type_name IN VARCHAR2,
405 p_business_group_id IN NUMBER DEFAULT NULL,
406 p_legislation_code IN VARCHAR2 DEFAULT NULL,
407 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
408 --------------------------------------------------------------------------------
409 FUNCTION function_rec(
410 p_name IN VARCHAR2,
411 p_data_type IN VARCHAR2,
412 p_business_group_id IN NUMBER DEFAULT NULL,
413 p_legislation_code IN VARCHAR2 DEFAULT NULL,
414 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FF_FUNCTIONS%ROWTYPE;
415 --------------------------------------------------------------------------------
416 FUNCTION function_id(
417 p_name IN VARCHAR2,
418 p_data_type IN VARCHAR2,
419 p_business_group_id IN NUMBER DEFAULT NULL,
420 p_legislation_code IN VARCHAR2 DEFAULT NULL,
421 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
422 --------------------------------------------------------------------------------
423 FUNCTION status_processing_rule_rec(
424 p_element_type_id IN NUMBER,
425 p_assignment_status_type_id IN NUMBER DEFAULT NULL,
426 p_business_group_id IN NUMBER DEFAULT NULL,
427 p_legislation_code IN VARCHAR2 DEFAULT NULL,
428 p_effective_date IN DATE DEFAULT hr_api.g_sys,
429 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_STATUS_PROCESSING_RULES_F%ROWTYPE;
430 --------------------------------------------------------------------------------
431 FUNCTION status_processing_rule_id(
432 p_element_type_id IN NUMBER,
433 p_assignment_status_type_id IN NUMBER DEFAULT NULL,
434 p_business_group_id IN NUMBER DEFAULT NULL,
435 p_legislation_code IN VARCHAR2 DEFAULT NULL,
436 p_effective_date IN DATE DEFAULT hr_api.g_sys,
437 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
438 --------------------------------------------------------------------------------
439 FUNCTION formula_result_rule_rec(
440 p_status_processing_rule_id IN NUMBER,
441 p_result_name IN VARCHAR2,
442 p_result_rule_type IN VARCHAR2,
443 p_element_type_id IN NUMBER DEFAULT NULL,
444 p_input_value_id IN NUMBER DEFAULT NULL,
445 p_business_group_id IN NUMBER DEFAULT NULL,
446 p_legislation_code IN VARCHAR2 DEFAULT NULL,
447 p_effective_date IN DATE DEFAULT hr_api.g_sys,
448 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_FORMULA_RESULT_RULES_F%ROWTYPE;
449 --------------------------------------------------------------------------------
450 FUNCTION formula_result_rule_id(
451 p_status_processing_rule_id IN NUMBER,
452 p_result_name IN VARCHAR2,
453 p_result_rule_type IN VARCHAR2,
454 p_element_type_id IN NUMBER DEFAULT NULL,
455 p_input_value_id IN NUMBER DEFAULT NULL,
456 p_business_group_id IN NUMBER DEFAULT NULL,
457 p_legislation_code IN VARCHAR2 DEFAULT NULL,
458 p_effective_date IN DATE DEFAULT hr_api.g_sys,
459 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
460 --------------------------------------------------------------------------------
461 FUNCTION sub_classification_rule_rec(
462 p_element_type_id IN NUMBER,
463 p_classification_id IN NUMBER,
464 p_business_group_id IN NUMBER,
465 p_legislation_code IN VARCHAR2,
466 p_effective_date IN DATE DEFAULT hr_api.g_sys,
467 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_SUB_CLASSIFICATION_RULES_F%ROWTYPE;
468 --------------------------------------------------------------------------------
469 FUNCTION sub_classification_rule_id(
470 p_element_type_id IN NUMBER,
471 p_classification_id IN NUMBER,
472 p_business_group_id IN NUMBER,
473 p_legislation_code IN VARCHAR2,
474 p_effective_date IN DATE DEFAULT hr_api.g_sys,
475 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
476 --------------------------------------------------------------------------------
477 FUNCTION element_link_id(
478 p_assignment_id IN NUMBER,
479 p_element_type_id IN NUMBER,
480 p_effective_date IN DATE DEFAULT hr_api.g_sys,
481 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
482 --------------------------------------------------------------------------------
483 FUNCTION element_link_id(
484 p_assignment_number IN VARCHAR2,
485 p_element_name IN VARCHAR2,
486 p_business_group_id IN NUMBER,
487 p_effective_date IN DATE DEFAULT hr_api.g_sys,
488 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
489 --------------------------------------------------------------------------------
490 FUNCTION org_information_rec(
491 p_organization_id IN NUMBER,
492 p_org_information_context IN VARCHAR2,
493 p_org_information1 IN VARCHAR2 DEFAULT NULL,
494 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_ORGANIZATION_INFORMATION%ROWTYPE;
495 --------------------------------------------------------------------------------
496 FUNCTION org_information_id(
497 p_organization_id IN NUMBER,
498 p_org_information_context IN VARCHAR2,
499 p_org_information1 IN VARCHAR2 DEFAULT NULL,
500 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
501 --------------------------------------------------------------------------------
502 FUNCTION org_information_rec(
503 p_name IN VARCHAR2,
504 p_org_information_context IN VARCHAR2,
505 p_org_information1 IN VARCHAR2 DEFAULT NULL,
506 p_business_group_id IN VARCHAR2,
507 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_ORGANIZATION_INFORMATION%ROWTYPE;
508 --------------------------------------------------------------------------------
509 FUNCTION org_information_id(
510 p_name IN VARCHAR2,
511 p_org_information_context IN VARCHAR2,
512 p_org_information1 IN VARCHAR2 DEFAULT NULL,
513 p_business_group_id IN VARCHAR2,
514 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
515 --------------------------------------------------------------------------------
516 FUNCTION payment_defined_balance_rec(
517 p_business_group_id IN NUMBER,
518 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_DEFINED_BALANCES%ROWTYPE;
519 --------------------------------------------------------------------------------
520 FUNCTION payment_defined_balance_id(
521 p_business_group_id IN NUMBER,
522 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
523 --------------------------------------------------------------------------------
524 FUNCTION legislation_rule_mode(
525 p_legislation_code IN VARCHAR2,
526 p_rule_type IN VARCHAR2,
527 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN VARCHAR2;
528 --------------------------------------------------------------------------------
529 FUNCTION payment_type_rec(
530 p_payment_type_name IN VARCHAR2,
531 p_territory_code IN VARCHAR2 DEFAULT NULL,
532 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_PAYMENT_TYPES%ROWTYPE;
533 --------------------------------------------------------------------------------
534 FUNCTION payment_type_id(
535 p_payment_type_name IN VARCHAR2,
536 p_territory_code IN VARCHAR2 DEFAULT NULL,
537 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN VARCHAR2;
538 --------------------------------------------------------------------------------
539 FUNCTION grade_rule_rec(
540 p_rate_id IN NUMBER,
541 p_grade_id IN NUMBER,
542 -- p_rate_type IN VARCHAR2,
543 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_GRADE_RULES_F%ROWTYPE;
544 --------------------------------------------------------------------------------
545 FUNCTION grade_rule_id(
546 p_rate_id IN NUMBER,
547 p_grade_id IN NUMBER,
548 -- p_rate_type IN VARCHAR2,
549 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
550 --------------------------------------------------------------------------------
551 FUNCTION flex_value_set_rec(
552 p_flex_value_set_name IN VARCHAR2,
553 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FND_FLEX_VALUE_SETS%ROWTYPE;
554 --------------------------------------------------------------------------------
555 FUNCTION flex_value_set_id(
556 p_flex_value_set_name IN VARCHAR2,
557 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
558 --------------------------------------------------------------------------------
559 FUNCTION flex_value_rec(
560 p_flex_value_set_id IN NUMBER,
561 p_flex_value IN VARCHAR2,
562 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FND_FLEX_VALUES%ROWTYPE;
563 --------------------------------------------------------------------------------
564 FUNCTION flex_value_id(
565 p_flex_value_set_id IN NUMBER,
566 p_flex_value IN VARCHAR2,
567 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
568 --------------------------------------------------------------------------------
569 FUNCTION period_of_service_rec(
570 p_employee_number IN VARCHAR2,
571 p_business_group_id IN NUMBER,
572 p_effective_date IN DATE DEFAULT hr_api.g_sys,
573 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_PERIODS_OF_SERVICE%ROWTYPE;
574 --------------------------------------------------------------------------------
575 FUNCTION element_entry_rec(
576 p_assignment_id IN VARCHAR2,
577 p_element_type_id IN VARCHAR2,
578 p_entry_type IN VARCHAR2 DEFAULT 'E',
579 p_effective_date IN DATE DEFAULT hr_api.g_sys,
580 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE;
581 --------------------------------------------------------------------------------
582 FUNCTION element_entry_rec(
583 p_assignment_number IN VARCHAR2,
584 p_element_name IN VARCHAR2,
585 p_entry_type IN VARCHAR2 DEFAULT 'E',
586 p_business_group_id IN NUMBER,
587 p_effective_date IN DATE DEFAULT hr_api.g_sys,
588 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE;
589 --------------------------------------------------------------------------------
590 FUNCTION primary_address_rec(
591 -- This function is valid when address_type is not NULL.
592 p_person_id IN NUMBER,
593 p_effective_date IN DATE DEFAULT hr_api.g_sys,
594 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
595 --------------------------------------------------------------------------------
596 FUNCTION address_rec(
597 -- This function is valid when address_type is not NULL.
598 p_person_id IN NUMBER,
599 p_address_type IN VARCHAR2,
600 p_effective_date IN DATE DEFAULT hr_api.g_sys,
601 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
602 --------------------------------------------------------------------------------
603 FUNCTION emp_primary_address_rec(
604 -- This function is valid when address_type is not NULL.
605 p_employee_number IN VARCHAR2,
606 p_business_group_id IN NUMBER,
607 p_effective_date IN DATE DEFAULT hr_api.g_sys,
608 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
609 --------------------------------------------------------------------------------
610 FUNCTION emp_address_rec(
611 -- This function is valid when address_type is not NULL.
612 p_employee_number IN VARCHAR2,
613 p_address_type IN VARCHAR2,
614 p_business_group_id IN NUMBER,
615 p_effective_date IN DATE DEFAULT hr_api.g_sys,
616 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
617 --------------------------------------------------------------------------------
618 FUNCTION apl_primary_address_rec(
619 -- This function is valid when address_type is not NULL.
620 p_applicant_number IN VARCHAR2,
621 p_business_group_id IN NUMBER,
622 p_effective_date IN DATE DEFAULT hr_api.g_sys,
623 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
624 --------------------------------------------------------------------------------
625 FUNCTION apl_address_rec(
626 -- This function is valid when address_type is not NULL.
627 p_applicant_number IN VARCHAR2,
628 p_address_type IN VARCHAR2,
629 p_business_group_id IN NUMBER,
630 p_effective_date IN DATE DEFAULT hr_api.g_sys,
631 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE;
632 --------------------------------------------------------------------------------
633 FUNCTION personal_payment_method_rec(
634 p_assignment_id IN NUMBER,
635 p_priority IN NUMBER,
636 p_effective_date IN DATE DEFAULT hr_api.g_sys,
637 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_PERSONAL_PAYMENT_METHODS_F%ROWTYPE;
638 --------------------------------------------------------------------------------
639 FUNCTION personal_payment_method_rec(
640 p_assignment_number IN VARCHAR2,
641 p_priority IN NUMBER,
642 p_business_group_id IN NUMBER,
643 p_effective_date IN DATE DEFAULT hr_api.g_sys,
644 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_PERSONAL_PAYMENT_METHODS_F%ROWTYPE;
645 --------------------------------------------------------------------------------
646 FUNCTION JP_BANK_REC(
647 P_BANK_CODE IN VARCHAR2,
648 P_BRANCH_CODE IN VARCHAR2,
649 p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_JP_BANK_LOOKUPS%ROWTYPE;
650 --------------------------------------------------------------------------------
651 FUNCTION element_link_rec(
652 P_ELEMENT_TYPE_ID IN NUMBER,
653 P_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
654 P_PEOPLE_GROUP_ID IN NUMBER DEFAULT NULL,
655 P_JOB_ID IN NUMBER DEFAULT NULL,
656 P_POSITION_ID IN NUMBER DEFAULT NULL,
657 P_GRADE_ID IN NUMBER DEFAULT NULL,
658 P_LOCATION_ID IN NUMBER DEFAULT NULL,
659 P_EMPLOYMENT_CATEGORY IN VARCHAR2 DEFAULT NULL,
660 P_PAYROLL_ID IN NUMBER DEFAULT NULL,
661 P_LINK_TO_ALL_PAYROLLS_FLAG IN VARCHAR2 DEFAULT 'N',
662 P_PAY_BASIS_ID IN NUMBER DEFAULT NULL,
663 P_BUSINESS_GROUP_ID IN NUMBER,
664 P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
665 P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_LINKS_F%ROWTYPE;
666 --------------------------------------------------------------------------------
667 FUNCTION element_link_id(
668 P_ELEMENT_TYPE_ID IN NUMBER,
669 P_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
670 P_PEOPLE_GROUP_ID IN NUMBER DEFAULT NULL,
671 P_JOB_ID IN NUMBER DEFAULT NULL,
672 P_POSITION_ID IN NUMBER DEFAULT NULL,
673 P_GRADE_ID IN NUMBER DEFAULT NULL,
674 P_LOCATION_ID IN NUMBER DEFAULT NULL,
675 P_EMPLOYMENT_CATEGORY IN VARCHAR2 DEFAULT NULL,
676 P_PAYROLL_ID IN NUMBER DEFAULT NULL,
677 P_LINK_TO_ALL_PAYROLLS_FLAG IN VARCHAR2 DEFAULT 'N',
678 P_PAY_BASIS_ID IN NUMBER DEFAULT NULL,
679 P_BUSINESS_GROUP_ID IN NUMBER,
680 P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
681 P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER;
682 --------------------------------------------------------------------------------
683 FUNCTION backpay_rule_rec(
684 P_BACKPAY_SET_ID IN NUMBER,
685 P_DEFINED_BALANCE_ID IN NUMBER,
686 P_INPUT_VALUE_ID IN NUMBER,
687 P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BACKPAY_RULES%ROWTYPE;
688 --------------------------------------------------------------------------------
689 FUNCTION org_pay_method_usage_rec(
690 P_PAYROLL_ID IN NUMBER,
691 P_ORG_PAYMENT_METHOD_ID IN NUMBER,
692 P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
693 P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAY_METHOD_USAGES_F%ROWTYPE;
694 --------------------------------------------------------------------------------
695 end;