1 package hr_pump_get as
2 /* $Header: hrdpget.pkh 120.1 2005/07/08 20:09:29 ssattini noship $ */
3 /*
4 Notes:
5 The functions declared in this header are designed to be used by
6 the Data Pump engine to resolve id values that have to be passed
7 to the API modules. However, most of these functions could also
8 be used by any program that might want to do something similar.
9
10 The exceptions to are likely to be the functions where a user
11 key value is one of the parameters.
12 */
13
14 /*
15 * The following functions have been defined in this
16 * header file.
17
18 p_person_id
19 p_assignment_id
20 p_address_id
21 p_supervisor_id
22 p_recruiter_id
23 p_person_referred_by_id
24 p_timecard_approver (i.e. a person_id)
25 p_contact_relationship_id
26 p_person_type_id
27 p_vendor_id
28 p_assignment_status_type_id
29 p_organization_id
30 p_source_organization_id
31 p_grade_id
32 p_position_id
33 p_successor_position_id
34 p_relief_position_id
35 p_job_id
36 p_payroll_id
37 p_location_id
38 p_pay_basis_id
39 p_recruitment_activity_id
40 p_vacancy_id
41 p_org_payment_method_id
42 p_payee_id (organization)
43 p_payee_id (person)
44 p_personal_payment_method_id
45 p_set_of_books_id
46 p_tax_unit -- this is p_scl_segment1 for US leg.
47 p_work_schedule
48 p_eeo_1_establishment (this is an id)
49 p_correspondence_language
50 p_contact_person_id
51 p_element_entry_id
52 p_original_entry_id
53 p_element_link_id
54 p_cost_allocation_keyflex_id
55 p_assignment_action_id
56 p_updating_action_id
57 p_comment_id
58 p_target_entry_id
59 p_input_value_id
60 p_input_value_id1 .. p_input_value_id_15
61 p_rate_id
62 p_payee_id (person or organisation)
63 p_program_application_id
64 p_program_id
65 p_request_id
66 p_id_flex_num
67 p_creator_id
68 p_grade_rule_id (using progression point, or grade)
69 p_period_of_service_id
70 p_spinal_point_id (progression point)
71 p_contract_id
72 p_collective_agreement_id
73 p_cagr_id_flex_num
74 p_establishment_id
75 p_country
76 p_benefit_group_id
77 p_start_life_reason_id
78 p_end_life_reason_id
79 *
80 * The following functions have yet to be defined or the
81 * definition is incomplete in this header file.
82 * This may of course prevent the Meta Mapper being
83 * successfully run against certain API modules until
84 * this work is complete.
85 *
86 * Some of the following are likely to prove difficult
87 * to implement.
88
89 p_special_ceiling_step_id
90 p_default_code_comb_id
91 p_soft_coding_keyflex_id
92 p_people_group_id
93 */
94
95 ----------------------- get_collective_agreement_id ------------------------
96 /*
97 NAME
98 get_collective_agreement_id
99 DESCRIPTION
100 Returns a Collective Agreement ID.
101 NOTES
102 This function returns a collective_agreement_id and is designed for use
103 with the Data Pump.
104 */
105 function get_collective_agreement_id
106 (p_business_group_id in number
107 ,p_cagr_name in varchar2
108 ,p_effective_date in date
109 ) return number;
110 pragma restrict_references (get_collective_agreement_id, WNDS);
111
112 -------------------------------- get_contract_id ---------------------------
113 /*
114 NAME
115 get_contract_id
116 DESCRIPTION
117 Returns a Contract ID.
118 NOTES
119 This function returns a contract_id and is designed for use
120 with the Data Pump.
121 */
122 function get_contract_id
123 (p_contract_user_key in varchar2
124 ) return number;
125 pragma restrict_references (get_contract_id, WNDS);
126
127 ------------------------------ get_establishment_id ---------------------------
128 /*
129 NAME
130 get_establishment_id
131 DESCRIPTION
132 Returns an Establishment ID.
133 NOTES
134 This function returns an establishment_id and is designed for use
135 with the Data Pump.
136 */
137 function get_establishment_id
138 (p_establishment_name in varchar2
139 ,p_location in varchar2
140 ) return number;
141 pragma restrict_references (get_establishment_id, WNDS);
142
143 --------------------------- get_cagr_id_flex_num ------------------------------
144 /*
145 NAME
146 get_cagr_id_flex_num
147 DESCRIPTION
148 Returns a cagr_id_flex_num.
149 NOTES
150 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
151 */
152 function get_cagr_id_flex_num
153 (p_cagr_id_flex_num_user_key varchar2
154 ) return number;
155 pragma restrict_references (get_cagr_id_flex_num, WNDS);
156
157 ------------------------- get_emp_fed_tax_rule_id -------------------------
158 /*
159 NAME
160 get_emp_fed_tax_rule_id
161 DESCRIPTION
162 Returns a federal tax rule ID.
163 NOTES
164 This function returns a emp_fed_tax_rule_id and is designed for use
165 with the Data Pump.
166 */
167 function get_emp_fed_tax_rule_id
168 (
169 p_emp_fed_tax_rule_user_key in varchar2
170 ) return number;
171 pragma restrict_references (get_emp_fed_tax_rule_id, WNDS);
172
173 ------------------------- get_emp_state_tax_rule_id -------------------------
174 /*
175 NAME
176 get_emp_state_tax_rule_id
177 DESCRIPTION
178 Returns a state tax rule ID.
179 NOTES
180 This function returns a emp_state_tax_rule_id and is designed for use
181 with the Data Pump.
182 */
183 function get_emp_state_tax_rule_id
184 (
185 p_emp_state_tax_rule_user_key in varchar2
186 ) return number;
187 pragma restrict_references (get_emp_state_tax_rule_id, WNDS);
188
189 ------------------------- get_emp_county_tax_rule_id -------------------------
190 /*
191 NAME
192 get_emp_county_tax_rule_id
193 DESCRIPTION
194 Returns a county tax rule ID.
195 NOTES
196 This function returns a emp_county_tax_rule_id and is designed for use
197 with the Data Pump.
198 */
199 function get_emp_county_tax_rule_id
200 (
201 p_emp_county_tax_rule_user_key in varchar2
202 ) return number;
203 pragma restrict_references (get_emp_county_tax_rule_id, WNDS);
204
205 ------------------------- get_emp_city_tax_rule_id -------------------------
206 /*
207 NAME
208 get_emp_city_tax_rule_id
209 DESCRIPTION
210 Returns a city tax rule ID.
211 NOTES
212 This function returns a emp_city_tax_rule_id and is designed for use
213 with the Data Pump.
214 */
215 function get_emp_city_tax_rule_id
216 (
217 p_emp_city_tax_rule_user_key in varchar2
218 ) return number;
219 pragma restrict_references (get_emp_city_tax_rule_id, WNDS);
220
221 ---------------------------- get_start_life_reason_id -------------------------
222 /*
223 NAME
224 get_ get_start_life_reason_id
225 DESCRIPTION
226 Returns a Start Life Reason ID.
227 NOTES
228 This function returns a start_life_reason_id and is designed for use
229 with the Data Pump.
230 */
231 function get_start_life_reason_id
232 (p_business_group_id in number
233 ,p_effective_date in date
234 ,p_start_life_reason in varchar2
235 ) return number;
236 pragma restrict_references (get_start_life_reason_id, WNDS);
237
238 ----------------------------- get_end_life_reason_id --------------------------
239 /*
240 NAME
241 get_end_life_reason_id
242 DESCRIPTION
243 Returns an End Life Reason ID.
244 NOTES
245 This function returns a end_life_reason_id and is designed for use
246 with the Data Pump.
247 */
248 function get_end_life_reason_id
249 (p_business_group_id in number
250 ,p_effective_date in date
251 ,p_end_life_reason in varchar2
252 ) return number;
253 pragma restrict_references (get_end_life_reason_id, WNDS);
254
255 ------------------------------ get_benefit_group_id ---------------------------
256 /*
257 NAME
258 get_benefit_group_id
259 DESCRIPTION
260 Returns a Benefit Group ID.
261 NOTES
262 This function returns a benefit_group_id and is designed for use
263 with the Data Pump.
264 */
265 function get_benefit_group_id
266 (p_business_group_id in number
267 ,p_benefit_group in varchar2
268 ) return number;
269 pragma restrict_references (get_benefit_group_id, WNDS);
270
271 /***** start OAB additions *****/
272
273 /* start USER_KEY additions */
274
275 /*
276 NAME
277 get_ptnl_ler_for_per_id
278 DESCRIPTION
279 Returns a ptnl_ler_for_per id from supplied user_key
280 NOTES
281 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
282 */
283 function get_ptnl_ler_for_per_id
284 ( p_ptnl_ler_for_per_user_key in varchar2
285 ) return number;
286 pragma restrict_references (get_ptnl_ler_for_per_id, WNDS);
287
288 -- this appears to be a self ref FK on ben_ptnl_ler_for_per
289 /* returns a csd_by_ptnl_ler_for_per_id from supplied user_key */
290 function get_csd_by_ptnl_ler_for_per_id
291 ( p_csd_by_ppl_user_key in varchar2 -- note abbreviation
292 ) return number;
293 pragma restrict_references (get_csd_by_ptnl_ler_for_per_id, WNDS);
294
295 /* returns a ptnl_ler_for_per object_version_number */
296 function get_ptnl_ler_for_per_ovn
297 ( p_ptnl_ler_for_per_user_key in varchar2
298 ) return number;
299 pragma restrict_references (get_ptnl_ler_for_per_ovn, WNDS);
300
301 /* returns a per_in_ler_id from supplied user_key */
302 function get_per_in_ler_id
303 ( p_per_in_ler_user_key in varchar2
304 ) return number;
305 pragma restrict_references (get_per_in_ler_id, WNDS);
306
307 /* returns a trgr_table_pk_id from supplied user_key */
308 function get_trgr_table_pk_id
309 ( p_trgr_table_pk_user_key in varchar2
310 ) return number;
311 pragma restrict_references (get_trgr_table_pk_id, WNDS);
312 --
313 /* returns a ws_mgr_id from supplied user_key */
314 function get_ws_mgr_id
315 ( p_ws_mgr_user_key in varchar2
316 ) return number ;
317 pragma restrict_references (get_ws_mgr_id, WNDS);
318 --
319 /* returns a group_pl_id from supplied user_key */
320 function get_group_pl_id
321 ( p_group_pl_user_key in varchar2
322 ) return number ;
323 pragma restrict_references (get_group_pl_id, WNDS);
324 --
325 /* returns a mgr_ovrid_person_id from supplied user_key */
326 function get_mgr_ovrid_person_id
327 ( p_mgr_ovrid_person_user_key in varchar2
328 ) return number ;
329 pragma restrict_references (get_mgr_ovrid_person_id, WNDS);
330 --
331 /* returns a bckt_per_in_ler_id from supplied user_key */
332 function get_bckt_per_in_ler_id
333 ( p_bckt_per_in_ler_user_key in varchar2
334 ) return number;
335 pragma restrict_references (get_bckt_per_in_ler_id, WNDS);
336
337 /* returns an ended_per_in_ler_id from supplied user_key */
338 function get_ended_per_in_ler_id
339 ( p_ended_per_in_ler_user_key in varchar2
340 ) return number;
341 pragma restrict_references (get_ended_per_in_ler_id, WNDS);
342
343 /* returns a per_in_ler object_version_number */
344 function get_per_in_ler_ovn
345 ( p_per_in_ler_user_key in varchar2
346 ) return number;
347 pragma restrict_references (get_per_in_ler_ovn, WNDS);
348
349 /* returns a prtt_enrt_rslt_id from supplied user_key */
350 function get_prtt_enrt_rslt_id
351 ( p_prtt_enrt_rslt_user_key in varchar2
352 ) return number;
353 pragma restrict_references (get_prtt_enrt_rslt_id, WNDS);
354
355 /* returns a rplcs_sspndd_rslt_id from supplied user_key */
356 function get_rplcs_sspndd_rslt_id
357 ( p_rplcs_sspndd_rslt_user_key in varchar2
358 ) return number;
359 pragma restrict_references (get_rplcs_sspndd_rslt_id, WNDS);
360
361 /* returns a prtt_enrt_rslt object_version_number */
365 ) return number;
362 function get_prtt_enrt_rslt_ovn
363 ( p_prtt_enrt_rslt_user_key in varchar2,
364 p_effective_date in date
366 pragma restrict_references (get_prtt_enrt_rslt_ovn, WNDS);
367
368 /* returns a prtt_rt_val_id from supplied user_key */
369 function get_prtt_rt_val_id
370 ( p_prtt_rt_val_user_key in varchar2
371 ) return number;
372 pragma restrict_references (get_prtt_rt_val_id, WNDS);
373
374 /* returns a prtt_rt_val object_version_number */
375 function get_prtt_rt_val_ovn
376 ( p_prtt_rt_val_user_key in varchar2
377 ) return number;
378 pragma restrict_references (get_prtt_rt_val_ovn, WNDS);
379
380 /* returns a cbr_quald_bnf_id from supplied user_key */
381 function get_cbr_quald_bnf_id
382 ( p_cbr_quald_bnf_user_key in varchar2
383 ) return number;
384 pragma restrict_references (get_cbr_quald_bnf_id, WNDS);
385
386 /* returns a cbr_quald_bnf object_version_number */
387 function get_cbr_quald_bnf_ovn
388 ( p_cbr_quald_bnf_user_key in varchar2
389 ) return number;
390 pragma restrict_references (get_cbr_quald_bnf_ovn, WNDS);
391
392 /* returns a cbr_per_in_ler_id from supplied user_key */
393 function get_cbr_per_in_ler_id
394 ( p_cbr_per_in_ler_user_key in varchar2
395 ) return number;
396 pragma restrict_references (get_cbr_per_in_ler_id, WNDS);
397
398 /* returns a cbr_per_in_ler object_version_number */
399 function get_cbr_per_in_ler_ovn
400 ( p_cbr_per_in_ler_user_key in varchar2
401 ) return number;
402 pragma restrict_references (get_cbr_per_in_ler_ovn, WNDS);
403
404 /* returns an elig_cvrd_dpnt_id from supplied user_key */
405 function get_elig_cvrd_dpnt_id
406 ( p_elig_cvrd_dpnt_user_key in varchar2
407 ) return number;
408 pragma restrict_references (get_elig_cvrd_dpnt_id, WNDS);
409
410 /* returns an elig_cvrd_dpnt object_version_number */
411 function get_elig_cvrd_dpnt_ovn
412 ( p_elig_cvrd_dpnt_user_key in varchar2,
413 p_effective_date in date
414 ) return number;
415 pragma restrict_references (get_elig_cvrd_dpnt_ovn, WNDS);
416
417 /* returns a prtt_prem_id from supplied user_key */
418 function get_prtt_prem_id
419 ( p_prtt_prem_user_key in varchar2
420 ) return number;
421 pragma restrict_references (get_prtt_prem_id, WNDS);
422
423 /* returns a prtt_prem object_version_number */
424 function get_prtt_prem_ovn
425 ( p_prtt_prem_user_key in varchar2,
426 p_effective_date in date
427 ) return number;
428 pragma restrict_references (get_prtt_prem_ovn, WNDS);
429
430 /* returns a elig_dpnt_id from supplied user_key */
431 function get_elig_dpnt_id
432 ( p_elig_dpnt_user_key in varchar2
433 ) return number;
434 pragma restrict_references (get_elig_dpnt_id, WNDS);
435
436 /* returns a elig_dpnt object_version_number */
437 function get_elig_dpnt_ovn
438 ( p_elig_dpnt_user_key in varchar2
439 ) return number;
440 pragma restrict_references (get_elig_dpnt_ovn, WNDS);
441
442 /* returns an elig_per_id from supplied user_key */
443 function get_elig_per_id
444 ( p_elig_per_user_key in varchar2
445 ) return number;
446 pragma restrict_references (get_elig_per_id, WNDS);
447
448 /* returns an elig_per object_version_number */
449 function get_elig_per_ovn
450 ( p_elig_per_user_key in varchar2,
451 p_effective_date in date
452 ) return number;
453 pragma restrict_references (get_elig_per_ovn, WNDS);
454
458 ) return number;
455 /* returns an elig_per_opt_id from supplied user_key */
456 function get_elig_per_opt_id
457 ( p_elig_per_opt_user_key in varchar2
459 pragma restrict_references (get_elig_per_opt_id, WNDS);
460
461 /* returns an elig_per_opt object_version_number */
462 function get_elig_per_opt_ovn
463 ( p_elig_per_opt_user_key in varchar2,
464 p_effective_date in date
465 ) return number;
466 pragma restrict_references (get_elig_per_opt_ovn, WNDS);
467
468 /* returns a pl_bnf_id from supplied user_key */
469 function get_pl_bnf_id
470 ( p_pl_bnf_user_key in varchar2
471 ) return number;
472 pragma restrict_references (get_pl_bnf_id, WNDS);
473
474 /* returns a pl_bnf object_version_number */
475 function get_pl_bnf_ovn
476 ( p_pl_bnf_user_key in varchar2,
477 p_effective_date in date
478 ) return number;
479 pragma restrict_references (get_pl_bnf_ovn, WNDS);
480
481 /* returns an oipl_id from supplied user_key */
482 function get_oipl_id
483 ( p_oipl_user_key in varchar2
484 ) return number;
485 pragma restrict_references (get_oipl_id, WNDS);
486
487 /* returns an oipl object_version_number */
488 function get_oipl_ovn
489 ( p_oipl_user_key in varchar2,
490 p_effective_date in date
491 ) return number;
492 pragma restrict_references (get_oipl_ovn, WNDS);
493
494 /* returns a plip_id from supplied user_key */
495 function get_plip_id
496 ( p_plip_user_key in varchar2
497 ) return number;
498 pragma restrict_references (get_plip_id, WNDS);
499
500 /* returns a plip object_version_number */
501 function get_plip_ovn
502 ( p_plip_user_key in varchar2,
503 p_effective_date in date
504 ) return number;
505 pragma restrict_references (get_plip_ovn, WNDS);
506
507 /* returns a ptip_id from supplied user_key */
508 function get_ptip_id
509 ( p_ptip_user_key in varchar2
510 ) return number;
511 pragma restrict_references (get_ptip_id, WNDS);
512
513 /* returns a ptip object_version_number */
514 function get_ptip_ovn
515 ( p_ptip_user_key in varchar2,
516 p_effective_date in date
517 ) return number;
518 pragma restrict_references (get_ptip_ovn, WNDS);
519
520 /* returns an enrt_rt_id from supplied user_key */
521 function get_enrt_rt_id
522 ( p_enrt_rt_user_key in varchar2
523 ) return number;
524 pragma restrict_references (get_enrt_rt_id, WNDS);
525
526 /* returns an enrt_rt object_version_number */
527 function get_enrt_rt_ovn
528 ( p_enrt_rt_user_key in varchar2
529 ) return number;
530 pragma restrict_references (get_enrt_rt_ovn, WNDS);
531
532 /* returns an enrt_perd_id from supplied user_key */
533 function get_enrt_perd_id
534 ( p_enrt_perd_user_key in varchar2
535 ) return number;
536 pragma restrict_references (get_enrt_perd_id, WNDS);
537
538 /* returns an enrt_perd object_version_number */
539 function get_enrt_perd_ovn
540 ( p_enrt_perd_user_key in varchar2
541 ) return number;
542 pragma restrict_references (get_enrt_perd_ovn, WNDS);
543
544 /* returns a prtt_reimbmt_rqst_id from supplied user_key */
545 function get_prtt_reimbmt_rqst_id
546 ( p_prtt_reimbmt_rqst_user_key in varchar2
547 ) return number;
548 pragma restrict_references (get_prtt_reimbmt_rqst_id, WNDS);
549
550 /* returns a prtt_reimbmt_rqst object_version_number */
551 function get_prtt_reimbmt_rqst_ovn
552 ( p_prtt_reimbmt_rqst_user_key in varchar2,
553 p_effective_date in date
554 ) return number;
555 pragma restrict_references (get_prtt_reimbmt_rqst_ovn, WNDS);
556
557 /* returns an elig_per_elctbl_chc_id from supplied user_key */
558 function get_elig_per_elctbl_chc_id
559 ( p_elig_per_elctbl_chc_user_key in varchar2
560 ) return number;
561 pragma restrict_references (get_elig_per_elctbl_chc_id, WNDS);
562
563 /* returns an elig_per_elctbl_chc object_version_number */
564 function get_elig_per_elctbl_chc_ovn
565 ( p_elig_per_elctbl_chc_user_key in varchar2
566 ) return number;
567 pragma restrict_references (get_elig_per_elctbl_chc_ovn, WNDS);
568
569 --
570 ------------------------------ get_benfts_grp_id ---------------------------
571 /*
572 NAME
573 get_benfts_grp_id
574 DESCRIPTION
575 Returns a benefits group ID.
576 NOTES
577 This function returns a benfts_grp_id and is designed for use with the Data Pump.
578 */
579 function get_benfts_grp_id
580 ( p_business_group_id in number,
581 p_benefits_group in varchar2
582 ) return number;
583 pragma restrict_references (get_benfts_grp_id, WNDS);
584 --
585 /*
586 NAME
587 get_benfts_grp_ovn
588 DESCRIPTION
589 Returns a benefits group object version number.
590 */
591 function get_benfts_grp_ovn
592 ( p_business_group_id in number,
593 p_benefits_group in varchar2
594 ) return number;
595 pragma restrict_references (get_benfts_grp_ovn, WNDS);
596 --
597 ------------------------------ get_pl_typ_id ---------------------------
601 DESCRIPTION
598 /*
599 NAME
600 get_pl_typ_id
602 Returns a Plan Type ID.
603 NOTES
604 This function returns a plan_type_id and is designed for use with the Data Pump.
605 */
606 function get_pl_typ_id
607 ( p_business_group_id in number,
608 p_plan_type in varchar2,
609 p_effective_date in date
610 ) return number;
611 pragma restrict_references (get_pl_typ_id, WNDS);
612 --
613 /*
614 NAME
615 get_pl_typ_ovn
616 DESCRIPTION
617 Returns a plan type object version number.
618 */
619 function get_pl_typ_ovn
620 ( p_business_group_id in number,
621 p_plan_type in varchar2,
622 p_effective_date in date
623 ) return number;
624 pragma restrict_references (get_pl_typ_ovn, WNDS);
625 --
626 ------------------------------ get_ler_id ---------------------------
627 -- Note: WARNING this is overloaded on another get_ler_id that previously existed!
628 /*
629 NAME
630 get_ler_id
631 DESCRIPTION
632 Returns a life event reason ID.
633 NOTES
634 This function returns a ler_id and is designed for use with the Data Pump.
635 */
636 function get_ler_id
637 ( p_business_group_id in number,
638 p_life_event_reason in varchar2,
639 p_effective_date in date
640 ) return number;
641 pragma restrict_references (get_ler_id, WNDS);
642 --
643 /*
644 NAME
645 get_ler_ovn
646 DESCRIPTION
647 Returns a life event reason object version number.
648 */
649 function get_ler_ovn
650 ( p_business_group_id in number,
651 p_life_event_reason in varchar2,
652 p_effective_date in date
653 ) return number;
654 pragma restrict_references (get_ler_ovn, WNDS);
655 --
656 ------------------------------ get_acty_base_rt_id ---------------------------
657 /*
658 NAME
659 get_acty_base_rt_id
660 DESCRIPTION
661 Returns an acty base rate ID.
662 NOTES
663 This function returns an acty_base_rt_id and is designed for use with the Data Pump.
664 */
665 function get_acty_base_rt_id
666 ( p_business_group_id in number,
667 p_acty_base_rate in varchar2,
668 p_effective_date in date
669 ) return number;
670 pragma restrict_references (get_acty_base_rt_id , WNDS);
671 --
672 /*
673 NAME
674 get_acty_base_rt_ovn
675 DESCRIPTION
676 Returns an acty base rate object version number.
677 */
678 function get_acty_base_rt_ovn
679 ( p_business_group_id in number,
680 p_acty_base_rate in varchar2,
681 p_effective_date in date
682 ) return number;
683 pragma restrict_references (get_acty_base_rt_ovn, WNDS);
684 --
685 ------------------------------ get_actl_prem_id ---------------------------
686 /*
687 NAME
688 get_actl_prem_id
689 DESCRIPTION
690 Returns an actual premium ID.
691 NOTES
692 This function returns a actl_prem_id and is designed for use with the Data Pump.
693 */
694 function get_actl_prem_id
695 ( p_business_group_id in number,
696 p_actual_premium in varchar2,
697 p_effective_date in date
698 ) return number;
699 pragma restrict_references (get_actl_prem_id, WNDS);
700 --
701 /*
702 NAME
703 get_actl_prem_ovn
704 DESCRIPTION
705 Returns an actual premium object version number.
706 */
707 function get_actl_prem_ovn
708 ( p_business_group_id in number,
709 p_actual_premium in varchar2,
710 p_effective_date in date
711 ) return number;
712 pragma restrict_references (get_actl_prem_ovn, WNDS);
713 --
714 ------------------------------ get_comp_lvl_fctr_id ---------------------------
715 /*
716 NAME
717 get_comp_lvl_fctr_id
718 DESCRIPTION
719 Returns a comp level factor ID.
720 NOTES
721 This function returns a comp_lvl_fctr_id and is designed for use with the Data Pump.
722 */
723 function get_comp_lvl_fctr_id
724 ( p_business_group_id in number,
725 p_comp_level_factor in varchar2
726 ) return number;
727 pragma restrict_references (get_comp_lvl_fctr_id, WNDS);
728 --
729 /*
730 NAME
731 get_comp_lvl_fctr_ovn
732 DESCRIPTION
733 Returns a comp level factor object version number.
734 */
735 function get_comp_lvl_fctr_ovn
736 ( p_business_group_id in number,
737 p_comp_level_factor in varchar2
738 ) return number;
739 pragma restrict_references (get_comp_lvl_fctr_ovn, WNDS);
740 --
741 ------------------------------ get_cvg_amt_calc_mthd_id ---------------------------
742 /*
743 NAME
744 get_cvg_amt_calc_mthd_id
745 DESCRIPTION
746 Returns a cvg amt calc ID.
747 NOTES
748 This function returns a cvg_amt_calc_mthd_id and is designed for use with the Data Pump.
749 */
750 function get_cvg_amt_calc_mthd_id
751 ( p_business_group_id in number,
752 p_cvg_amt_calc in varchar2,
753 p_effective_date in date
754 ) return number;
755 pragma restrict_references (get_cvg_amt_calc_mthd_id , WNDS);
756 --
757 /*
758 NAME
759 get_cvg_amt_calc_mthd_ovn
760 DESCRIPTION
764 ( p_business_group_id in number,
761 Returns a cvg amt calc object version number.
762 */
763 function get_cvg_amt_calc_mthd_ovn
765 p_cvg_amt_calc in varchar2,
766 p_effective_date in date
767 ) return number;
768 pragma restrict_references (get_cvg_amt_calc_mthd_ovn, WNDS);
769 --
770 ------------------------------ get_opt_id ---------------------------
771 /*
772 NAME
773 get_opt_id
774 DESCRIPTION
775 Returns an option (definition) ID.
776 NOTES
777 This function returns a opt_id and is designed for use with the Data Pump.
778 */
779 function get_opt_id
780 ( p_business_group_id in number,
781 p_option_definition in varchar2,
782 p_effective_date in date
783 ) return number;
784 pragma restrict_references (get_opt_id, WNDS);
785 --
786 /*
787 NAME
788 get_opt_ovn
789 DESCRIPTION
790 Returns a option (definition) object version number.
791 */
792 function get_opt_ovn
793 ( p_business_group_id in number,
794 p_option_definition in varchar2,
795 p_effective_date in date
796 ) return number;
797 pragma restrict_references (get_opt_ovn, WNDS);
798 --
799 ------------------------------ get_pl_id ---------------------------
800 /*
801 NAME
802 get_pl_id
803 DESCRIPTION
804 Returns a Plan ID.
805 NOTES
806 This function returns a pl_id and is designed for use with the Data Pump.
807 */
808 function get_pl_id
809 ( p_business_group_id in number,
810 p_plan in varchar2,
811 p_effective_date in date
812 ) return number;
813 pragma restrict_references (get_pl_id , WNDS);
814 --
815 /*
816 NAME
817 get_pl_ovn
818 DESCRIPTION
819 Returns a plan object version number.
820 */
821 function get_pl_ovn
822 ( p_business_group_id in number,
823 p_plan in varchar2,
824 p_effective_date in date
825 ) return number;
826 pragma restrict_references (get_pl_ovn, WNDS);
827 --
828 ------------------------------ get_pgm_id ---------------------------
829 /*
830 NAME
831 get_pgm_id
832 DESCRIPTION
833 Returns a Program ID.
834 NOTES
835 This function returns a pgm_id and is designed for use with the Data Pump.
836 */
837 function get_pgm_id
838 ( p_business_group_id in number,
839 p_program in varchar2,
840 p_effective_date in date
841 ) return number;
842 pragma restrict_references (get_pgm_id, WNDS);
843 --
844 /*
845 NAME
846 get_pgm_ovn
847 DESCRIPTION
848 Returns a program object version number.
849 */
850 function get_pgm_ovn
851 ( p_business_group_id in number,
852 p_program in varchar2,
853 p_effective_date in date
854 ) return number;
855 pragma restrict_references (get_pgm_ovn, WNDS);
856 --
857 ------------------------------ get_element_type_id ---------------------------
858 /*
859 NAME
860 get_element_type_id
861 DESCRIPTION
862 Returns an element_type_id given element_name
863 */
864 function get_element_type_id
865 ( p_business_group_id in number,
866 --p_legislation_code in varchar2,
867 p_element_name in varchar2,
868 p_effective_date in date
869 ) return number;
870 pragma restrict_references (get_element_type_id, WNDS);
871 --
872 ------------------------------ get_currency_code ---------------------------
873 /*
874 NAME
875 get_currency_code
876 DESCRIPTION
877 Returns a currency code given name or code.
878 */
879 /* returns currency_code from fnd_currencies_vl */
880 function get_currency_code
881 ( p_name_or_code in varchar2,
882 p_effective_date in date
883 ) return varchar2;
884 --pragma restrict_references (get_currency_code, WNDS);
885
886 /* start HR/PER additional get_xyz routines for BEN */
887
888 /* returns a uom code */
889 function get_uom_code
890 ( p_uom in varchar2,
891 p_effective_date in date
892 ) return varchar2;
893 --pragma restrict_references (get_uom_code, WNDS);
894
895 /* returns a std_prem_uom code */
896 function get_std_prem_uom_code
897 ( p_std_prem_uom in varchar2,
898 p_effective_date in date
899 ) return varchar2;
900 --pragma restrict_references (get_std_prem_uom_code, WNDS);
901
902 /* returns a comp_ref_uom code */
903 function get_comp_ref_uom_code
904 ( p_comp_ref_uom in varchar2,
905 p_effective_date in date
906 ) return varchar2;
907 --pragma restrict_references (get_comp_ref_uom_code, WNDS);
908
909 /* returns a rt_comp_ref_uom code */
910 function get_rt_comp_ref_uom_code
911 ( p_rt_comp_ref_uom in varchar2,
912 p_effective_date in date
913 ) return varchar2;
914 --pragma restrict_references (get_rt_comp_ref_uom_code, WNDS);
915
916 /* returns a amt_dsgd_uom code */
917 function get_amt_dsgd_uom_code
918 ( p_amt_dsgd_uom in varchar2,
919 p_effective_date in date
920 ) return varchar2;
921 --pragma restrict_references (get_amt_dsgd_uom_code, WNDS);
925 ( p_quald_bnf_person_user_key in varchar2
922
923 /* get_quald_bnf_person_id - requires user key */
924 function get_quald_bnf_person_id
926 ) return number;
927 pragma restrict_references (get_quald_bnf_person_id, WNDS);
928
929 /* get_cvrd_emp_person_id - requires user key */
930 function get_cvrd_emp_person_id
931 ( p_cvrd_emp_person_user_key in varchar2
932 ) return number;
933 pragma restrict_references (get_cvrd_emp_person_id, WNDS);
934
935 /* get_dpnt_person_id - requires user key */
936 function get_dpnt_person_id
937 ( p_dpnt_person_user_key in varchar2
938 ) return number;
939 pragma restrict_references (get_dpnt_person_id, WNDS);
940
941 /* get_bnf_person_id - requires user key */
942 function get_bnf_person_id
943 ( p_bnf_person_user_key in varchar2
944 ) return number;
945 pragma restrict_references (get_bnf_person_id, WNDS);
946
947 /* get_ttee_person_id - requires user key */
948 function get_ttee_person_id
949 ( p_ttee_person_user_key in varchar2
950 ) return number;
951 pragma restrict_references (get_ttee_person_id, WNDS);
952
953 /**** end OAB additions *******/
954
955 ------------------------------- get_person_id ---------------------------------
956 /*
957 NAME
958 get_person_id
959 DESCRIPTION
960 Returns a Person ID.
961 NOTES
962 This function returns a person_id and is designed for use
963 with the Data Pump.
964 */
965 function get_person_id
966 (
967 p_person_user_key in varchar2
968 ) return number;
969 pragma restrict_references (get_person_id, WNDS);
970
971 --------------------------- get_contact_person_id -----------------------------
972 /*
973 NAME
974 get_contact_person_id
975 DESCRIPTION
976 Returns a Contact Person ID.
977 NOTES
978 This function returns a contact_person_id and is designed for use
979 with the Data Pump.
980 */
981 function get_contact_person_id
982 (
983 p_contact_person_user_key in varchar2
984 ) return number;
985 pragma restrict_references (get_contact_person_id, WNDS);
986
987 ----------------------------- get_assignment_id -------------------------------
988 /*
989 NAME
990 get_assignment_id
991 DESCRIPTION
992 Returns an Assignment ID.
993 NOTES
994 This function is returns an assignment_id and is designed for use
995 with the Data Pump.
996 */
997 function get_assignment_id
998 (
999 p_assignment_user_key in varchar2
1000 ) return number;
1001 pragma restrict_references (get_assignment_id, WNDS);
1002
1003 ------------------------------- get_address_id --------------------------------
1004 /*
1005 NAME
1006 get_address_id
1007 DESCRIPTION
1008 Returns an Address ID.
1009 NOTES
1010 This function returns an address_id and is designed for use
1011 with the Data Pump.
1012 */
1013 function get_address_id
1014 (
1015 p_address_user_key in varchar2
1016 ) return number;
1017 pragma restrict_references (get_address_id, WNDS);
1018
1019 ----------------------------- get_supervisor_id -------------------------------
1020 /*
1021 NAME
1022 get_supervisor_id
1023 DESCRIPTION
1024 Returns a Supervisor ID.
1025 NOTES
1026 This function returns a supervisor_id and is designed for use
1027 with the Data Pump.
1028 */
1029 function get_supervisor_id
1030 (
1031 p_supervisor_user_key in varchar2
1032 ) return number;
1033 pragma restrict_references (get_supervisor_id, WNDS);
1034
1035 ------------------------------ get_recruiter_id -------------------------------
1036 /*
1037 NAME
1038 get_recruiter_id
1039 DESCRIPTION
1040 Returns a Recruiter ID.
1041 NOTES
1042 This function returns a recruiter_id and is designed for use
1043 with the Data Pump.
1044 */
1045 function get_recruiter_id
1046 (
1047 p_recruiter_user_key in varchar2
1048 ) return number;
1049 pragma restrict_references (get_recruiter_id, WNDS);
1050
1051 ------------------------- get_person_referred_by_id ---------------------------
1052 /*
1053 NAME
1054 get_person_referred_by_id
1055 DESCRIPTION
1056 Returns a Person Referred By ID.
1057 NOTES
1058 This function returns a person_referred_by_id and is designed for use
1059 with the Data Pump.
1060 */
1061 function get_person_referred_by_id
1062 (
1063 p_person_referred_by_user_key in varchar2
1064 ) return number;
1065 pragma restrict_references (get_person_referred_by_id, WNDS);
1066
1067 -------------------------- get_timecard_approver_id ---------------------------
1068 /*
1069 NAME
1070 get_timecard_approver_id
1071 DESCRIPTION
1072 Returns a Person ID for a timecard approver.
1073 NOTES
1074 This function returns a person_id, but is used for
1075 the timecard approver parameter.
1076 */
1077 function get_timecard_approver_id
1078 (
1079 p_timecard_approver_user_key in varchar2
1080 ) return number;
1081 pragma restrict_references (get_timecard_approver_id, WNDS);
1082
1086 get_contact_relationship_id
1083 ----------------------- get_contact_relationship_id ---------------------------
1084 /*
1085 NAME
1087 DESCRIPTION
1088 Returns a Contact Relationship ID.
1089 NOTES
1090 This function returns a contact_relationship_id and is designed for use
1091 with the Data Pump.
1092 */
1093 function get_contact_relationship_id
1094 (
1095 p_contact_user_key in varchar2,
1096 p_contactee_user_key in varchar2
1097 ) return number;
1098 pragma restrict_references (get_contact_relationship_id, WNDS);
1099
1100 --------------------------- get_element_entry_id -------------------------------
1101 /*
1102 NAME
1103 get_element_entry_id
1104 get_original_entry_id
1105 get_target_entry_id
1106 DESCRIPTION
1107 Functions returning Element Entry ID.
1108 NOTES
1109 Added for hr_element_entry_api.create_element_entry support.
1110 */
1111 function get_element_entry_id
1112 (
1113 p_element_entry_user_key in varchar2
1114 ) return number;
1115 pragma restrict_references (get_element_entry_id, WNDS);
1116 --------------------------- get_original_entry_id ------------------------------
1117 function get_original_entry_id
1118 (
1119 p_original_entry_user_key in varchar2
1120 ) return number;
1121 pragma restrict_references (get_original_entry_id, WNDS);
1122 --------------------------- get_target_entry_id --------------------------------
1123 function get_target_entry_id
1124 (
1125 p_target_entry_user_key in varchar2
1126 ) return number;
1127 pragma restrict_references (get_target_entry_id, WNDS);
1128
1129 ---------------------------- get_element_link_id -------------------------------
1130 /*
1131 NAME
1132 get_element_link_id
1133 DESCRIPTION
1134 Returns an Element Link ID.
1135 NOTES
1136 Added for hr_element_entry_api.create_element_entry support.
1137 */
1138 function get_element_link_id
1139 (
1140 p_element_link_user_key in varchar2
1141 ) return number;
1142 pragma restrict_references (get_element_link_id, WNDS);
1143
1144 --------------------- get_cost_allocation_keyflex_id ---------------------------
1145 /*
1146 NAME
1147 get_cost_allocation_keyflex_id
1148 DESCRIPTION
1149 Returns a Cost Allocation Keyflex ID.
1150 NOTES
1151 Added for hr_element_entry_api.create_element_entry support.
1152 */
1153 function get_cost_allocation_keyflex_id
1154 (
1155 p_cost_alloc_keyflex_user_key in varchar2
1156 ) return number;
1157 pragma restrict_references (get_cost_allocation_keyflex_id, WNDS);
1158
1159 ------------------------------ get_comment_id ----------------------------------
1160 /*
1161 NAME
1162 get_comment_id
1163 DESCRIPTION
1164 Returns a Comment ID
1165 NOTES
1166 Added for hr_element_entry_api.create_element_entry support.
1167 */
1168 function get_comment_id( p_comment_user_key in varchar2 ) return number;
1169 pragma restrict_references (get_comment_id, WNDS);
1170
1171 ------------------------- get_assignment_action_id -----------------------------
1172 /*
1173 NAME
1174 get_assignment_action_id
1175 get_updating_action_id
1176 DESCRIPTION
1177 Returns a Pay Assignment Action ID.
1178 NOTES
1179 Added for hr_element_entry_api.create_element_entry support.
1180 */
1181 function get_assignment_action_id( p_assignment_action_user_key in varchar2 )
1182 return number;
1183 pragma restrict_references (get_assignment_action_id, WNDS);
1184 --------------------------- get_updating_action_id -----------------------------
1185 function get_updating_action_id( p_updating_action_user_key in varchar2 )
1186 return number;
1187 pragma restrict_references (get_updating_action_id, WNDS);
1188
1189 ----------------------------- get_input_value_id -------------------------------
1190 /*
1191 NAME
1192 get_input_value_id
1193 get_input_value_id1 .. get_input_value_id15
1194 DESCRIPTION
1195 Functions returning Input Value ID.
1196 NOTES
1197 These functions return input value ids and are designed for use with the
1198 Data Pump. Added for hr_element_entry_api.create_element_entry support.
1199 */
1200 function get_input_value_id
1201 (
1202 p_input_value_name in varchar2,
1203 p_element_name in varchar2,
1204 p_business_group_id in number,
1205 p_effective_date in date,
1206 p_language_code in varchar2
1207 ) return number;
1208 pragma restrict_references (get_input_value_id, WNDS);
1209 --
1210 function get_input_value_id1
1211 (
1212 p_input_value_name1 in varchar2,
1213 p_element_name in varchar2,
1214 p_business_group_id in number,
1215 p_effective_date in date,
1216 p_language_code in varchar2
1217 ) return number;
1218 pragma restrict_references (get_input_value_id1, WNDS);
1219 --
1220 function get_input_value_id2
1221 (
1222 p_input_value_name2 in varchar2,
1223 p_element_name in varchar2,
1224 p_business_group_id in number,
1225 p_effective_date in date,
1226 p_language_code in varchar2
1227 ) return number;
1228 pragma restrict_references (get_input_value_id2, WNDS);
1229 --
1233 p_element_name in varchar2,
1230 function get_input_value_id3
1231 (
1232 p_input_value_name3 in varchar2,
1234 p_business_group_id in number,
1235 p_effective_date in date,
1236 p_language_code in varchar2
1237 ) return number;
1238 pragma restrict_references (get_input_value_id3, WNDS);
1239 --
1240 function get_input_value_id4
1241 (
1242 p_input_value_name4 in varchar2,
1243 p_element_name in varchar2,
1244 p_business_group_id in number,
1245 p_effective_date in date,
1246 p_language_code in varchar2
1247 ) return number;
1248 pragma restrict_references (get_input_value_id4, WNDS);
1249 --
1250 function get_input_value_id5
1251 (
1252 p_input_value_name5 in varchar2,
1253 p_element_name in varchar2,
1254 p_business_group_id in number,
1255 p_effective_date in date,
1256 p_language_code in varchar2
1257 ) return number;
1258 pragma restrict_references (get_input_value_id5, WNDS);
1259 --
1260 function get_input_value_id6
1261 (
1262 p_input_value_name6 in varchar2,
1263 p_element_name in varchar2,
1264 p_business_group_id in number,
1265 p_effective_date in date,
1266 p_language_code in varchar2
1267 ) return number;
1268 pragma restrict_references (get_input_value_id6, WNDS);
1269 --
1270 function get_input_value_id7
1271 (
1272 p_input_value_name7 in varchar2,
1273 p_element_name in varchar2,
1274 p_business_group_id in number,
1275 p_effective_date in date,
1276 p_language_code in varchar2
1277 ) return number;
1278 pragma restrict_references (get_input_value_id7, WNDS);
1279 --
1280 function get_input_value_id8
1281 (
1282 p_input_value_name8 in varchar2,
1283 p_element_name in varchar2,
1284 p_business_group_id in number,
1285 p_effective_date in date,
1286 p_language_code in varchar2
1287 ) return number;
1288 pragma restrict_references (get_input_value_id8, WNDS);
1289 --
1290 function get_input_value_id9
1291 (
1292 p_input_value_name9 in varchar2,
1293 p_element_name in varchar2,
1294 p_business_group_id in number,
1295 p_effective_date in date,
1296 p_language_code in varchar2
1297 ) return number;
1298 pragma restrict_references (get_input_value_id9, WNDS);
1299 --
1300 function get_input_value_id10
1301 (
1302 p_input_value_name10 in varchar2,
1303 p_element_name in varchar2,
1304 p_business_group_id in number,
1305 p_effective_date in date,
1306 p_language_code in varchar2
1307 ) return number;
1308 pragma restrict_references (get_input_value_id10, WNDS);
1309 --
1310 function get_input_value_id11
1311 (
1312 p_input_value_name11 in varchar2,
1313 p_element_name in varchar2,
1314 p_business_group_id in number,
1315 p_effective_date in date,
1316 p_language_code in varchar2
1317 ) return number;
1318 pragma restrict_references (get_input_value_id11, WNDS);
1319 --
1320 function get_input_value_id12
1321 (
1322 p_input_value_name12 in varchar2,
1323 p_element_name in varchar2,
1324 p_business_group_id in number,
1325 p_effective_date in date,
1326 p_language_code in varchar2
1327 ) return number;
1328 pragma restrict_references (get_input_value_id12, WNDS);
1329 --
1330 function get_input_value_id13
1331 (
1332 p_input_value_name13 in varchar2,
1333 p_element_name in varchar2,
1334 p_business_group_id in number,
1335 p_effective_date in date,
1336 p_language_code in varchar2
1337 ) return number;
1338 pragma restrict_references (get_input_value_id13, WNDS);
1339 --
1340 function get_input_value_id14
1341 (
1342 p_input_value_name14 in varchar2,
1343 p_element_name in varchar2,
1344 p_business_group_id in number,
1345 p_effective_date in date,
1346 p_language_code in varchar2
1347 ) return number;
1348 pragma restrict_references (get_input_value_id14, WNDS);
1349 --
1350 function get_input_value_id15
1351 (
1352 p_input_value_name15 in varchar2,
1353 p_element_name in varchar2,
1354 p_business_group_id in number,
1355 p_effective_date in date,
1356 p_language_code in varchar2
1357 ) return number;
1358 pragma restrict_references (get_input_value_id15, WNDS);
1359
1360 -------------------------------- get_rate_id ----------------------------------
1361 /*
1362 NAME
1363 get_rate_id
1364 DESCRIPTION
1365 Function returning Rate ID.
1366 */
1367 function get_rate_id
1368 ( p_rate_name in varchar2,
1369 p_business_group_id in number
1370 ) return number;
1371 pragma restrict_references (get_rate_id, WNDS);
1372
1373 ----------------------------- get_person_type_id ------------------------------
1374 /*
1375 NAME
1376 get_person_type_id
1377 DESCRIPTION
1378 Returns a Person Type ID.
1379 NOTES
1380 This function returns a person_type_id.
1381 */
1382 function get_person_type_id
1383 (
1384 p_user_person_type in varchar2,
1385 p_business_group_id in number,
1386 p_language_code in varchar2
1390 -------------------------------- get_vendor_id --------------------------------
1387 ) return number;
1388 pragma restrict_references (get_person_type_id, WNDS);
1389
1391 /*
1392 NAME
1393 get_vendor_id
1394 DESCRIPTION
1395 Returns a Vendor ID.
1396 NOTES
1397 This function returns a vendor_id.
1398 */
1399 function get_vendor_id
1400 (
1401 p_vendor_name in varchar2
1402 ) return number;
1403 pragma restrict_references (get_vendor_id, WNDS);
1404
1405 ------------------------ get_assignment_status_type_id ------------------------
1406 /*
1407 NAME
1408 get_assignment_status_type_id
1409 DESCRIPTION
1410 Returns an Assignment Status Type ID.
1411 NOTES
1412 This function returns an assignment_status_type_id.
1413 */
1414 function get_assignment_status_type_id
1415 (
1416 p_user_status in varchar2,
1417 p_business_group_id in number,
1418 p_language_code in varchar2
1419 ) return number;
1420 pragma restrict_references (get_assignment_status_type_id, WNDS);
1421
1422 ----------------------------- get_organization_id -----------------------------
1423 /*
1424 NAME
1425 get_organization_id
1426 DESCRIPTION
1427 Returns an Organization ID.
1428 NOTES
1429 This function returns an organization_id.
1430 */
1431 function get_organization_id
1432 (
1433 p_organization_name in varchar2,
1434 p_business_group_id in number,
1435 p_effective_date in date
1436 , p_language_code in varchar2
1437 ) return number;
1438 pragma restrict_references (get_organization_id, WNDS);
1439
1440 --------------------------- get_establishment_org_id ----------------------------
1441 /*
1442 NAME
1443 get_establishment_org_id
1444 DESCRIPTION
1445 Returns an Establishment (Organization) ID.
1446 NOTES
1447 This function returns an establishment organization_id for the
1448 assignment APIs.
1449 */
1450 function get_establishment_org_id
1451 (
1452 p_establishment_org_name in varchar2,
1453 p_business_group_id in number,
1454 p_effective_date in date
1455 , p_language_code in varchar2
1456 ) return number;
1457 pragma restrict_references (get_establishment_org_id, WNDS);
1458
1459 -------------------------- get_source_organization_id -------------------------
1460 /*
1461 NAME
1462 get_source_organization_id
1463 DESCRIPTION
1464 Returns a Source Organization ID.
1465 NOTES
1466 This function returns a source_organization_id.
1467 */
1468 function get_source_organization_id
1469 (
1470 p_source_organization_name in varchar2,
1471 p_business_group_id in number,
1472 p_effective_date in date
1473 , p_language_code in varchar2
1474 ) return number;
1475 pragma restrict_references (get_source_organization_id, WNDS);
1476
1477 --------------------------------- get_grade_id --------------------------------
1478 /*
1479 NAME
1480 get_grade_id
1481 DESCRIPTION
1482 Returns a Grade ID.
1483 NOTES
1484 This function returns a grade_id.
1485 */
1486 function get_grade_id
1487 (
1488 p_grade_name in varchar2,
1489 p_business_group_id in number,
1490 p_effective_date in date
1491 ) return number;
1492 pragma restrict_references (get_grade_id, WNDS);
1493
1494 ----------------------------- get_entry_grade_id ------------------------------
1495 /*
1496 NAME
1497 get_entry_grade_id
1498 NOTES
1499 Calls get_grade_id.
1500 */
1501 function get_entry_grade_id
1502 (
1503 p_entry_grade_name in varchar2,
1504 p_business_group_id in number,
1505 p_effective_date in date
1506 ) return number;
1507 pragma restrict_references (get_entry_grade_id, WNDS);
1508
1509 ------------------------------- get_position_id -------------------------------
1510 /*
1511 NAME
1512 get_position_id
1513 DESCRIPTION
1514 Returns a Position ID.
1515 NOTES
1516 This function returns a position_id.
1517 */
1518 function get_position_id
1519 (
1520 p_position_name in varchar2,
1521 p_business_group_id in number,
1522 p_effective_date in date
1523 ) return number;
1524 pragma restrict_references (get_position_id, WNDS);
1525
1526 ------------------------- get_successor_position_id ---------------------------
1527 /*
1528 NAME
1529 get_successor_position_id
1530 DESCRIPTION
1531 Returns a Successor Position ID.
1532 NOTES
1533 This function returns a successor_position_id.
1534 */
1535 function get_successor_position_id
1536 (
1537 p_successor_position_name in varchar2,
1538 p_business_group_id in number,
1539 p_effective_date in date
1540 ) return number;
1541 pragma restrict_references (get_successor_position_id, WNDS);
1542
1543 ------------------------- get_relief_position_id ---------------------------
1544 /*
1545 NAME
1546 get_relief_position_id
1547 DESCRIPTION
1548 Returns a Relief Position ID.
1549 NOTES
1553 (
1550 This function returns a relief_position_id.
1551 */
1552 function get_relief_position_id
1554 p_relief_position_name in varchar2,
1555 p_business_group_id in number,
1556 p_effective_date in date
1557 ) return number;
1558 pragma restrict_references (get_relief_position_id, WNDS);
1559
1560 ------------------------- get_prior_position_id ---------------------------
1561 /*
1562 NAME
1563 get_prior_position_id
1564 NOTES
1565 Calls get_position_id.
1566 */
1567 function get_prior_position_id
1568 (
1569 p_prior_position_name in varchar2,
1570 p_business_group_id in number,
1571 p_effective_date in date
1572 ) return number;
1573 pragma restrict_references (get_prior_position_id, WNDS);
1574
1575 ------------------------- get_supervisor_position_id ---------------------------
1576 /*
1577 NAME
1578 get_supervisor_position_id
1579 NOTES
1580 Calls get_position_id.
1581 */
1582 function get_supervisor_position_id
1583 (
1584 p_supervisor_position_name in varchar2,
1585 p_business_group_id in number,
1586 p_effective_date in date
1587 ) return number;
1588 pragma restrict_references (get_supervisor_position_id, WNDS);
1589
1590 --------------------------------- get_job_id ----------------------------------
1591 /*
1592 NAME
1593 get_job_id
1594 DESCRIPTION
1595 Returns a Job ID.
1596 NOTES
1597 This function returns a job_id.
1598 */
1599 function get_job_id
1600 (
1601 p_job_name in varchar2,
1602 p_effective_date in date,
1603 p_business_group_id in number
1604 ) return number;
1605 pragma restrict_references (get_job_id, WNDS);
1606
1607 ------------------------------- get_payroll_id --------------------------------
1608 /*
1609 NAME
1610 get_payroll_id
1611 DESCRIPTION
1612 Returns a Payroll ID.
1613 NOTES
1614 This function returns a payroll_id.
1615 */
1616 function get_payroll_id
1617 (
1618 p_payroll_name in varchar2,
1619 p_business_group_id in number,
1620 p_effective_date in date
1621 ) return number;
1622 pragma restrict_references (get_payroll_id, WNDS);
1623
1624 --------------------------- get_pay_freq_payroll_id ----------------------------
1625 /*
1626 NAME
1627 get_pay_freq_payroll_id
1628 NOTES
1629 Calls get_payroll_id.
1630 */
1631 function get_pay_freq_payroll_id
1632 (
1633 p_pay_freq_payroll_name in varchar2,
1634 p_business_group_id in number,
1635 p_effective_date in date
1636 ) return number;
1637 pragma restrict_references (get_pay_freq_payroll_id, WNDS);
1638
1639 ------------------------- get_location_id_update --------------------------
1640 /*
1641 NAME
1642 get_location_id_update
1643 DESCRIPTION
1644 Returns a Location ID.
1645 NOTES
1646 Calls get_location_id, but was written to allow the update_location
1647 APIs to update the location_code.
1648 The name does not end in _ID so that it's always seeded as a mapping
1649 function.
1650 */
1651 function get_location_id_update
1652 (
1653 p_existing_location_code in varchar2,
1654 p_business_group_id in number,
1655 p_language_code in varchar2
1656 ) return number;
1657 pragma restrict_references (get_location_id_update, WNDS);
1658
1659 ------------------------------ get_location_id --------------------------------
1660 /*
1661 NAME
1662 get_location_id
1663 DESCRIPTION
1664 Returns a Location ID.
1665 NOTES
1666 This function returns a location_id.
1667 */
1668 function get_location_id
1669 (
1670 p_location_code in varchar2,
1671 p_business_group_id in number,
1672 p_language_code in varchar2
1673 ) return number;
1674 pragma restrict_references (get_location_id, WNDS);
1675 -----------------------------get_designated_receiver_id -----------------------
1676 /*
1677 NAME
1678 get_designated_receiver_id
1679 DESCRIPTION
1680 Returns receiver id
1681 */
1682 function get_designated_receiver_id
1683 (
1684 p_designated_receiver_name In Varchar2,
1685 p_business_group_id In Number,
1686 p_effective_date In Date
1687 ) return number;
1688 pragma restrict_references (get_designated_receiver_id, WNDS);
1689
1690 ------------------------------ get_ship_to_location_id --------------------------------
1691 /*
1692 NAME
1693 get_ship_location_id
1694 DESCRIPTION
1695 Returns a Location ID.
1696 NOTES
1697 This function returns a location_id.
1698 */
1699 function get_ship_to_location_id
1700 (
1701 p_ship_to_location_code in varchar2,
1702 p_business_group_id in number,
1703 p_language_code in varchar2
1704 ) return number;
1705 pragma restrict_references (get_ship_to_location_id, WNDS);
1706
1707 ------------------------------ get_pay_basis_id -------------------------------
1708 /*
1709 NAME
1710 get_pay_basis_id
1711 DESCRIPTION
1712 Returns a Pay Basis ID.
1716 function get_pay_basis_id
1713 NOTES
1714 This function returns a pay_basis_id.
1715 */
1717 (
1718 p_pay_basis_name in varchar2,
1719 p_business_group_id in number
1720 ) return number;
1721 pragma restrict_references (get_pay_basis_id, WNDS);
1722
1723 ------------------------- get_recruitment_activity_id -------------------------
1724 /*
1725 NAME
1726 get_recruitment_activity_id
1727 DESCRIPTION
1728 Returns a Recruitment Activity ID.
1729 NOTES
1730 This function returns a recruitment_activity_id.
1731 */
1732 function get_recruitment_activity_id
1733 (
1734 p_recruitment_activity_name in varchar2,
1735 p_business_group_id in number,
1736 p_effective_date in date
1737 ) return number;
1738 pragma restrict_references (get_recruitment_activity_id, WNDS);
1739
1740 -------------------------------- get_vacancy_id -------------------------------
1741 /*
1742 NAME
1743 get_vacancy_id
1744 DESCRIPTION
1745 Returns a Vacancy ID.
1746 NOTES
1747 This function returns a vacancy_id. The user needs to set up the user
1748 key value.
1749 */
1750 function get_vacancy_id
1751 (
1752 p_vacancy_user_key in varchar2
1753 ) return number;
1754 pragma restrict_references (get_vacancy_id, WNDS);
1755
1756 -------------------------- get_org_payment_method_id --------------------------
1757 /*
1758 NAME
1759 get_org_payment_method_id
1760 DESCRIPTION
1761 Returns an Organization Payment Method ID.
1762 NOTES
1763 This function returns an org_payment_method_id.
1764 */
1765 function get_org_payment_method_id
1766 (
1767 p_org_payment_method_user_key in varchar2
1768 ) return number;
1769 pragma restrict_references (get_org_payment_method_id, WNDS);
1770
1771 ------------------------------ get_payee_org_id -------------------------------
1772 /*
1773 NAME
1774 get_org_payee_id
1775 DESCRIPTION
1776 Returns a Payee ID for a payee that is an organization.
1777 NOTES
1778 This function returns a payee_id.
1779 */
1780 function get_payee_org_id
1781 (
1782 p_payee_organization_name in varchar2,
1783 p_business_group_id in number,
1784 p_effective_date in date
1785 , p_language_code in varchar2
1786 ) return number;
1787 pragma restrict_references (get_payee_org_id, WNDS);
1788
1789 ----------------------------- get_payee_person_id -----------------------------
1790 /*
1791 NAME
1792 get_payee_person_id
1793 DESCRIPTION
1794 Returns a Person ID that is a person.
1795 NOTES
1796 This function returns a person_id and is designed for use
1797 with the Data Pump.
1798 */
1799 function get_payee_person_id
1800 (
1801 p_payee_person_user_key in varchar2
1802 ) return number;
1803 pragma restrict_references (get_payee_person_id, WNDS);
1804
1805 -------------------------------- get_payee_id ----------------------------------
1806 /*
1807 NAME
1808 get_payee_id
1809 DESCRIPTION
1810 Returns a Payee ID for a payee that is an organization or a person.
1811 */
1812 function get_payee_id
1813 (
1814 p_data_pump_always_call in varchar2,
1815 p_payee_type in varchar2,
1816 p_business_group_id in number,
1817 p_payee_org in varchar2 default null,
1818 p_payee_person_user_key in varchar2 default null,
1819 p_effective_date in date
1820 , p_language_code in varchar2
1821 ) return number;
1822 pragma restrict_references (get_payee_id, WNDS);
1823
1824 ----------------------- get_personal_payment_method_id ------------------------
1825 /*
1826 NAME
1827 get_personal_payment_method_id
1828 DESCRIPTION
1829 Returns a Personal Payment Method ID.
1830 NOTES
1831 This function returns a personal_payment_method_id.
1832 */
1833 function get_personal_payment_method_id
1834 (
1835 p_personal_pay_method_user_key in varchar2
1836 ) return number;
1837 pragma restrict_references (get_personal_payment_method_id, WNDS);
1838
1839 ----------------------------- get_set_of_books_id -----------------------------
1840 /*
1841 NAME
1842 get_set_of_books_id
1843 DESCRIPTION
1844 Returns a Set of Books ID.
1845 NOTES
1846 This function returns a set_of_books_id.
1847 */
1848 function get_set_of_books_id
1849 (
1850 p_set_of_books_name varchar2
1851 ) return number;
1852 pragma restrict_references (get_set_of_books_id, WNDS);
1853
1854 ------------------------------- get_tax_unit_id -------------------------------
1855 /*
1856 NAME
1857 get_tax_unit_id
1858 DESCRIPTION
1859 Returns a Tax Unit ID.
1860 NOTES
1861 This function returns a tax_unit_id.
1862 Return code of varchar2 to match API parameter type.
1863 */
1864 function get_tax_unit_id
1865 (
1866 p_tax_unit_name in varchar2,
1867 p_effective_date in date
1868 ) return varchar2;
1869 pragma restrict_references (get_tax_unit_id, WNDS);
1870
1871 ------------------------------ get_work_schedule ------------------------------
1872 /*
1876 Returns a user_column_id for a work schedule.
1873 NAME
1874 get_work_schedule
1875 DESCRIPTION
1877 NOTES
1878 This function is used to return a user_column_id when
1879 used by US API.
1880 */
1881 function get_work_schedule
1882 (
1883 p_work_schedule in varchar2,
1884 p_organization_name in varchar2,
1885 p_business_group_id in number,
1886 p_effective_date in date
1887 , p_language_code in varchar2
1888 ) return number;
1889 pragma restrict_references (get_work_schedule, WNDS);
1890
1891 --------------------------- get_eeo_1_establishment ---------------------------
1892 /*
1893 NAME
1894 get_eeo_1_establishment
1895 DESCRIPTION
1896 Returns a establishment_id.
1897 NOTES
1898 <none>
1899 */
1900 function get_eeo_1_establishment_id
1901 (
1902 p_eeo_1_establishment in varchar2,
1903 p_business_group_id in number,
1904 p_effective_date in date
1905 ) return number;
1906 pragma restrict_references (get_eeo_1_establishment_id, WNDS);
1907
1908 ------------------------- get_correspondence_language -------------------------
1909 /*
1910 NAME
1911 get_correspondence_language
1912 DESCRIPTION
1913 Returns a language code.
1914 NOTES
1915 Uses the FND_LANGUAGES table. If p_correspondance_language cannot be
1916 matched, it is assumed that the user entered the language code.
1917 */
1918 function get_correspondence_language
1919 (
1920 p_correspondence_language varchar2
1921 ) return varchar2;
1922 pragma restrict_references (get_correspondence_language, WNDS);
1923
1924 ------------------------------ get_id_flex_num ---------------------------------
1925 /*
1926 NAME
1927 get_id_flex_num
1928 DESCRIPTION
1929 Returns an id_flex_num for a keyflex structure.
1930 NOTES
1931 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
1932 */
1933 function get_id_flex_num
1934 (
1935 p_id_flex_num_user_key varchar2
1936 ) return number;
1937 pragma restrict_references (get_id_flex_num, WNDS);
1938
1939 ----------------------------- get_program_application_id ----------------------
1940 /*
1941 NAME
1942 get_program_application_id
1943 DESCRIPTION
1944 Returns a Program Application ID.
1945 NOTES
1946 Standard who column.
1947 */
1948 function get_program_application_id return number;
1949 pragma restrict_references (get_program_application_id, WNDS);
1950
1951 --------------------------------- get_program_id ------------------------------
1952 /*
1953 NAME
1954 get_program_id
1955 DESCRIPTION
1956 Returns a Program ID.
1957 NOTES
1958 Standard who column.
1959 */
1960 function get_program_id return number;
1961 pragma restrict_references (get_program_id, WNDS);
1962
1963 --------------------------------- get_request_id ------------------------------
1964 /*
1965 NAME
1966 get_request_id
1967 DESCRIPTION
1968 Returns a Request ID.
1969 NOTES
1970 Standard who column.
1971 */
1972 function get_request_id return number;
1973 pragma restrict_references (get_request_id, WNDS);
1974
1975 --------------------------------- get_creator_id ------------------------------
1976 /*
1977 NAME
1978 get_creator_id
1979 DESCRIPTION
1980 Returns a Creator ID.
1981 NOTES
1982 Standard who column.
1983 */
1984 function get_creator_id return number;
1985 pragma restrict_references (get_creator_id, WNDS);
1986
1987 ----------------------------- get_gr_grade_rule_id --------------------------------
1988 /*
1989 NAME
1990 get_gr_grade_rule_id
1991 get_pp_grade_rule_id
1992 DESCRIPTION
1993 Functions returning Grade Rule ID.
1994 get_pp_grade_rule_id uses the progression (spinal) point and pay scale
1995 (parent spine) name to get the grade_rule_id. get_gr_grade_rule_id uses
1996 the grade name to get the grade_rule_id.
1997 NOTES
1998 get_gr_grade_rule_id is designed for use with the HR GRADE API.
1999 get_pp_grade_rule_id is designed for use with the HR PAY SCALE API.
2000 */
2001 function get_gr_grade_rule_id
2002 (
2003 p_grade_name in varchar2,
2004 p_rate_name in varchar2,
2005 p_business_group_id in number,
2006 p_effective_date in date
2007 )
2008 return number;
2009 pragma restrict_references (get_gr_grade_rule_id, WNDS);
2010 --
2011 function get_pp_grade_rule_id
2012 (
2013 p_progression_point in varchar2,
2014 p_pay_scale in varchar2,
2015 p_rate_name in varchar2,
2016 p_business_group_id in number,
2017 p_effective_date in date
2018 )
2019 return number;
2020 pragma restrict_references (get_pp_grade_rule_id, WNDS);
2021
2022 function get_ar_grade_rule_id
2023 (
2024 p_rate_name in varchar2,
2025 p_business_group_id in number,
2026 p_effective_date in date
2027 )
2028 return number;
2029 pragma restrict_references (get_pp_grade_rule_id, WNDS);
2030 --------------------------- get_organization_structure_id --------------------------------
2031 /*
2032 NAME
2036 */
2033 get_organization_structure_id
2034 DESCRIPTION
2035 Function returning Organization Structure ID
2037 function get_organization_structure_id
2038 (
2039 p_name in varchar2,
2040 p_business_group_id in number
2041 )
2042 return number;
2043 pragma restrict_references (get_organization_structure_id, WNDS);
2044
2045 --------------------------- get_org_str_ver_id --------------------------------
2046 /*
2047 NAME
2048 get_org_str_ver_id
2049 DESCRIPTION
2050 Function returning Organization Structure Version ID
2051 */
2052 function get_org_str_ver_id
2053 (
2054 p_business_group_id in number,
2055 p_organization_structure_id in number,
2056 p_date_from in date,
2057 p_version_number in number
2058 )
2059 return number;
2060 pragma restrict_references (get_org_str_ver_id, WNDS);
2061
2062 --------------------------- get_spinal_point_id --------------------------------
2063 /*
2064 NAME
2065 get_spinal_point_id
2066 DESCRIPTION
2067 Function returning Spinal Point ID.
2068 get_spinal_point_id uses the progression (spinal) point and pay scale
2069 (parent spine) name to get the spinal_point_id.
2070 */
2071 function get_spinal_point_id
2072 (
2073 p_progression_point in varchar2,
2074 p_pay_scale in varchar2,
2075 p_business_group_id in number,
2076 p_effective_date in date
2077 )
2078 return number;
2079 pragma restrict_references (get_spinal_point_id, WNDS);
2080
2081 -------------------------------- get_country -----------------------------------
2082 /*
2083 NAME
2084 get_country
2085 DESCRIPTION
2086 Function returning a territory code when supplied a territory short
2087 name. If the short name does not match, the code assumes that
2088 the user supplied the code and returns p_country.
2089 */
2090 function get_country( p_country in varchar2 ) return varchar2;
2091 pragma restrict_references (get_country, WNDS);
2092
2093 ------------------------- get_period_of_service_id -----------------------------
2094 /*
2095 NAME
2096 get_at_period_of_service_id
2097 get_fp_period_of_service_id
2098 get_ut_period_of_service_id
2099 DESCRIPTION
2100 Functions returning Period Of Service ID.
2101 get_at_period_of_service_id gets the period_of_service_id in the case
2102 where the actual termination date has not been set.
2103 get_fp_period_of_service_id gets the period_of_service_id in the case
2104 where the actual termination date has been set, but the final process
2105 date has not been set.
2106 get_ut_period_of_service_id gets the period of service for a effective date
2107 NOTES
2108 get_at_period_of_service_id is designed for use with
2109 hr_ex_employee.actual_termination_emp.
2110 get_fp_period_of_service_id is designed for use with
2111 hr_ex_employee.final_process_emp.
2112 get_ut_period_of_service_id is designed for use with
2113 hr_ex_employee.update_term_details_emp.
2114 */
2115 function get_at_period_of_service_id
2116 (
2117 p_person_user_key in varchar2,
2118 p_business_group_id in number
2119 )
2120 return number;
2121 pragma restrict_references (get_at_period_of_service_id, WNDS);
2122 function get_fp_period_of_service_id
2123 (
2124 p_person_user_key in varchar2,
2125 p_business_group_id in number
2126 )
2127 return number;
2128 pragma restrict_references (get_fp_period_of_service_id, WNDS);
2129
2130 /* Added for 11i,Rvydyana,02-DEC-1999 */
2131 function get_ut_period_of_service_id
2132 (
2133 p_person_user_key in varchar2,
2134 p_effective_date in date,
2135 p_business_group_id in number
2136 )
2137 return number;
2138 pragma restrict_references (get_ut_period_of_service_id, WNDS);
2139
2140 ------------------------ get_special_ceiling_step_id ---------------------------
2141 /*
2142 NAME
2143 get_special_ceiling_step_id
2144 DESCRIPTION
2145 Returns an id_flex_num for a keyflex structure.
2146 NOTES
2147 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2148 */
2149 function get_special_ceiling_step_id
2150 (
2151 p_special_ceilin_step_user_key varchar2
2152 ) return number;
2153 pragma restrict_references (get_special_ceiling_step_id, WNDS);
2154
2155 ---------------------------- get_entry_step_id -------------------------------
2156 /*
2157 NAME
2158 get_entry_step_id
2159 DESCRIPTION
2160 Returns a Spinal Point Step ID.
2161 NOTES
2162 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2163 */
2164 function get_entry_step_id
2165 (
2166 p_entry_step_user_key in varchar2
2167 ) return number;
2168 pragma restrict_references (get_entry_step_id, WNDS);
2169
2170 ---------------------------- get_entry_grade_rule_id -------------------------------
2171 /*
2172 NAME
2173 get_entry_grade_rule_id
2174 NOTES
2175 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2176 */
2177 function get_entry_grade_rule_id
2178 (
2179 p_entry_grade_rule_user_key in varchar2
2180 ) return number;
2184 /*
2181 pragma restrict_references (get_entry_grade_rule_id, WNDS);
2182
2183 ----------------------- get_availability_status_id ---------------------------
2185 NAME
2186 get_availability_status_id
2187 DESCRIPTION
2188 Function returning Availability Status ID.
2189 */
2190 function get_availability_status_id
2191 (p_shared_type_name in varchar2
2192 ,p_system_type_cd in varchar2
2193 ,p_business_group_id in number
2194 ,p_language_code in varchar2
2195 ) return number ;
2196 pragma restrict_references (get_availability_status_id, WNDS);
2197
2198 ------------------------ get_default_code_comb_id ------------------------------
2199 /*
2200 NAME
2201 get_default_code_comb_id
2202 DESCRIPTION
2203 Returns the default_code_comb_id.
2204 NOTES
2205 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2206 */
2207 function get_default_code_comb_id
2208 (
2209 p_default_code_comb_user_key varchar2
2210 ) return number;
2211 pragma restrict_references (get_default_code_comb_id, WNDS);
2212
2213 ------------------------ get_phone_id -----------------------------------------
2214 /*
2215 NAME
2216 get_phone_id
2217 DESCRIPTION
2218 Returns the phone_id.
2219 NOTES
2220 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2221 */
2222 /* Added for 11i - Rvydyana - 06-DEC-1999 */
2223 function get_phone_id
2224 (
2225 p_phone_user_key in varchar2
2226 ) return number;
2227 pragma restrict_references (get_phone_id, WNDS);
2228 ------------------------ get_job_group_id -----------------------------------------
2229 /*
2230 NAME
2231 get_job_group_id
2232 DESCRIPTION
2233 Returns the job_group_id.
2234 NOTES
2235 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2236 */
2237 function get_job_group_id
2238 (
2239 p_job_group_user_key in varchar2
2240 ) return number;
2241 pragma restrict_references (get_job_group_id, WNDS);
2242 ------------------------ get_loc_id -----------------------------------------
2243 /*
2244 NAME
2245 get_loc_id
2246 DESCRIPTION
2247 sets p_location_id as a user key
2248 NOTES
2249 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2250 */
2251 function get_loc_id
2252 (
2253 p_location_user_key in varchar2
2254 ) return number;
2255 pragma restrict_references (get_loc_id, WNDS);
2256 ------------------------ get_org_structure_id -----------------------------------------
2257 /*
2258 NAME
2259 get_org_structure_id
2260 DESCRIPTION
2261 sets p_organization_structure_id as a user key
2262 NOTES
2263 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2264 */
2265 function get_org_structure_id
2266 (
2267 p_org_structure_user_key in varchar2
2268 ) return number;
2269 pragma restrict_references (get_org_structure_id, WNDS);
2270 ------------------------ get_org_str_version_id -----------------------------------------
2271 /*
2272 NAME
2273 get_org_str_version_id
2274 DESCRIPTION
2275 sets p_org_structure_version_id as a user key
2276 NOTES
2277 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2278 */
2279 function get_org_str_version_id
2280 (
2281 p_org_str_version_user_key in varchar2
2282 ) return number;
2283 pragma restrict_references (get_org_str_version_id, WNDS);
2284 ------------------------ get_org_id -----------------------------------------
2285 /*
2286 NAME
2287 get_org_id
2288 DESCRIPTION
2289 sets p_organization_id as a user key
2290 NOTES
2291 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2292 */
2293 function get_org_id
2294 (
2295 p_org_user_key in varchar2
2296 ) return number;
2297 pragma restrict_references (get_org_id, WNDS);
2298 ------------------------ get_grade_rule_id -----------------------------------------
2299 /*
2300 NAME
2301 get_grade_rule_id
2302 DESCRIPTION
2303 Returns the grade_rule_id.
2304 NOTES
2305 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2306 */
2307 function get_grade_rule_id
2308 (
2309 p_grade_rule_user_key in varchar2
2310 ) return number;
2311 pragma restrict_references (get_grade_rule_id, WNDS);
2312 ------------------------ get_benchmark_job_id -----------------------------------------
2313 /*
2314 NAME
2315 get_benchmark_job_id
2316 DESCRIPTION
2317 Returns the benchmark_job_id.
2318 NOTES
2319 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2320 */
2321 function get_benchmark_job_id
2322 (
2323 p_benchmark_job_user_key in varchar2
2324 ) return number;
2325 pragma restrict_references (get_benchmark_job_id, WNDS);
2326 ------------------------ get_role_id -----------------------------------------
2327 /*
2328 NAME
2329 get_role_id
2330 DESCRIPTION
2331 Returns the role_id.
2332 NOTES
2333 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2334 */
2335 function get_role_id
2336 (
2340
2337 p_role_user_key in varchar2
2338 ) return number;
2339 pragma restrict_references (get_role_id, WNDS);
2341 ------------------------ get_grade_ladder_pgm_id ------------------------------
2342 /*
2343 NAME
2344 get_grade_ladder_pgm_id
2345 DESCRIPTION
2346 Returns the grade_ladder_pgm_id.
2347 NOTES
2348 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2349 */
2350 function get_grade_ladder_pgm_id
2351 (
2352 p_grade_ladder_name in varchar2
2353 ,p_business_group_id in number
2354 ,p_effective_date in date
2355 ) return number;
2356 pragma restrict_references (get_grade_ladder_pgm_id, WNDS);
2357
2358 ------------------------ get_supervisor_assignment_id ------------------------
2359 /*
2360 NAME
2361 get_supervisor_assignment_id
2362 DESCRIPTION
2363 Returns the supervisor_assignment_id.
2364 NOTES
2365 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2366 */
2367 function get_supervisor_assignment_id
2368 (
2369 p_svr_assignment_user_key in varchar2
2370 ) return number;
2371 pragma restrict_references (get_supervisor_assignment_id, WNDS);
2372
2373 /*--------------------- get_parent_spine_id ----------------------------------*/
2374 function get_parent_spine_id
2375 (
2376 p_parent_spine in varchar2,
2377 p_business_group_id in number
2378 )
2379 return number;
2380 /*--------------------- get_ceiling_step_id ----------------------------------*/
2381 function get_ceiling_step_id
2382 (
2383 p_ceiling_point in varchar2,
2384 p_business_group_id in number,
2385 p_effective_date in date
2386 )
2387 return number;
2388 /*---------------------------------------------------------------------------*/
2389 /*------------------- get object version number functions -------------------*/
2390 /*---------------------------------------------------------------------------*/
2391
2392 ---------------------- get_collective_agreement_ovn ------------------------
2393 /*
2394 NAME
2395 get_collective_agreement_ovn
2396 DESCRIPTION
2397 Returns a Collective Agreement object version number.
2398 */
2399 function get_collective_agreement_ovn
2400 (p_business_group_id in number
2401 ,p_cagr_name in varchar2
2402 ,p_effective_date in date
2403 ) return number;
2404 pragma restrict_references (get_collective_agreement_ovn, WNDS);
2405
2406 ------------------------------- get_contract_ovn ---------------------------
2407 /*
2408 NAME
2409 get_contract_ovn
2410 DESCRIPTION
2411 Returns a Contract object version number.
2412 */
2413 function get_contract_ovn
2414 (p_contract_user_key in varchar2
2415 ,p_effective_date in date
2416 ) return number;
2417 pragma restrict_references (get_contract_ovn, WNDS);
2418
2419 ----------------------------- get_establishment_ovn ---------------------------
2420 /*
2421 NAME
2422 get_establishment_ovn
2423 DESCRIPTION
2424 Returns an Establishment object version number.
2425 */
2426 function get_establishment_ovn
2427 (p_establishment_name in varchar2
2428 ,p_location in varchar2
2429 ) return number;
2430 pragma restrict_references (get_establishment_ovn, WNDS);
2431
2432 ----------------------- get_us_emp_fed_tax_rule_ovn --------------------------
2433 /*
2434 NAME
2435 get_us_emp_fed_tax_rule_ovn
2436 DESCRIPTION
2437 Returns a tax rule Object Version Number.
2438 NOTES
2439 This returns an object version number for a tax rule that has
2440 been created via the Data Pump engine.
2441 */
2442 function get_us_emp_fed_tax_rule_ovn
2443 (
2444 p_emp_fed_tax_rule_user_key in varchar2,
2445 p_effective_date in date
2446 ) return number;
2447 pragma restrict_references (get_us_emp_fed_tax_rule_ovn, WNDS);
2448
2449
2450 ----------------------- get_us_emp_state_tax_rule_ovn --------------------------
2451 /*
2452 NAME
2453 get_us_emp_state_tax_rule_ovn
2454 DESCRIPTION
2455 Returns a tax rule Object Version Number.
2456 NOTES
2457 This returns an object version number for a tax rule that has
2458 been created via the Data Pump engine.
2459 */
2460 function get_us_emp_state_tax_rule_ovn
2461 (
2462 p_emp_state_tax_rule_user_key in varchar2,
2463 p_effective_date in date
2464 ) return number;
2465 pragma restrict_references (get_us_emp_state_tax_rule_ovn, WNDS);
2466
2467 ----------------------- get_us_emp_county_tax_rule_ovn --------------------------
2468 /*
2469 NAME
2470 get_us_emp_county_tax_rule_ovn
2471 DESCRIPTION
2472 Returns a tax rule Object Version Number.
2473 NOTES
2474 This returns an object version number for a tax rule that has
2475 been created via the Data Pump engine.
2476 */
2477 function get_us_emp_county_tax_rule_ovn
2478 (
2479 p_emp_county_tax_rule_user_key in varchar2,
2480 p_effective_date in date
2481 ) return number;
2482 pragma restrict_references (get_us_emp_county_tax_rule_ovn, WNDS);
2483
2484 ----------------------- get_us_emp_city_tax_rule_ovn --------------------------
2485 /*
2489 Returns a tax rule Object Version Number.
2486 NAME
2487 get_us_emp_city_tax_rule_ovn
2488 DESCRIPTION
2490 NOTES
2491 This returns an object version number for a tax rule that has
2492 been created via the Data Pump engine.
2493 */
2494 function get_us_emp_city_tax_rule_ovn
2495 (
2496 p_emp_city_tax_rule_user_key in varchar2,
2497 p_effective_date in date
2498 ) return number;
2499 pragma restrict_references (get_us_emp_city_tax_rule_ovn, WNDS);
2500
2501 --------------------------------- get_per_ovn ---------------------------------
2502 /*
2503 NAME
2504 get_per_ovn
2505 DESCRIPTION
2506 Returns a Person Object Version Number.
2507 NOTES
2508 This returns an object version number for a person that has
2509 been created via the Data Pump engine.
2510 */
2511 function get_per_ovn
2512 (
2513 p_person_user_key in varchar2,
2514 p_effective_date in date
2515 ) return number;
2516 pragma restrict_references (get_per_ovn, WNDS);
2517
2518 --------------------------------- get_asg_ovn ---------------------------------
2519 /*
2520 NAME
2521 get_asg_ovn
2522 DESCRIPTION
2523 Returns an Assignment Object Version Number.
2524 NOTES
2525 This returns an object version number for an assignment that has
2526 been created via the Data Pump engine.
2527 */
2528 function get_asg_ovn
2529 (
2530 p_assignment_user_key in varchar2,
2531 p_effective_date in date
2532 ) return number;
2533 pragma restrict_references (get_asg_ovn, WNDS);
2534
2535 --------------------------------- get_adr_ovn ---------------------------------
2536 /*
2537 NAME
2538 get_adr_ovn
2539 DESCRIPTION
2540 Returns an Address Object Version Number.
2541 NOTES
2542 This returns an object version number for an address that has
2543 been created via the Data Pump engine.
2544 */
2545 function get_adr_ovn
2546 (
2547 p_address_user_key in varchar2,
2548 p_effective_date in date
2549 ) return number;
2550 pragma restrict_references (get_adr_ovn, WNDS);
2551
2552 --------------------------------- get_loc_ovn ---------------------------------
2553 /*
2554 NAME
2555 get_loc_ovn
2556 DESCRIPTION
2557 Returns a Location Object Version Number.
2558 NOTES
2559 Returns an object version number for a location.
2560 This function can be used outside the data pump.
2561 */
2562 function get_loc_ovn
2563 (
2564 p_location_code in varchar2
2565 ) return number;
2566 pragma restrict_references (get_loc_ovn, WNDS);
2567
2568 --------------------------------- get_org_str_ovn ------------------------------
2569 /*
2570 NAME
2571 get_org_str_ovn
2572 DESCRIPTION
2573 Returns an Organization Structure Object Version Number.
2574 NOTES
2575 Returns an object version number for an organization strucutre.
2576 This function can be used outside the data pump.
2577 */
2578 function get_org_str_ovn
2579 (
2580 p_name in varchar2,
2581 p_business_group_id in number
2582 ) return number;
2583 pragma restrict_references (get_org_str_ovn, WNDS);
2584
2585 --------------------------------- get_org_str_ver_ovn ------------------------------
2586 /*
2587 NAME
2588 get_org_str_ver_ovn
2589 DESCRIPTION
2590 Returns an Organization Structure Version Object Version Number.
2591 NOTES
2592 Returns an object version number for an organization strucutre version.
2593 This function can be used outside the data pump.
2594 */
2595 function get_org_str_ver_ovn
2596 (
2597 p_business_group_id in number,
2598 p_organization_structure_id in number,
2599 p_date_from in date,
2600 p_version_number in number
2601 ) return number;
2602 pragma restrict_references (get_org_str_ver_ovn, WNDS);
2603 --------------------------------- get_org_ovn ------------------------------
2604 /*
2605 NAME
2606 get_org_ovn
2607 DESCRIPTION
2608 Returns an Organization Object Version Number.
2609 NOTES
2610 Returns an object version number for an organization.
2611 This function can be used outside the data pump.
2612 */
2613 function get_org_ovn
2614 (
2615 p_business_group_id in number,
2616 p_organization_name in varchar2,
2617 p_language_code in varchar2
2618 ) return number;
2619 pragma restrict_references (get_org_ovn, WNDS);
2620 --------------------------------- get_job_ovn ---------------------------------
2621 /*
2622 NAME
2623 get_job_ovn
2624 DESCRIPTION
2625 Returns a Job Object Version Number.
2626 NOTES
2627 Returns an object version number for a job.
2628 This function can be used outside the data pump.
2629 */
2630 function get_job_ovn
2631 (
2632 p_job_name in varchar2,
2633 p_effective_date in date,
2634 p_business_group_id in number
2635 ) return number;
2636 pragma restrict_references (get_job_ovn, WNDS);
2637
2638 --------------------------------- get_position_definition_id ---------------------------------
2639 /*
2640 NAME
2641 get_pos_ovn
2642 DESCRIPTION
2643 Returns a Position Object Version Number.
2647 */
2644 NOTES
2645 Returns an object version number for a position.
2646 This function can be used outside the data pump.
2648 function get_position_definition_id
2649 (
2650 p_position_name in varchar2,
2651 p_business_group_id in number,
2652 p_effective_date in date
2653 ) return number;
2654 pragma restrict_references (get_position_definition_id, WNDS);
2655 --------------------------------- get_pos_ovn ---------------------------------
2656 /*
2657 NAME
2658 get_pos_ovn
2659 DESCRIPTION
2660 Returns a Position Object Version Number.
2661 NOTES
2662 Returns an object version number for a position.
2663 This function can be used outside the data pump.
2664 */
2665 function get_pos_ovn
2666 (
2667 p_position_name in varchar2,
2668 p_business_group_id in number,
2669 p_effective_date in date
2670 ) return number;
2671 pragma restrict_references (get_pos_ovn, WNDS);
2672
2673 -------------------------------- get_ppm_ovn ----------------------------------
2674 /*
2675 NAME
2676 get_ppm_ovn
2677 DESCRIPTION
2678 Returns a Personal Payment Method Object Version Number.
2679 NOTES
2680 This function returns a person payment method ovn.
2681 */
2682 function get_ppm_ovn
2683 (
2684 p_personal_pay_method_user_key in varchar2,
2685 p_effective_date in date
2686 ) return number;
2687 pragma restrict_references (get_ppm_ovn, WNDS);
2688
2689 --------------------------- get_element_entry_ovn ------------------------------
2690 /*
2691 NAME
2692 get_element_entry_ovn
2693 DESCRIPTION
2694 Functions returning Element Entry Object Version Number.
2695 */
2696 function get_element_entry_ovn
2697 (
2698 p_element_entry_user_key in varchar2,
2699 p_effective_date in date
2700 ) return number;
2701 pragma restrict_references (get_element_entry_ovn, WNDS);
2702
2703 ---------------------------- get_grade_rule_ovn --------------------------------
2704 /*
2705 NAME
2706 get_gr_grade_rule_ovn
2707 get_pp_grade_rule_ovn
2708 DESCRIPTION
2709 Functions returning Grade Rule Object Version Number.
2710 get_pp_grade_rule_id uses the progression (spinal) point and pay scale
2711 (parent spine) name to get the grade rule object version number.
2712 get_gr_grade_rule_id uses the grade name to get the object version number.
2713 NOTES
2714 get_gr_grade_rule_id is designed for use with the HR GRADE API.
2715 get_pp_grade_rule_id is designed for use with the HR PAY SCALE API.
2716 */
2717 function get_gr_grade_rule_ovn
2718 (
2719 p_grade_name in varchar2,
2720 p_rate_name in varchar2,
2721 p_business_group_id in number,
2722 p_effective_date in date
2723 )
2724 return number;
2725 pragma restrict_references (get_gr_grade_rule_ovn, WNDS);
2726 --
2727 function get_pp_grade_rule_ovn
2728 (
2729 p_progression_point in varchar2,
2730 p_pay_scale in varchar2,
2731 p_rate_name in varchar2,
2732 p_business_group_id in number,
2733 p_effective_date in date
2734 )
2735 return number;
2736 pragma restrict_references (get_pp_grade_rule_ovn, WNDS);
2737
2738 ------------------------- get_period_of_service_ovn-----------------------------
2739 /*
2740 NAME
2741 get_at_period_of_service_ovn
2742 get_fp_period_of_service_ovn
2743 get_ut_period_of_service_ovn
2744 DESCRIPTION
2745 Functions returning Period Of Service Object Version Number.
2746 get_at_period_of_service_id gets the period_of_service object version
2747 number in the case where the actual termination date has not been set.
2748 get_at_period_of_service_id gets the period_of_service object version
2749 number in the case where the actual termination date has been set, but
2750 the final process date has not been set.
2751 get_ut_period_of_service_id gets the period_of_service object version
2752 number for a period_of_service_id for a effective date
2753 NOTES
2754 get_at_period_of_service_ovn is designed for use with
2755 hr_ex_employee.actual_termination_emp.
2756 get_fp_period_of_service_ovn is designed for use with
2757 hr_ex_employee.final_process_emp.
2758 get_ut_period_of_service_ovn is designed for use with
2759 hr_ex_employee.update_term_details_emp.
2760 */
2761 function get_at_period_of_service_ovn
2762 (
2763 p_person_user_key in varchar2,
2764 p_business_group_id in number
2765 )
2766 return number;
2767 pragma restrict_references (get_at_period_of_service_ovn, WNDS);
2768 function get_fp_period_of_service_ovn
2769 (
2770 p_person_user_key in varchar2,
2771 p_business_group_id in number
2772 )
2773 return number;
2774 pragma restrict_references (get_fp_period_of_service_ovn, WNDS);
2775
2776 /* Added for 11i,Rvydyana,02-DEC-1999 */
2777 function get_ut_period_of_service_ovn
2778 (
2779 p_person_user_key in varchar2,
2780 p_effective_date in date,
2781 p_business_group_id in number
2782 )
2783 return number;
2784 pragma restrict_references (get_ut_period_of_service_ovn, WNDS);
2785
2786 /* This function is used to derive the phone ovn for a phone user key */
2787 /* Added for 11i,Rvydyana,06-DEC-1999 */
2791 ) return number;
2788 function get_phn_ovn
2789 (
2790 p_phone_user_key in varchar2
2792 pragma restrict_references (get_phn_ovn, WNDS);
2793 --
2794 /* This function is used to derive the job group ovn for a job group user key */
2795 function get_jgr_ovn
2796 (
2797 p_job_group_user_key in varchar2
2798 ) return number;
2799 pragma restrict_references (get_jgr_ovn, WNDS);
2800 --
2801 /* This function is used to derive the role ovn for a role user key */
2802 function get_rol_ovn
2803 (
2804 p_role_user_key in varchar2
2805 ) return number;
2806 pragma restrict_references (get_rol_ovn, WNDS);
2807
2808 /*-------------- returns a pay scale object version number --------------------*/
2809 function get_pay_scale_ovn
2810 (
2811 p_pay_scale in varchar2,
2812 p_business_group_id in number
2813 ) return number;
2814 /*-------------- returns a preogresion point object version number ------------*/
2815 function get_progression_point_ovn
2816 (
2817 p_point in varchar2,
2818 p_business_group_id in number
2819 ) return number;
2820 /*-------------- returns a grade scale object version number ------------*/
2821 function get_grade_scale_ovn
2822 (
2823 p_grade in varchar2,
2824 p_pay_scale in varchar2,
2825 p_effective_date in date,
2826 p_business_group_id in number
2827 ) return number;
2828 /*-------------- returns a grade step object version number ------------*/
2829 function get_grade_step_ovn
2830 (
2831 p_point in varchar2,
2832 p_sequence in number,
2833 p_effective_date in date,
2834 p_business_group_id in number
2835 ) return number;
2836
2837 /*---------------------------------------------------------------------------*/
2838 /*----------------------- other special get functions -----------------------*/
2839 /*---------------------------------------------------------------------------*/
2840
2841 ------------------------------ get_change_reason ------------------------------
2842 /*
2843 NAME
2844 get_change_reason
2845 DESCRIPTION
2846 Returns the lookup code for change reason.
2847 NOTES
2848 This function is used to get the change reason lookup code
2849 because the lookup type is dependent on the type of
2850 assignment. Therefore, need to pass the assignment
2851 parameter information as well.
2852 If the change reason cannot be matched as a lookup meaning
2853 the code assumes that the user entered the lookup code
2854 directly.
2855 */
2856 function get_change_reason
2857 (
2858 p_change_reason in varchar2,
2859 p_assignment_user_key in varchar2,
2860 p_effective_date in date,
2861 p_language_code in varchar2
2862 ) return varchar2;
2863 --pragma restrict_references (get_change_reason, WNDS);
2864
2865 ------------------------------- get_lookup_code -------------------------------
2866 /*
2867 NAME
2868 get_lookup_code
2869 DESCRIPTION
2870 Returns the lookup code for a lookup type and meaning. If it cannot
2871 match the meaning, it will assume that p_meaning_or_code holds the
2872 lookup code and return p_meaning_or_code.
2873 NOTES
2874 This function designed to be called from the wrapper
2875 functions.
2876 */
2877 function get_lookup_code
2878 (
2879 p_meaning_or_code in varchar2,
2880 p_lookup_type in varchar2,
2881 p_effective_date in date default null,
2882 p_language_code in varchar2 default null
2883 ) return varchar2;
2884 --pragma restrict_references (get_lookup_code, WNDS);
2885
2886 --------------------------------- gl ----------------------------------------
2887 /*
2888 NAME
2889 gl
2890 DESCRIPTION
2891 Shortened name to save space for get_lookup_code call in wrapper
2892 functions.
2893 */
2894 function gl
2895 (
2896 p_meaning_or_code in varchar2,
2897 p_lookup_type in varchar2,
2898 p_effective_date in date default null,
2899 p_language_code in varchar2 default null
2900 ) return varchar2;
2901 /* return people_group_id */
2902 function get_people_group_id
2903 (
2904 p_people_group_user_name in varchar2,
2905 p_effective_date in date
2906 ) return number;
2907 /* return absence_attendance_type_id */
2908 function get_absence_attendance_type_id
2909 (
2910 p_aat_user_name in varchar2,
2911 p_business_group_id in number,
2912 p_effective_date in date
2913 ) return number;
2914 /* return SOFT_CODING_KEYFLEX_ID */
2915 function GET_SOFT_CODING_KEYFLEX_ID
2916 (
2917 p_con_seg_user_name in varchar2,
2918 p_effective_date in date
2919 ) return number;
2920 --pragma restrict_references (gl, WNDS);
2921 /* return pk_id for ben_prtt_rt_val table*/
2922 function get_pk_id
2923 (
2924 p_pk_name in varchar2
2925 ) return number
2926
2927 ;
2928
2929
2930 /* Bug 3275173 --get object version number -----------*/
2931 function get_fed_tax_rule_ovn
2932 (
2933 p_emp_fed_tax_rule_user_key in varchar2,
2934 p_effective_date in date
2935 ) return number;
2936
2937
2938 --
2942 function get_state_tax_rule_ovn
2939 -- Bug 3783381 -- get object versionn number for state, county and city
2940 --
2941
2943 (
2944 p_emp_state_tax_rule_user_key in varchar2,
2945 p_effective_date in date
2946 ) return number;
2947 --
2948 function get_county_tax_rule_ovn
2949 (
2950 p_emp_county_tax_rule_user_key in varchar2,
2951 p_effective_date in date
2952 ) return number;
2953 --
2954 function get_city_tax_rule_ovn
2955 (
2956 p_emp_city_tax_rule_user_key in varchar2,
2957 p_effective_date in date
2958 ) return number;
2959
2960 --
2961 --
2962 --
2963
2964
2965 -- -------------------------------------------------------------------------
2966 -- --------------------< get_cpn_ovn >--------------------------------
2967 -- -------------------------------------------------------------------------
2968 -- DESCRIPTION
2969 -- This function returns the
2970 --
2971 FUNCTION get_cpn_ovn
2972 (p_data_pump_always_call IN varchar2
2973 ,p_competence_name IN VARCHAR2
2974 ,p_business_group_id IN NUMBER)
2975 RETURN BINARY_INTEGER;
2976 PRAGMA RESTRICT_REFERENCES (get_cpn_ovn , WNDS);
2977 -- -------------------------------------------------------------------------
2978 -- --------------------< get_competence_id >--------------------------------
2979 -- -------------------------------------------------------------------------
2980 -- DESCRIPTION
2981 -- This function returns the
2982 --
2983 FUNCTION get_competence_id
2984 (p_data_pump_always_call IN varchar2
2985 ,p_competence_name IN VARCHAR2
2986 ,p_business_group_id IN NUMBER)
2987 RETURN BINARY_INTEGER;
2988 PRAGMA RESTRICT_REFERENCES (get_competence_id , WNDS);
2989 -- -------------------------------------------------------------------------
2990 -- ------------< get_parent_comp_element_id >-------------------------
2991 -- -------------------------------------------------------------------------
2992 -- DESCRIPTION
2993 -- This function returns the
2994 --
2995 FUNCTION get_parent_comp_element_id
2996 RETURN BINARY_INTEGER;
2997 -- -------------------------------------------------------------------------
2998 -- ----------------< get_qualification_type_id >-------------------------
2999 -- -------------------------------------------------------------------------
3000 -- DESCRIPTION
3001 -- This function returns the
3002 --
3003 FUNCTION get_qualification_type_id
3004 (p_data_pump_always_call IN varchar2
3005 ,p_qualification_type_name IN VARCHAR2
3006 )
3007 RETURN BINARY_INTEGER;
3008 PRAGMA RESTRICT_REFERENCES (get_qualification_type_id , WNDS);
3009 -- -------------------------------------------------------------------------
3010 -- --------------------< get_cpo_ovn >--------------------------------
3011 -- -------------------------------------------------------------------------
3012 -- DESCRIPTION
3013 -- This function returns the
3014 --
3015 FUNCTION get_cpo_ovn
3016 (p_data_pump_always_call IN varchar2
3017 ,p_outcome_name IN VARCHAR2
3018 )
3019 RETURN BINARY_INTEGER;
3020 PRAGMA RESTRICT_REFERENCES (get_cpo_ovn , WNDS);
3021 -- -------------------------------------------------------------------------
3022 -- -------------------------< get_outcome_id >---------------------------
3023 -- -------------------------------------------------------------------------
3024 -- DESCRIPTION
3025 -- This function returns the
3026 --
3027 FUNCTION get_outcome_id
3028 (p_data_pump_always_call IN varchar2
3029 ,p_outcome_name IN VARCHAR2
3030 )
3031 RETURN BINARY_INTEGER;
3032 PRAGMA RESTRICT_REFERENCES (get_outcome_id , WNDS);
3033 -- -------------------------------------------------------------------------
3034 -- --------------------< get_eqt_ovn >--------------------------------
3035 -- -------------------------------------------------------------------------
3036 -- DESCRIPTION
3037 -- This function returns the
3038 --
3039 FUNCTION get_eqt_ovn
3040 (p_data_pump_always_call IN varchar2
3041 ,p_qualification_type_name IN VARCHAR2
3042 )
3043 RETURN BINARY_INTEGER;
3044 PRAGMA RESTRICT_REFERENCES (get_eqt_ovn , WNDS);
3045 -- -------------------------------------------------------------------------
3046 -- --------------------< get_ceo_ovn >--------------------------------
3047 -- -------------------------------------------------------------------------
3048 -- DESCRIPTION
3049 -- This function returns the
3050 --
3051 FUNCTION get_ceo_ovn
3052 (p_data_pump_always_call IN varchar2
3053 ,p_element_outcome_name IN VARCHAR2
3054 )
3055 RETURN BINARY_INTEGER;
3056 PRAGMA RESTRICT_REFERENCES (get_ceo_ovn , WNDS);
3057 -- -------------------------------------------------------------------------
3058 -- ------------------< get_competence_element_id >------------------------
3059 -- -------------------------------------------------------------------------
3060 -- DESCRIPTION
3061 -- This function returns the
3062 --
3063 FUNCTION get_competence_element_id
3064 (p_data_pump_always_call IN varchar2
3065 ,p_competence_name IN VARCHAR2
3066 ,p_person_user_key IN VARCHAR2
3067 ,p_business_group_id IN NUMBER
3068 )
3069 RETURN BINARY_INTEGER;
3070 PRAGMA RESTRICT_REFERENCES (get_competence_element_id , WNDS);
3071 --
3072 -- -------------------------------------------------------------------------
3073 -- ------------------< get_cost_flex_stru_num >------------------------
3074 -- -------------------------------------------------------------------------
3075 -- DESCRIPTION
3076 -- This function returns the cost flex structure num
3077 --
3078 FUNCTION get_cost_flex_stru_num
3079 (p_data_pump_always_call IN varchar2
3080 ,p_cost_flex_stru_code IN VARCHAR2
3081 )
3082 RETURN BINARY_INTEGER;
3083 PRAGMA RESTRICT_REFERENCES (get_cost_flex_stru_num , WNDS);
3084 --
3085 -- -------------------------------------------------------------------------
3086 -- ------------------< get_grade_flex_stru_num >------------------------
3087 -- -------------------------------------------------------------------------
3088 -- DESCRIPTION
3089 -- This function returns the grade flex structure num
3090 --
3091 FUNCTION get_grade_flex_stru_num
3092 (p_data_pump_always_call IN varchar2
3093 ,p_grade_flex_stru_code IN VARCHAR2
3094 )
3095 RETURN BINARY_INTEGER;
3096 PRAGMA RESTRICT_REFERENCES (get_grade_flex_stru_num , WNDS);
3097 --
3098 -- -------------------------------------------------------------------------
3099 -- ------------------< get_job_flex_stru_num >------------------------
3103 --
3100 -- -------------------------------------------------------------------------
3101 -- DESCRIPTION
3102 -- This function returns the job flex structure num
3104 FUNCTION get_job_flex_stru_num
3105 (p_data_pump_always_call IN varchar2
3106 ,p_job_flex_stru_code IN VARCHAR2
3107 )
3108 RETURN BINARY_INTEGER;
3109 PRAGMA RESTRICT_REFERENCES (get_job_flex_stru_num , WNDS);
3110 --
3111 -- -------------------------------------------------------------------------
3112 -- ------------------< get_position_flex_stru_num >------------------------
3113 -- -------------------------------------------------------------------------
3114 -- DESCRIPTION
3115 -- This function returns the position flex structure num
3116 --
3117 FUNCTION get_position_flex_stru_num
3118 (p_data_pump_always_call IN varchar2
3119 ,p_position_flex_stru_code IN VARCHAR2
3120 )
3121 RETURN BINARY_INTEGER;
3122 PRAGMA RESTRICT_REFERENCES (get_position_flex_stru_num , WNDS);
3123 --
3124 -- -------------------------------------------------------------------------
3125 -- ------------------< get_group_flex_stru_num >------------------------
3126 -- -------------------------------------------------------------------------
3127 -- DESCRIPTION
3128 -- This function returns the people group flex structure num
3129 --
3130 FUNCTION get_group_flex_stru_num
3131 (p_data_pump_always_call IN varchar2
3132 ,p_group_flex_stru_code IN VARCHAR2
3133 )
3134 RETURN BINARY_INTEGER;
3135 PRAGMA RESTRICT_REFERENCES (get_group_flex_stru_num , WNDS);
3136 --
3137 -- -------------------------------------------------------------------------
3138 -- ------------------< get_competence_flex_stru_num >---------------------
3139 -- -------------------------------------------------------------------------
3140 -- DESCRIPTION
3141 -- This function returns the competence flex structure num
3142 --
3143 FUNCTION get_competence_flex_stru_num
3144 (p_data_pump_always_call IN varchar2
3145 ,p_competence_flex_stru_code IN VARCHAR2
3146 )
3147 RETURN BINARY_INTEGER;
3148 PRAGMA RESTRICT_REFERENCES (get_competence_flex_stru_num , WNDS);
3149 --
3150 -- -------------------------------------------------------------------------
3151 -- -------------------------< get_sec_group_id >----------------------------
3152 -- -------------------------------------------------------------------------
3153 -- DESCRIPTION
3154 -- This function returns the security group id
3155 --
3156 FUNCTION get_sec_group_id
3157 (p_data_pump_always_call IN varchar2
3158 ,p_security_group_name IN VARCHAR2
3159 )
3160 RETURN BINARY_INTEGER;
3161 PRAGMA RESTRICT_REFERENCES (get_sec_group_id , WNDS);
3162 --
3163 -- -------------------------------------------------------------------------
3164 -- ------------------< get_security_profile_id >---------------------
3165 -- -------------------------------------------------------------------------
3166 -- DESCRIPTION
3167 -- This function returns the security_profile_id
3168 --
3169 FUNCTION get_security_profile_id
3170 (p_data_pump_always_call IN VARCHAR2
3171 ,p_security_profile_name IN VARCHAR2
3172 ,p_business_group_id IN NUMBER
3173 )
3174 RETURN BINARY_INTEGER;
3175 PRAGMA RESTRICT_REFERENCES (get_security_profile_id , WNDS);
3176 --
3177 --
3178 -- -------------------------------------------------------------------------
3179 -- --------------------< get_parent_organization_id >-----------------------
3180 -- -------------------------------------------------------------------------
3181 -- DESCRIPTION
3182 -- This function returns the organization_id
3183 --
3184 function get_parent_organization_id
3185 ( p_parent_organization_name in varchar2,
3186 p_business_group_id in number,
3187 p_effective_date in date,
3188 p_language_code in varchar2
3189 )
3190 RETURN BINARY_INTEGER;
3191 PRAGMA RESTRICT_REFERENCES (get_parent_organization_id , WNDS);
3192 --
3193 -- -------------------------------------------------------------------------
3194 -- ---------------------< get_child_organization_id >-----------------------
3195 -- -------------------------------------------------------------------------
3196 -- DESCRIPTION
3197 -- This function returns the organization_id.
3198 --
3199 function get_child_organization_id
3200 ( p_child_organization_name in varchar2,
3201 p_business_group_id in number,
3202 p_effective_date in date,
3203 p_language_code in varchar2
3204 )
3205 RETURN BINARY_INTEGER;
3206 PRAGMA RESTRICT_REFERENCES (get_child_organization_id , WNDS);
3207 --
3208 -- -------------------------------------------------------------------------
3209 -- ---------------------< get_person_extra_info_id >------------------------
3210 -- -------------------------------------------------------------------------
3211 -- DESCRIPTION
3212 -- This function returns the person_extra_info_id.
3213 --
3214 function get_person_extra_info_id
3215 (
3216 p_person_extra_info_user_key in varchar2
3217 ) return number;
3218 pragma restrict_references (get_person_extra_info_id, WNDS);
3219 --
3220 -- -------------------------------------------------------------------------
3221 -- ---------------------< get_person_extra_info_ovn >-----------------------
3222 -- -------------------------------------------------------------------------
3223 -- DESCRIPTION
3224 -- This function returns the ovn for person_extra_info_id.
3225 --
3226 function get_person_extra_info_ovn
3227 ( p_person_extra_info_user_key in varchar2
3228 ) return number;
3229 pragma restrict_references (get_person_extra_info_ovn, WNDS);
3230
3231
3232 --
3233 ------------------------- GET_EMP_FED_TAX_INF_ID -------------------------
3234 /*
3235 NAME
3236 GET_EMP_FED_TAX_INF_ID
3237 DESCRIPTION
3238 Returns a Canada federal tax Inf ID.
3239 NOTES
3240 This function returns a Canada GET_EMP_FED_TAX_INF_ID and is designed for use
3241 with the Data Pump.
3242 */
3243 function GET_EMP_FED_TAX_INF_ID
3244 (
3245 P_EMP_FED_TAX_INF_USER_KEY in varchar2
3246 ) return number;
3247 pragma restrict_references (GET_EMP_FED_TAX_INF_ID, WNDS);
3248
3249 ----------------------- GET_CA_EMP_FEDTAX_INF_OVN --------------------------
3250 /*
3251 NAME
3252 GET_CA_EMP_FEDTAX_INF_OVN
3253 DESCRIPTION
3254 Returns a tax rule Object Version Number.
3255 NOTES
3256 This returns an object version number for Canada Emp Fed tax Inf that has
3257 been created via the Data Pump engine.
3258 */
3259 function GET_CA_EMP_FEDTAX_INF_OVN
3260 (
3261 P_EMP_FED_TAX_INF_USER_KEY in varchar2,
3262 p_effective_date in date
3263 ) return number;
3264 pragma restrict_references (GET_CA_EMP_FEDTAX_INF_OVN, WNDS);
3265
3266
3267 --
3268 ------------------------- GET_EMP_PROVINCE_TAX_INF_ID -------------------------
3269 /*
3270 NAME
3271 GET_EMP_PROVINCE_TAX_INF_ID
3272 DESCRIPTION
3273 Returns a Canada Employee Province tax Inf ID.
3274 NOTES
3275 This function returns a Canada GET_EMP_PROVINCE_TAX_INF_ID and is designed
3276 for use with the Data Pump.
3277 */
3278 function GET_EMP_PROVINCE_TAX_INF_ID
3279 (
3280 P_EMP_PROV_TAX_INF_USER_KEY in varchar2
3281 ) return number;
3282 pragma restrict_references (GET_EMP_PROVINCE_TAX_INF_ID, WNDS);
3283
3284
3285 ----------------------- GET_CA_EMP_PRVTAX_INF_OVN --------------------------
3286 /*
3287 NAME
3288 GET_CA_EMP_PRVTAX_INF_OVN
3289 DESCRIPTION
3290 Returns a Canada Emp Province tax Inf Object Version Number.
3291 NOTES
3292 This returns an object version number for Canada Emp Province tax Inf that has
3293 been created via the Data Pump engine.
3294 */
3295 function GET_CA_EMP_PRVTAX_INF_OVN
3296 (
3297 P_EMP_PROV_TAX_INF_USER_KEY in varchar2,
3298 p_effective_date in date
3299 ) return number;
3300 pragma restrict_references (GET_CA_EMP_PRVTAX_INF_OVN, WNDS);
3301
3302 end hr_pump_get;