1 package hr_pump_get AUTHID CURRENT_USER as
2 /* $Header: hrdpget.pkh 120.2 2010/03/18 12:28:28 pvelvano ship $ */
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 */
362 function get_prtt_enrt_rslt_ovn
363 ( p_prtt_enrt_rslt_user_key in varchar2,
364 p_effective_date in date
365 ) return number;
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
439 ) return number;
436 /* returns a elig_dpnt object_version_number */
437 function get_elig_dpnt_ovn
438 ( p_elig_dpnt_user_key in varchar2
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
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
458 ) return number;
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
580 ( p_business_group_id in number,
577 This function returns a benfts_grp_id and is designed for use with the Data Pump.
578 */
579 function get_benfts_grp_id
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 ---------------------------
598 /*
599 NAME
600 get_pl_typ_id
601 DESCRIPTION
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);
743 NAME
740 --
741 ------------------------------ get_cvg_amt_calc_mthd_id ---------------------------
742 /*
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
761 Returns a cvg amt calc object version number.
762 */
763 function get_cvg_amt_calc_mthd_ovn
764 ( p_business_group_id in number,
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
907 --pragma restrict_references (get_comp_ref_uom_code, WNDS);
904 ( p_comp_ref_uom in varchar2,
905 p_effective_date in date
906 ) return varchar2;
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);
922
923 /* get_quald_bnf_person_id - requires user key */
924 function get_quald_bnf_person_id
925 ( p_quald_bnf_person_user_key in varchar2
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 (
1066
1063 p_person_referred_by_user_key in varchar2
1064 ) return number;
1065 pragma restrict_references (get_person_referred_by_id, WNDS);
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
1083 ----------------------- get_contact_relationship_id ---------------------------
1084 /*
1085 NAME
1086 get_contact_relationship_id
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 --
1213 p_element_name in varchar2,
1210 function get_input_value_id1
1211 (
1212 p_input_value_name1 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 --
1230 function get_input_value_id3
1231 (
1232 p_input_value_name3 in varchar2,
1233 p_element_name 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 */
1370 ) return number;
1367 function get_rate_id
1368 ( p_rate_name in varchar2,
1369 p_business_group_id in 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
1387 ) return number;
1388 pragma restrict_references (get_person_type_id, WNDS);
1389
1390
1391 /* Bug 9480965: Added new function for the newly added paramter 'p_original_person_type_id'
1392 to the procedure 'BEN_ASSIGNMENT_API.CREATE_BEN_ASG' */
1393 /* return person_type_id */
1394 ----------------------------- get_original_person_type_id ------------------------------
1395 /*
1396 NAME
1397 get_person_type_id
1398 DESCRIPTION
1399 Returns a Person Type ID.
1400 NOTES
1401 This function returns a person_type_id.
1402 */
1403 function get_original_person_type_id
1404 (
1405 p_user_person_type in varchar2,
1406 p_business_group_id in number,
1407 p_language_code in varchar2
1408 ) return number;
1409 pragma restrict_references (get_original_person_type_id, WNDS);
1410
1411 -------------------------------- get_vendor_id --------------------------------
1412 /*
1413 NAME
1414 get_vendor_id
1415 DESCRIPTION
1416 Returns a Vendor ID.
1417 NOTES
1418 This function returns a vendor_id.
1419 */
1420 function get_vendor_id
1421 (
1422 p_vendor_name in varchar2
1423 ) return number;
1424 pragma restrict_references (get_vendor_id, WNDS);
1425
1426 ------------------------ get_assignment_status_type_id ------------------------
1427 /*
1428 NAME
1429 get_assignment_status_type_id
1430 DESCRIPTION
1431 Returns an Assignment Status Type ID.
1432 NOTES
1433 This function returns an assignment_status_type_id.
1434 */
1435 function get_assignment_status_type_id
1436 (
1437 p_user_status in varchar2,
1438 p_business_group_id in number,
1439 p_language_code in varchar2
1440 ) return number;
1441 pragma restrict_references (get_assignment_status_type_id, WNDS);
1442
1443 ----------------------------- get_organization_id -----------------------------
1444 /*
1445 NAME
1446 get_organization_id
1447 DESCRIPTION
1448 Returns an Organization ID.
1449 NOTES
1450 This function returns an organization_id.
1451 */
1452 function get_organization_id
1453 (
1454 p_organization_name in varchar2,
1455 p_business_group_id in number,
1456 p_effective_date in date
1457 , p_language_code in varchar2
1458 ) return number;
1459 pragma restrict_references (get_organization_id, WNDS);
1460
1461 --------------------------- get_establishment_org_id ----------------------------
1462 /*
1463 NAME
1464 get_establishment_org_id
1465 DESCRIPTION
1466 Returns an Establishment (Organization) ID.
1467 NOTES
1468 This function returns an establishment organization_id for the
1469 assignment APIs.
1470 */
1471 function get_establishment_org_id
1472 (
1473 p_establishment_org_name in varchar2,
1474 p_business_group_id in number,
1475 p_effective_date in date
1476 , p_language_code in varchar2
1477 ) return number;
1478 pragma restrict_references (get_establishment_org_id, WNDS);
1479
1480 -------------------------- get_source_organization_id -------------------------
1481 /*
1482 NAME
1483 get_source_organization_id
1484 DESCRIPTION
1485 Returns a Source Organization ID.
1486 NOTES
1487 This function returns a source_organization_id.
1488 */
1489 function get_source_organization_id
1490 (
1491 p_source_organization_name in varchar2,
1492 p_business_group_id in number,
1493 p_effective_date in date
1494 , p_language_code in varchar2
1495 ) return number;
1496 pragma restrict_references (get_source_organization_id, WNDS);
1497
1498 --------------------------------- get_grade_id --------------------------------
1499 /*
1500 NAME
1501 get_grade_id
1502 DESCRIPTION
1503 Returns a Grade ID.
1504 NOTES
1505 This function returns a grade_id.
1506 */
1507 function get_grade_id
1508 (
1509 p_grade_name in varchar2,
1510 p_business_group_id in number,
1511 p_effective_date in date
1512 ) return number;
1513 pragma restrict_references (get_grade_id, WNDS);
1514
1515 ----------------------------- get_entry_grade_id ------------------------------
1516 /*
1517 NAME
1518 get_entry_grade_id
1519 NOTES
1520 Calls get_grade_id.
1521 */
1522 function get_entry_grade_id
1523 (
1524 p_entry_grade_name in varchar2,
1525 p_business_group_id in number,
1526 p_effective_date in date
1527 ) return number;
1531 /*
1528 pragma restrict_references (get_entry_grade_id, WNDS);
1529
1530 ------------------------------- get_position_id -------------------------------
1532 NAME
1533 get_position_id
1534 DESCRIPTION
1535 Returns a Position ID.
1536 NOTES
1537 This function returns a position_id.
1538 */
1539 function get_position_id
1540 (
1541 p_position_name in varchar2,
1542 p_business_group_id in number,
1543 p_effective_date in date
1544 ) return number;
1545 pragma restrict_references (get_position_id, WNDS);
1546
1547 ------------------------- get_successor_position_id ---------------------------
1548 /*
1549 NAME
1550 get_successor_position_id
1551 DESCRIPTION
1552 Returns a Successor Position ID.
1553 NOTES
1554 This function returns a successor_position_id.
1555 */
1556 function get_successor_position_id
1557 (
1558 p_successor_position_name in varchar2,
1559 p_business_group_id in number,
1560 p_effective_date in date
1561 ) return number;
1562 pragma restrict_references (get_successor_position_id, WNDS);
1563
1564 ------------------------- get_relief_position_id ---------------------------
1565 /*
1566 NAME
1567 get_relief_position_id
1568 DESCRIPTION
1569 Returns a Relief Position ID.
1570 NOTES
1571 This function returns a relief_position_id.
1572 */
1573 function get_relief_position_id
1574 (
1575 p_relief_position_name in varchar2,
1576 p_business_group_id in number,
1577 p_effective_date in date
1578 ) return number;
1579 pragma restrict_references (get_relief_position_id, WNDS);
1580
1581 ------------------------- get_prior_position_id ---------------------------
1582 /*
1583 NAME
1584 get_prior_position_id
1585 NOTES
1586 Calls get_position_id.
1587 */
1588 function get_prior_position_id
1589 (
1590 p_prior_position_name in varchar2,
1591 p_business_group_id in number,
1592 p_effective_date in date
1593 ) return number;
1594 pragma restrict_references (get_prior_position_id, WNDS);
1595
1596 ------------------------- get_supervisor_position_id ---------------------------
1597 /*
1598 NAME
1599 get_supervisor_position_id
1600 NOTES
1601 Calls get_position_id.
1602 */
1603 function get_supervisor_position_id
1604 (
1605 p_supervisor_position_name in varchar2,
1606 p_business_group_id in number,
1607 p_effective_date in date
1608 ) return number;
1609 pragma restrict_references (get_supervisor_position_id, WNDS);
1610
1611 --------------------------------- get_job_id ----------------------------------
1612 /*
1613 NAME
1614 get_job_id
1615 DESCRIPTION
1616 Returns a Job ID.
1617 NOTES
1618 This function returns a job_id.
1619 */
1620 function get_job_id
1621 (
1622 p_job_name in varchar2,
1623 p_effective_date in date,
1624 p_business_group_id in number
1625 ) return number;
1626 pragma restrict_references (get_job_id, WNDS);
1627
1628 ------------------------------- get_payroll_id --------------------------------
1629 /*
1630 NAME
1631 get_payroll_id
1632 DESCRIPTION
1633 Returns a Payroll ID.
1634 NOTES
1635 This function returns a payroll_id.
1636 */
1637 function get_payroll_id
1638 (
1639 p_payroll_name in varchar2,
1640 p_business_group_id in number,
1641 p_effective_date in date
1642 ) return number;
1643 pragma restrict_references (get_payroll_id, WNDS);
1644
1645 --------------------------- get_pay_freq_payroll_id ----------------------------
1646 /*
1647 NAME
1648 get_pay_freq_payroll_id
1649 NOTES
1650 Calls get_payroll_id.
1651 */
1652 function get_pay_freq_payroll_id
1653 (
1654 p_pay_freq_payroll_name in varchar2,
1655 p_business_group_id in number,
1656 p_effective_date in date
1657 ) return number;
1658 pragma restrict_references (get_pay_freq_payroll_id, WNDS);
1659
1660 ------------------------- get_location_id_update --------------------------
1661 /*
1662 NAME
1663 get_location_id_update
1664 DESCRIPTION
1665 Returns a Location ID.
1666 NOTES
1667 Calls get_location_id, but was written to allow the update_location
1668 APIs to update the location_code.
1669 The name does not end in _ID so that it's always seeded as a mapping
1670 function.
1671 */
1672 function get_location_id_update
1673 (
1674 p_existing_location_code in varchar2,
1675 p_business_group_id in number,
1676 p_language_code in varchar2
1677 ) return number;
1678 pragma restrict_references (get_location_id_update, WNDS);
1679
1680 ------------------------------ get_location_id --------------------------------
1681 /*
1682 NAME
1683 get_location_id
1684 DESCRIPTION
1685 Returns a Location ID.
1686 NOTES
1687 This function returns a location_id.
1688 */
1689 function get_location_id
1690 (
1691 p_location_code in varchar2,
1692 p_business_group_id in number,
1696 -----------------------------get_designated_receiver_id -----------------------
1693 p_language_code in varchar2
1694 ) return number;
1695 pragma restrict_references (get_location_id, WNDS);
1697 /*
1698 NAME
1699 get_designated_receiver_id
1700 DESCRIPTION
1701 Returns receiver id
1702 */
1703 function get_designated_receiver_id
1704 (
1705 p_designated_receiver_name In Varchar2,
1706 p_business_group_id In Number,
1707 p_effective_date In Date
1708 ) return number;
1709 pragma restrict_references (get_designated_receiver_id, WNDS);
1710
1711 ------------------------------ get_ship_to_location_id --------------------------------
1712 /*
1713 NAME
1714 get_ship_location_id
1715 DESCRIPTION
1716 Returns a Location ID.
1717 NOTES
1718 This function returns a location_id.
1719 */
1720 function get_ship_to_location_id
1721 (
1722 p_ship_to_location_code in varchar2,
1723 p_business_group_id in number,
1724 p_language_code in varchar2
1725 ) return number;
1726 pragma restrict_references (get_ship_to_location_id, WNDS);
1727
1728 ------------------------------ get_pay_basis_id -------------------------------
1729 /*
1730 NAME
1731 get_pay_basis_id
1732 DESCRIPTION
1733 Returns a Pay Basis ID.
1734 NOTES
1735 This function returns a pay_basis_id.
1736 */
1737 function get_pay_basis_id
1738 (
1739 p_pay_basis_name in varchar2,
1740 p_business_group_id in number
1741 ) return number;
1742 pragma restrict_references (get_pay_basis_id, WNDS);
1743
1744 ------------------------- get_recruitment_activity_id -------------------------
1745 /*
1746 NAME
1747 get_recruitment_activity_id
1748 DESCRIPTION
1749 Returns a Recruitment Activity ID.
1750 NOTES
1751 This function returns a recruitment_activity_id.
1752 */
1753 function get_recruitment_activity_id
1754 (
1755 p_recruitment_activity_name in varchar2,
1756 p_business_group_id in number,
1757 p_effective_date in date
1758 ) return number;
1759 pragma restrict_references (get_recruitment_activity_id, WNDS);
1760
1761 -------------------------------- get_vacancy_id -------------------------------
1762 /*
1763 NAME
1764 get_vacancy_id
1765 DESCRIPTION
1766 Returns a Vacancy ID.
1767 NOTES
1768 This function returns a vacancy_id. The user needs to set up the user
1769 key value.
1770 */
1771 function get_vacancy_id
1772 (
1773 p_vacancy_user_key in varchar2
1774 ) return number;
1775 pragma restrict_references (get_vacancy_id, WNDS);
1776
1777 -------------------------- get_org_payment_method_id --------------------------
1778 /*
1779 NAME
1780 get_org_payment_method_id
1781 DESCRIPTION
1782 Returns an Organization Payment Method ID.
1783 NOTES
1784 This function returns an org_payment_method_id.
1785 */
1786 function get_org_payment_method_id
1787 (
1788 p_org_payment_method_user_key in varchar2
1789 ) return number;
1790 pragma restrict_references (get_org_payment_method_id, WNDS);
1791
1792 ------------------------------ get_payee_org_id -------------------------------
1793 /*
1794 NAME
1795 get_org_payee_id
1796 DESCRIPTION
1797 Returns a Payee ID for a payee that is an organization.
1798 NOTES
1799 This function returns a payee_id.
1800 */
1801 function get_payee_org_id
1802 (
1803 p_payee_organization_name in varchar2,
1804 p_business_group_id in number,
1805 p_effective_date in date
1806 , p_language_code in varchar2
1807 ) return number;
1808 pragma restrict_references (get_payee_org_id, WNDS);
1809
1810 ----------------------------- get_payee_person_id -----------------------------
1811 /*
1812 NAME
1813 get_payee_person_id
1814 DESCRIPTION
1815 Returns a Person ID that is a person.
1816 NOTES
1817 This function returns a person_id and is designed for use
1818 with the Data Pump.
1819 */
1820 function get_payee_person_id
1821 (
1822 p_payee_person_user_key in varchar2
1823 ) return number;
1824 pragma restrict_references (get_payee_person_id, WNDS);
1825
1826 -------------------------------- get_payee_id ----------------------------------
1827 /*
1828 NAME
1829 get_payee_id
1830 DESCRIPTION
1831 Returns a Payee ID for a payee that is an organization or a person.
1832 */
1833 function get_payee_id
1834 (
1835 p_data_pump_always_call in varchar2,
1836 p_payee_type in varchar2,
1837 p_business_group_id in number,
1838 p_payee_org in varchar2 default null,
1839 p_payee_person_user_key in varchar2 default null,
1840 p_effective_date in date
1841 , p_language_code in varchar2
1842 ) return number;
1843 pragma restrict_references (get_payee_id, WNDS);
1844
1845 ----------------------- get_personal_payment_method_id ------------------------
1846 /*
1847 NAME
1848 get_personal_payment_method_id
1849 DESCRIPTION
1850 Returns a Personal Payment Method ID.
1854 function get_personal_payment_method_id
1851 NOTES
1852 This function returns a personal_payment_method_id.
1853 */
1855 (
1856 p_personal_pay_method_user_key in varchar2
1857 ) return number;
1858 pragma restrict_references (get_personal_payment_method_id, WNDS);
1859
1860 ----------------------------- get_set_of_books_id -----------------------------
1861 /*
1862 NAME
1863 get_set_of_books_id
1864 DESCRIPTION
1865 Returns a Set of Books ID.
1866 NOTES
1867 This function returns a set_of_books_id.
1868 */
1869 function get_set_of_books_id
1870 (
1871 p_set_of_books_name varchar2
1872 ) return number;
1873 pragma restrict_references (get_set_of_books_id, WNDS);
1874
1875 ------------------------------- get_tax_unit_id -------------------------------
1876 /*
1877 NAME
1878 get_tax_unit_id
1879 DESCRIPTION
1880 Returns a Tax Unit ID.
1881 NOTES
1882 This function returns a tax_unit_id.
1883 Return code of varchar2 to match API parameter type.
1884 */
1885 function get_tax_unit_id
1886 (
1887 p_tax_unit_name in varchar2,
1888 p_effective_date in date
1889 ) return varchar2;
1890 pragma restrict_references (get_tax_unit_id, WNDS);
1891
1892 ------------------------------ get_work_schedule ------------------------------
1893 /*
1894 NAME
1895 get_work_schedule
1896 DESCRIPTION
1897 Returns a user_column_id for a work schedule.
1898 NOTES
1899 This function is used to return a user_column_id when
1900 used by US API.
1901 */
1902 function get_work_schedule
1903 (
1904 p_work_schedule in varchar2,
1905 p_organization_name in varchar2,
1906 p_business_group_id in number,
1907 p_effective_date in date
1908 , p_language_code in varchar2
1909 ) return number;
1910 pragma restrict_references (get_work_schedule, WNDS);
1911
1912 --------------------------- get_eeo_1_establishment ---------------------------
1913 /*
1914 NAME
1915 get_eeo_1_establishment
1916 DESCRIPTION
1917 Returns a establishment_id.
1918 NOTES
1919 <none>
1920 */
1921 function get_eeo_1_establishment_id
1922 (
1923 p_eeo_1_establishment in varchar2,
1924 p_business_group_id in number,
1925 p_effective_date in date
1926 ) return number;
1927 pragma restrict_references (get_eeo_1_establishment_id, WNDS);
1928
1929 ------------------------- get_correspondence_language -------------------------
1930 /*
1931 NAME
1932 get_correspondence_language
1933 DESCRIPTION
1934 Returns a language code.
1935 NOTES
1936 Uses the FND_LANGUAGES table. If p_correspondance_language cannot be
1937 matched, it is assumed that the user entered the language code.
1938 */
1939 function get_correspondence_language
1940 (
1941 p_correspondence_language varchar2
1942 ) return varchar2;
1943 pragma restrict_references (get_correspondence_language, WNDS);
1944
1945 ------------------------------ get_id_flex_num ---------------------------------
1946 /*
1947 NAME
1948 get_id_flex_num
1949 DESCRIPTION
1950 Returns an id_flex_num for a keyflex structure.
1951 NOTES
1952 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
1953 */
1954 function get_id_flex_num
1955 (
1956 p_id_flex_num_user_key varchar2
1957 ) return number;
1958 pragma restrict_references (get_id_flex_num, WNDS);
1959
1960 ----------------------------- get_program_application_id ----------------------
1961 /*
1962 NAME
1963 get_program_application_id
1964 DESCRIPTION
1965 Returns a Program Application ID.
1966 NOTES
1967 Standard who column.
1968 */
1969 function get_program_application_id return number;
1970 pragma restrict_references (get_program_application_id, WNDS);
1971
1972 --------------------------------- get_program_id ------------------------------
1973 /*
1974 NAME
1975 get_program_id
1976 DESCRIPTION
1977 Returns a Program ID.
1978 NOTES
1979 Standard who column.
1980 */
1981 function get_program_id return number;
1982 pragma restrict_references (get_program_id, WNDS);
1983
1984 --------------------------------- get_request_id ------------------------------
1985 /*
1986 NAME
1987 get_request_id
1988 DESCRIPTION
1989 Returns a Request ID.
1990 NOTES
1991 Standard who column.
1992 */
1993 function get_request_id return number;
1994 pragma restrict_references (get_request_id, WNDS);
1995
1996 --------------------------------- get_creator_id ------------------------------
1997 /*
1998 NAME
1999 get_creator_id
2000 DESCRIPTION
2001 Returns a Creator ID.
2002 NOTES
2003 Standard who column.
2004 */
2005 function get_creator_id return number;
2006 pragma restrict_references (get_creator_id, WNDS);
2007
2008 ----------------------------- get_gr_grade_rule_id --------------------------------
2009 /*
2010 NAME
2011 get_gr_grade_rule_id
2012 get_pp_grade_rule_id
2013 DESCRIPTION
2017 the grade name to get the grade_rule_id.
2014 Functions returning Grade Rule ID.
2015 get_pp_grade_rule_id uses the progression (spinal) point and pay scale
2016 (parent spine) name to get the grade_rule_id. get_gr_grade_rule_id uses
2018 NOTES
2019 get_gr_grade_rule_id is designed for use with the HR GRADE API.
2020 get_pp_grade_rule_id is designed for use with the HR PAY SCALE API.
2021 */
2022 function get_gr_grade_rule_id
2023 (
2024 p_grade_name in varchar2,
2025 p_rate_name in varchar2,
2026 p_business_group_id in number,
2027 p_effective_date in date
2028 )
2029 return number;
2030 pragma restrict_references (get_gr_grade_rule_id, WNDS);
2031 --
2032 function get_pp_grade_rule_id
2033 (
2034 p_progression_point in varchar2,
2035 p_pay_scale in varchar2,
2036 p_rate_name in varchar2,
2037 p_business_group_id in number,
2038 p_effective_date in date
2039 )
2040 return number;
2041 pragma restrict_references (get_pp_grade_rule_id, WNDS);
2042
2043 function get_ar_grade_rule_id
2044 (
2045 p_rate_name in varchar2,
2046 p_business_group_id in number,
2047 p_effective_date in date
2048 )
2049 return number;
2050 pragma restrict_references (get_pp_grade_rule_id, WNDS);
2051 --------------------------- get_organization_structure_id --------------------------------
2052 /*
2053 NAME
2054 get_organization_structure_id
2055 DESCRIPTION
2056 Function returning Organization Structure ID
2057 */
2058 function get_organization_structure_id
2059 (
2060 p_name in varchar2,
2061 p_business_group_id in number
2062 )
2063 return number;
2064 pragma restrict_references (get_organization_structure_id, WNDS);
2065
2066 --------------------------- get_org_str_ver_id --------------------------------
2067 /*
2068 NAME
2069 get_org_str_ver_id
2070 DESCRIPTION
2071 Function returning Organization Structure Version ID
2072 */
2073 function get_org_str_ver_id
2074 (
2075 p_business_group_id in number,
2076 p_organization_structure_id in number,
2077 p_date_from in date,
2078 p_version_number in number
2079 )
2080 return number;
2081 pragma restrict_references (get_org_str_ver_id, WNDS);
2082
2083 --------------------------- get_spinal_point_id --------------------------------
2084 /*
2085 NAME
2086 get_spinal_point_id
2087 DESCRIPTION
2088 Function returning Spinal Point ID.
2089 get_spinal_point_id uses the progression (spinal) point and pay scale
2090 (parent spine) name to get the spinal_point_id.
2091 */
2092 function get_spinal_point_id
2093 (
2094 p_progression_point in varchar2,
2095 p_pay_scale in varchar2,
2096 p_business_group_id in number,
2097 p_effective_date in date
2098 )
2099 return number;
2100 pragma restrict_references (get_spinal_point_id, WNDS);
2101
2102 -------------------------------- get_country -----------------------------------
2103 /*
2104 NAME
2105 get_country
2106 DESCRIPTION
2107 Function returning a territory code when supplied a territory short
2108 name. If the short name does not match, the code assumes that
2109 the user supplied the code and returns p_country.
2110 */
2111 function get_country( p_country in varchar2 ) return varchar2;
2112 pragma restrict_references (get_country, WNDS);
2113
2114 ------------------------- get_period_of_service_id -----------------------------
2115 /*
2116 NAME
2117 get_at_period_of_service_id
2118 get_fp_period_of_service_id
2119 get_ut_period_of_service_id
2120 DESCRIPTION
2121 Functions returning Period Of Service ID.
2122 get_at_period_of_service_id gets the period_of_service_id in the case
2123 where the actual termination date has not been set.
2124 get_fp_period_of_service_id gets the period_of_service_id in the case
2125 where the actual termination date has been set, but the final process
2126 date has not been set.
2127 get_ut_period_of_service_id gets the period of service for a effective date
2128 NOTES
2129 get_at_period_of_service_id is designed for use with
2130 hr_ex_employee.actual_termination_emp.
2131 get_fp_period_of_service_id is designed for use with
2132 hr_ex_employee.final_process_emp.
2133 get_ut_period_of_service_id is designed for use with
2134 hr_ex_employee.update_term_details_emp.
2135 */
2136 function get_at_period_of_service_id
2137 (
2138 p_person_user_key in varchar2,
2139 p_business_group_id in number
2140 )
2141 return number;
2142 pragma restrict_references (get_at_period_of_service_id, WNDS);
2143 function get_fp_period_of_service_id
2144 (
2145 p_person_user_key in varchar2,
2146 p_business_group_id in number
2147 )
2148 return number;
2149 pragma restrict_references (get_fp_period_of_service_id, WNDS);
2150
2151 /* Added for 11i,Rvydyana,02-DEC-1999 */
2152 function get_ut_period_of_service_id
2153 (
2154 p_person_user_key in varchar2,
2155 p_effective_date in date,
2156 p_business_group_id in number
2157 )
2158 return number;
2159 pragma restrict_references (get_ut_period_of_service_id, WNDS);
2160
2164 get_special_ceiling_step_id
2161 ------------------------ get_special_ceiling_step_id ---------------------------
2162 /*
2163 NAME
2165 DESCRIPTION
2166 Returns an id_flex_num for a keyflex structure.
2167 NOTES
2168 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2169 */
2170 function get_special_ceiling_step_id
2171 (
2172 p_special_ceilin_step_user_key varchar2
2173 ) return number;
2174 pragma restrict_references (get_special_ceiling_step_id, WNDS);
2175
2176 ---------------------------- get_entry_step_id -------------------------------
2177 /*
2178 NAME
2179 get_entry_step_id
2180 DESCRIPTION
2181 Returns a Spinal Point Step ID.
2182 NOTES
2183 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2184 */
2185 function get_entry_step_id
2186 (
2187 p_entry_step_user_key in varchar2
2188 ) return number;
2189 pragma restrict_references (get_entry_step_id, WNDS);
2190
2191 ---------------------------- get_entry_grade_rule_id -------------------------------
2192 /*
2193 NAME
2194 get_entry_grade_rule_id
2195 NOTES
2196 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2197 */
2198 function get_entry_grade_rule_id
2199 (
2200 p_entry_grade_rule_user_key in varchar2
2201 ) return number;
2202 pragma restrict_references (get_entry_grade_rule_id, WNDS);
2203
2204 ----------------------- get_availability_status_id ---------------------------
2205 /*
2206 NAME
2207 get_availability_status_id
2208 DESCRIPTION
2209 Function returning Availability Status ID.
2210 */
2211 function get_availability_status_id
2212 (p_shared_type_name in varchar2
2213 ,p_system_type_cd in varchar2
2214 ,p_business_group_id in number
2215 ,p_language_code in varchar2
2216 ) return number ;
2217 pragma restrict_references (get_availability_status_id, WNDS);
2218
2219 ------------------------ get_default_code_comb_id ------------------------------
2220 /*
2221 NAME
2222 get_default_code_comb_id
2223 DESCRIPTION
2224 Returns the default_code_comb_id.
2225 NOTES
2226 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2227 */
2228 function get_default_code_comb_id
2229 (
2230 p_default_code_comb_user_key varchar2
2231 ) return number;
2232 pragma restrict_references (get_default_code_comb_id, WNDS);
2233
2234 ------------------------ get_phone_id -----------------------------------------
2235 /*
2236 NAME
2237 get_phone_id
2238 DESCRIPTION
2239 Returns the phone_id.
2240 NOTES
2241 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2242 */
2243 /* Added for 11i - Rvydyana - 06-DEC-1999 */
2244 function get_phone_id
2245 (
2246 p_phone_user_key in varchar2
2247 ) return number;
2248 pragma restrict_references (get_phone_id, WNDS);
2249 ------------------------ get_job_group_id -----------------------------------------
2250 /*
2251 NAME
2252 get_job_group_id
2253 DESCRIPTION
2254 Returns the job_group_id.
2255 NOTES
2256 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2257 */
2258 function get_job_group_id
2259 (
2260 p_job_group_user_key in varchar2
2261 ) return number;
2262 pragma restrict_references (get_job_group_id, WNDS);
2263 ------------------------ get_loc_id -----------------------------------------
2264 /*
2265 NAME
2266 get_loc_id
2267 DESCRIPTION
2268 sets p_location_id as a user key
2269 NOTES
2270 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2271 */
2272 function get_loc_id
2273 (
2274 p_location_user_key in varchar2
2275 ) return number;
2276 pragma restrict_references (get_loc_id, WNDS);
2277 ------------------------ get_org_structure_id -----------------------------------------
2278 /*
2279 NAME
2280 get_org_structure_id
2281 DESCRIPTION
2282 sets p_organization_structure_id as a user key
2283 NOTES
2284 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2285 */
2286 function get_org_structure_id
2287 (
2288 p_org_structure_user_key in varchar2
2289 ) return number;
2290 pragma restrict_references (get_org_structure_id, WNDS);
2291 ------------------------ get_org_str_version_id -----------------------------------------
2292 /*
2293 NAME
2294 get_org_str_version_id
2295 DESCRIPTION
2296 sets p_org_structure_version_id as a user key
2297 NOTES
2298 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2299 */
2300 function get_org_str_version_id
2301 (
2302 p_org_str_version_user_key in varchar2
2303 ) return number;
2304 pragma restrict_references (get_org_str_version_id, WNDS);
2305 ------------------------ get_org_id -----------------------------------------
2306 /*
2307 NAME
2308 get_org_id
2309 DESCRIPTION
2310 sets p_organization_id as a user key
2311 NOTES
2312 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2313 */
2314 function get_org_id
2315 (
2316 p_org_user_key in varchar2
2317 ) return number;
2321 NAME
2318 pragma restrict_references (get_org_id, WNDS);
2319 ------------------------ get_grade_rule_id -----------------------------------------
2320 /*
2322 get_grade_rule_id
2323 DESCRIPTION
2324 Returns the grade_rule_id.
2325 NOTES
2326 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2327 */
2328 function get_grade_rule_id
2329 (
2330 p_grade_rule_user_key in varchar2
2331 ) return number;
2332 pragma restrict_references (get_grade_rule_id, WNDS);
2333 ------------------------ get_benchmark_job_id -----------------------------------------
2334 /*
2335 NAME
2336 get_benchmark_job_id
2337 DESCRIPTION
2338 Returns the benchmark_job_id.
2339 NOTES
2340 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2341 */
2342 function get_benchmark_job_id
2343 (
2344 p_benchmark_job_user_key in varchar2
2345 ) return number;
2346 pragma restrict_references (get_benchmark_job_id, WNDS);
2347 ------------------------ get_role_id -----------------------------------------
2348 /*
2349 NAME
2350 get_role_id
2351 DESCRIPTION
2352 Returns the role_id.
2353 NOTES
2354 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2355 */
2356 function get_role_id
2357 (
2358 p_role_user_key in varchar2
2359 ) return number;
2360 pragma restrict_references (get_role_id, WNDS);
2361
2362 ------------------------ get_grade_ladder_pgm_id ------------------------------
2363 /*
2364 NAME
2365 get_grade_ladder_pgm_id
2366 DESCRIPTION
2367 Returns the grade_ladder_pgm_id.
2368 NOTES
2369 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2370 */
2371 function get_grade_ladder_pgm_id
2372 (
2373 p_grade_ladder_name in varchar2
2374 ,p_business_group_id in number
2375 ,p_effective_date in date
2376 ) return number;
2377 pragma restrict_references (get_grade_ladder_pgm_id, WNDS);
2378
2379 ------------------------ get_supervisor_assignment_id ------------------------
2380 /*
2381 NAME
2382 get_supervisor_assignment_id
2383 DESCRIPTION
2384 Returns the supervisor_assignment_id.
2385 NOTES
2386 Uses the HR_PUMP_BATCH_LINES_USER_KEY table which the user must seed.
2387 */
2388 function get_supervisor_assignment_id
2389 (
2390 p_svr_assignment_user_key in varchar2
2391 ) return number;
2392 pragma restrict_references (get_supervisor_assignment_id, WNDS);
2393
2394 /*--------------------- get_parent_spine_id ----------------------------------*/
2395 function get_parent_spine_id
2396 (
2397 p_parent_spine in varchar2,
2398 p_business_group_id in number
2399 )
2400 return number;
2401 /*--------------------- get_ceiling_step_id ----------------------------------*/
2402 function get_ceiling_step_id
2403 (
2404 p_ceiling_point in varchar2,
2405 p_business_group_id in number,
2406 p_effective_date in date
2407 )
2408 return number;
2409 /*---------------------------------------------------------------------------*/
2410 /*------------------- get object version number functions -------------------*/
2411 /*---------------------------------------------------------------------------*/
2412
2413 ---------------------- get_collective_agreement_ovn ------------------------
2414 /*
2415 NAME
2416 get_collective_agreement_ovn
2417 DESCRIPTION
2418 Returns a Collective Agreement object version number.
2419 */
2420 function get_collective_agreement_ovn
2421 (p_business_group_id in number
2422 ,p_cagr_name in varchar2
2423 ,p_effective_date in date
2424 ) return number;
2425 pragma restrict_references (get_collective_agreement_ovn, WNDS);
2426
2427 ------------------------------- get_contract_ovn ---------------------------
2428 /*
2429 NAME
2430 get_contract_ovn
2431 DESCRIPTION
2432 Returns a Contract object version number.
2433 */
2434 function get_contract_ovn
2435 (p_contract_user_key in varchar2
2436 ,p_effective_date in date
2437 ) return number;
2438 pragma restrict_references (get_contract_ovn, WNDS);
2439
2440 ----------------------------- get_establishment_ovn ---------------------------
2441 /*
2442 NAME
2443 get_establishment_ovn
2444 DESCRIPTION
2445 Returns an Establishment object version number.
2446 */
2447 function get_establishment_ovn
2448 (p_establishment_name in varchar2
2449 ,p_location in varchar2
2450 ) return number;
2451 pragma restrict_references (get_establishment_ovn, WNDS);
2452
2453 ----------------------- get_us_emp_fed_tax_rule_ovn --------------------------
2454 /*
2455 NAME
2456 get_us_emp_fed_tax_rule_ovn
2457 DESCRIPTION
2458 Returns a tax rule Object Version Number.
2459 NOTES
2460 This returns an object version number for a tax rule that has
2461 been created via the Data Pump engine.
2462 */
2463 function get_us_emp_fed_tax_rule_ovn
2464 (
2465 p_emp_fed_tax_rule_user_key in varchar2,
2466 p_effective_date in date
2467 ) return number;
2468 pragma restrict_references (get_us_emp_fed_tax_rule_ovn, WNDS);
2469
2473 NAME
2470
2471 ----------------------- get_us_emp_state_tax_rule_ovn --------------------------
2472 /*
2474 get_us_emp_state_tax_rule_ovn
2475 DESCRIPTION
2476 Returns a tax rule Object Version Number.
2477 NOTES
2478 This returns an object version number for a tax rule that has
2479 been created via the Data Pump engine.
2480 */
2481 function get_us_emp_state_tax_rule_ovn
2482 (
2483 p_emp_state_tax_rule_user_key in varchar2,
2484 p_effective_date in date
2485 ) return number;
2486 pragma restrict_references (get_us_emp_state_tax_rule_ovn, WNDS);
2487
2488 ----------------------- get_us_emp_county_tax_rule_ovn --------------------------
2489 /*
2490 NAME
2491 get_us_emp_county_tax_rule_ovn
2492 DESCRIPTION
2493 Returns a tax rule Object Version Number.
2494 NOTES
2495 This returns an object version number for a tax rule that has
2496 been created via the Data Pump engine.
2497 */
2498 function get_us_emp_county_tax_rule_ovn
2499 (
2500 p_emp_county_tax_rule_user_key in varchar2,
2501 p_effective_date in date
2502 ) return number;
2503 pragma restrict_references (get_us_emp_county_tax_rule_ovn, WNDS);
2504
2505 ----------------------- get_us_emp_city_tax_rule_ovn --------------------------
2506 /*
2507 NAME
2508 get_us_emp_city_tax_rule_ovn
2509 DESCRIPTION
2510 Returns a tax rule Object Version Number.
2511 NOTES
2512 This returns an object version number for a tax rule that has
2513 been created via the Data Pump engine.
2514 */
2515 function get_us_emp_city_tax_rule_ovn
2516 (
2517 p_emp_city_tax_rule_user_key in varchar2,
2518 p_effective_date in date
2519 ) return number;
2520 pragma restrict_references (get_us_emp_city_tax_rule_ovn, WNDS);
2521
2522 --------------------------------- get_per_ovn ---------------------------------
2523 /*
2524 NAME
2525 get_per_ovn
2526 DESCRIPTION
2527 Returns a Person Object Version Number.
2528 NOTES
2529 This returns an object version number for a person that has
2530 been created via the Data Pump engine.
2531 */
2532 function get_per_ovn
2533 (
2534 p_person_user_key in varchar2,
2535 p_effective_date in date
2536 ) return number;
2537 pragma restrict_references (get_per_ovn, WNDS);
2538
2539 --------------------------------- get_asg_ovn ---------------------------------
2540 /*
2541 NAME
2542 get_asg_ovn
2543 DESCRIPTION
2544 Returns an Assignment Object Version Number.
2545 NOTES
2546 This returns an object version number for an assignment that has
2547 been created via the Data Pump engine.
2548 */
2549 function get_asg_ovn
2550 (
2551 p_assignment_user_key in varchar2,
2552 p_effective_date in date
2553 ) return number;
2554 pragma restrict_references (get_asg_ovn, WNDS);
2555
2556 --------------------------------- get_adr_ovn ---------------------------------
2557 /*
2558 NAME
2559 get_adr_ovn
2560 DESCRIPTION
2561 Returns an Address Object Version Number.
2562 NOTES
2563 This returns an object version number for an address that has
2564 been created via the Data Pump engine.
2565 */
2566 function get_adr_ovn
2567 (
2568 p_address_user_key in varchar2,
2569 p_effective_date in date
2570 ) return number;
2571 pragma restrict_references (get_adr_ovn, WNDS);
2572
2573 --------------------------------- get_loc_ovn ---------------------------------
2574 /*
2575 NAME
2576 get_loc_ovn
2577 DESCRIPTION
2578 Returns a Location Object Version Number.
2579 NOTES
2580 Returns an object version number for a location.
2581 This function can be used outside the data pump.
2582 */
2583 function get_loc_ovn
2584 (
2585 p_location_code in varchar2
2586 ) return number;
2587 pragma restrict_references (get_loc_ovn, WNDS);
2588
2589 --------------------------------- get_org_str_ovn ------------------------------
2590 /*
2591 NAME
2592 get_org_str_ovn
2593 DESCRIPTION
2594 Returns an Organization Structure Object Version Number.
2595 NOTES
2596 Returns an object version number for an organization strucutre.
2597 This function can be used outside the data pump.
2598 */
2599 function get_org_str_ovn
2600 (
2601 p_name in varchar2,
2602 p_business_group_id in number
2603 ) return number;
2604 pragma restrict_references (get_org_str_ovn, WNDS);
2605
2606 --------------------------------- get_org_str_ver_ovn ------------------------------
2607 /*
2608 NAME
2609 get_org_str_ver_ovn
2610 DESCRIPTION
2611 Returns an Organization Structure Version Object Version Number.
2612 NOTES
2613 Returns an object version number for an organization strucutre version.
2614 This function can be used outside the data pump.
2615 */
2616 function get_org_str_ver_ovn
2617 (
2618 p_business_group_id in number,
2619 p_organization_structure_id in number,
2620 p_date_from in date,
2621 p_version_number in number
2622 ) return number;
2623 pragma restrict_references (get_org_str_ver_ovn, WNDS);
2627 get_org_ovn
2624 --------------------------------- get_org_ovn ------------------------------
2625 /*
2626 NAME
2628 DESCRIPTION
2629 Returns an Organization Object Version Number.
2630 NOTES
2631 Returns an object version number for an organization.
2632 This function can be used outside the data pump.
2633 */
2634 function get_org_ovn
2635 (
2636 p_business_group_id in number,
2637 p_organization_name in varchar2,
2638 p_language_code in varchar2
2639 ) return number;
2640 pragma restrict_references (get_org_ovn, WNDS);
2641 --------------------------------- get_job_ovn ---------------------------------
2642 /*
2643 NAME
2644 get_job_ovn
2645 DESCRIPTION
2646 Returns a Job Object Version Number.
2647 NOTES
2648 Returns an object version number for a job.
2649 This function can be used outside the data pump.
2650 */
2651 function get_job_ovn
2652 (
2653 p_job_name in varchar2,
2654 p_effective_date in date,
2655 p_business_group_id in number
2656 ) return number;
2657 pragma restrict_references (get_job_ovn, WNDS);
2658
2659 --------------------------------- get_position_definition_id ---------------------------------
2660 /*
2661 NAME
2662 get_pos_ovn
2663 DESCRIPTION
2664 Returns a Position Object Version Number.
2665 NOTES
2666 Returns an object version number for a position.
2667 This function can be used outside the data pump.
2668 */
2669 function get_position_definition_id
2670 (
2671 p_position_name in varchar2,
2672 p_business_group_id in number,
2673 p_effective_date in date
2674 ) return number;
2675 pragma restrict_references (get_position_definition_id, WNDS);
2676 --------------------------------- get_pos_ovn ---------------------------------
2677 /*
2678 NAME
2679 get_pos_ovn
2680 DESCRIPTION
2681 Returns a Position Object Version Number.
2682 NOTES
2683 Returns an object version number for a position.
2684 This function can be used outside the data pump.
2685 */
2686 function get_pos_ovn
2687 (
2688 p_position_name in varchar2,
2689 p_business_group_id in number,
2690 p_effective_date in date
2691 ) return number;
2692 pragma restrict_references (get_pos_ovn, WNDS);
2693
2694 -------------------------------- get_ppm_ovn ----------------------------------
2695 /*
2696 NAME
2697 get_ppm_ovn
2698 DESCRIPTION
2699 Returns a Personal Payment Method Object Version Number.
2700 NOTES
2701 This function returns a person payment method ovn.
2702 */
2703 function get_ppm_ovn
2704 (
2705 p_personal_pay_method_user_key in varchar2,
2706 p_effective_date in date
2707 ) return number;
2708 pragma restrict_references (get_ppm_ovn, WNDS);
2709
2710 --------------------------- get_element_entry_ovn ------------------------------
2711 /*
2712 NAME
2713 get_element_entry_ovn
2714 DESCRIPTION
2715 Functions returning Element Entry Object Version Number.
2716 */
2717 function get_element_entry_ovn
2718 (
2719 p_element_entry_user_key in varchar2,
2720 p_effective_date in date
2721 ) return number;
2722 pragma restrict_references (get_element_entry_ovn, WNDS);
2723
2724 ---------------------------- get_grade_rule_ovn --------------------------------
2725 /*
2726 NAME
2727 get_gr_grade_rule_ovn
2728 get_pp_grade_rule_ovn
2729 DESCRIPTION
2730 Functions returning Grade Rule Object Version Number.
2731 get_pp_grade_rule_id uses the progression (spinal) point and pay scale
2732 (parent spine) name to get the grade rule object version number.
2733 get_gr_grade_rule_id uses the grade name to get the object version number.
2734 NOTES
2735 get_gr_grade_rule_id is designed for use with the HR GRADE API.
2736 get_pp_grade_rule_id is designed for use with the HR PAY SCALE API.
2737 */
2738 function get_gr_grade_rule_ovn
2739 (
2740 p_grade_name in varchar2,
2741 p_rate_name in varchar2,
2742 p_business_group_id in number,
2743 p_effective_date in date
2744 )
2745 return number;
2746 pragma restrict_references (get_gr_grade_rule_ovn, WNDS);
2747 --
2748 function get_pp_grade_rule_ovn
2749 (
2750 p_progression_point in varchar2,
2751 p_pay_scale in varchar2,
2752 p_rate_name in varchar2,
2753 p_business_group_id in number,
2754 p_effective_date in date
2755 )
2756 return number;
2757 pragma restrict_references (get_pp_grade_rule_ovn, WNDS);
2758
2759 ------------------------- get_period_of_service_ovn-----------------------------
2760 /*
2761 NAME
2762 get_at_period_of_service_ovn
2763 get_fp_period_of_service_ovn
2764 get_ut_period_of_service_ovn
2765 DESCRIPTION
2766 Functions returning Period Of Service Object Version Number.
2767 get_at_period_of_service_id gets the period_of_service object version
2768 number in the case where the actual termination date has not been set.
2769 get_at_period_of_service_id gets the period_of_service object version
2770 number in the case where the actual termination date has been set, but
2774 NOTES
2771 the final process date has not been set.
2772 get_ut_period_of_service_id gets the period_of_service object version
2773 number for a period_of_service_id for a effective date
2775 get_at_period_of_service_ovn is designed for use with
2776 hr_ex_employee.actual_termination_emp.
2777 get_fp_period_of_service_ovn is designed for use with
2778 hr_ex_employee.final_process_emp.
2779 get_ut_period_of_service_ovn is designed for use with
2780 hr_ex_employee.update_term_details_emp.
2781 */
2782 function get_at_period_of_service_ovn
2783 (
2784 p_person_user_key in varchar2,
2785 p_business_group_id in number
2786 )
2787 return number;
2788 pragma restrict_references (get_at_period_of_service_ovn, WNDS);
2789 function get_fp_period_of_service_ovn
2790 (
2791 p_person_user_key in varchar2,
2792 p_business_group_id in number
2793 )
2794 return number;
2795 pragma restrict_references (get_fp_period_of_service_ovn, WNDS);
2796
2797 /* Added for 11i,Rvydyana,02-DEC-1999 */
2798 function get_ut_period_of_service_ovn
2799 (
2800 p_person_user_key in varchar2,
2801 p_effective_date in date,
2802 p_business_group_id in number
2803 )
2804 return number;
2805 pragma restrict_references (get_ut_period_of_service_ovn, WNDS);
2806
2807 /* This function is used to derive the phone ovn for a phone user key */
2808 /* Added for 11i,Rvydyana,06-DEC-1999 */
2809 function get_phn_ovn
2810 (
2811 p_phone_user_key in varchar2
2812 ) return number;
2813 pragma restrict_references (get_phn_ovn, WNDS);
2814 --
2815 /* This function is used to derive the job group ovn for a job group user key */
2816 function get_jgr_ovn
2817 (
2818 p_job_group_user_key in varchar2
2819 ) return number;
2820 pragma restrict_references (get_jgr_ovn, WNDS);
2821 --
2822 /* This function is used to derive the role ovn for a role user key */
2823 function get_rol_ovn
2824 (
2825 p_role_user_key in varchar2
2826 ) return number;
2827 pragma restrict_references (get_rol_ovn, WNDS);
2828
2829 /*-------------- returns a pay scale object version number --------------------*/
2830 function get_pay_scale_ovn
2831 (
2832 p_pay_scale in varchar2,
2833 p_business_group_id in number
2834 ) return number;
2835 /*-------------- returns a preogresion point object version number ------------*/
2836 function get_progression_point_ovn
2837 (
2838 p_point in varchar2,
2839 p_business_group_id in number
2840 ) return number;
2841 /*-------------- returns a grade scale object version number ------------*/
2842 function get_grade_scale_ovn
2843 (
2844 p_grade in varchar2,
2845 p_pay_scale in varchar2,
2846 p_effective_date in date,
2847 p_business_group_id in number
2848 ) return number;
2849 /*-------------- returns a grade step object version number ------------*/
2850 function get_grade_step_ovn
2851 (
2852 p_point in varchar2,
2853 p_sequence in number,
2854 p_effective_date in date,
2855 p_business_group_id in number
2856 ) return number;
2857
2858 /*---------------------------------------------------------------------------*/
2859 /*----------------------- other special get functions -----------------------*/
2860 /*---------------------------------------------------------------------------*/
2861
2862 ------------------------------ get_change_reason ------------------------------
2863 /*
2864 NAME
2865 get_change_reason
2866 DESCRIPTION
2867 Returns the lookup code for change reason.
2868 NOTES
2869 This function is used to get the change reason lookup code
2870 because the lookup type is dependent on the type of
2871 assignment. Therefore, need to pass the assignment
2872 parameter information as well.
2873 If the change reason cannot be matched as a lookup meaning
2874 the code assumes that the user entered the lookup code
2875 directly.
2876 */
2877 function get_change_reason
2878 (
2879 p_change_reason in varchar2,
2880 p_assignment_user_key in varchar2,
2881 p_effective_date in date,
2882 p_language_code in varchar2
2883 ) return varchar2;
2884 --pragma restrict_references (get_change_reason, WNDS);
2885
2886 ------------------------------- get_lookup_code -------------------------------
2887 /*
2888 NAME
2889 get_lookup_code
2890 DESCRIPTION
2891 Returns the lookup code for a lookup type and meaning. If it cannot
2892 match the meaning, it will assume that p_meaning_or_code holds the
2893 lookup code and return p_meaning_or_code.
2894 NOTES
2895 This function designed to be called from the wrapper
2896 functions.
2897 */
2898 function get_lookup_code
2899 (
2900 p_meaning_or_code in varchar2,
2901 p_lookup_type in varchar2,
2902 p_effective_date in date default null,
2903 p_language_code in varchar2 default null
2904 ) return varchar2;
2905 --pragma restrict_references (get_lookup_code, WNDS);
2906
2907 --------------------------------- gl ----------------------------------------
2908 /*
2909 NAME
2910 gl
2911 DESCRIPTION
2912 Shortened name to save space for get_lookup_code call in wrapper
2916 (
2913 functions.
2914 */
2915 function gl
2917 p_meaning_or_code in varchar2,
2918 p_lookup_type in varchar2,
2919 p_effective_date in date default null,
2920 p_language_code in varchar2 default null
2921 ) return varchar2;
2922 /* return people_group_id */
2923 function get_people_group_id
2924 (
2925 p_people_group_user_name in varchar2,
2926 p_effective_date in date
2927 ) return number;
2928 /* return absence_attendance_type_id */
2929 function get_absence_attendance_type_id
2930 (
2931 p_aat_user_name in varchar2,
2932 p_business_group_id in number,
2933 p_effective_date in date
2934 ) return number;
2935 /* return SOFT_CODING_KEYFLEX_ID */
2936 function GET_SOFT_CODING_KEYFLEX_ID
2937 (
2938 p_con_seg_user_name in varchar2,
2939 p_effective_date in date
2940 ) return number;
2941 --pragma restrict_references (gl, WNDS);
2942 /* return pk_id for ben_prtt_rt_val table*/
2943 function get_pk_id
2944 (
2945 p_pk_name in varchar2
2946 ) return number
2947
2948 ;
2949
2950
2951 /* Bug 3275173 --get object version number -----------*/
2952 function get_fed_tax_rule_ovn
2953 (
2954 p_emp_fed_tax_rule_user_key in varchar2,
2955 p_effective_date in date
2956 ) return number;
2957
2958
2959 --
2960 -- Bug 3783381 -- get object versionn number for state, county and city
2961 --
2962
2963 function get_state_tax_rule_ovn
2964 (
2965 p_emp_state_tax_rule_user_key in varchar2,
2966 p_effective_date in date
2967 ) return number;
2968 --
2969 function get_county_tax_rule_ovn
2970 (
2971 p_emp_county_tax_rule_user_key in varchar2,
2972 p_effective_date in date
2973 ) return number;
2974 --
2975 function get_city_tax_rule_ovn
2976 (
2977 p_emp_city_tax_rule_user_key in varchar2,
2978 p_effective_date in date
2979 ) return number;
2980
2981 --
2982 --
2983 --
2984
2985
2986 -- -------------------------------------------------------------------------
2987 -- --------------------< get_cpn_ovn >--------------------------------
2988 -- -------------------------------------------------------------------------
2989 -- DESCRIPTION
2990 -- This function returns the
2991 --
2992 FUNCTION get_cpn_ovn
2993 (p_data_pump_always_call IN varchar2
2994 ,p_competence_name IN VARCHAR2
2995 ,p_business_group_id IN NUMBER)
2996 RETURN BINARY_INTEGER;
2997 PRAGMA RESTRICT_REFERENCES (get_cpn_ovn , WNDS);
2998 -- -------------------------------------------------------------------------
2999 -- --------------------< get_competence_id >--------------------------------
3000 -- -------------------------------------------------------------------------
3001 -- DESCRIPTION
3002 -- This function returns the
3003 --
3004 FUNCTION get_competence_id
3005 (p_data_pump_always_call IN varchar2
3006 ,p_competence_name IN VARCHAR2
3007 ,p_business_group_id IN NUMBER)
3008 RETURN BINARY_INTEGER;
3009 PRAGMA RESTRICT_REFERENCES (get_competence_id , WNDS);
3010 -- -------------------------------------------------------------------------
3011 -- ------------< get_parent_comp_element_id >-------------------------
3012 -- -------------------------------------------------------------------------
3013 -- DESCRIPTION
3014 -- This function returns the
3015 --
3016 FUNCTION get_parent_comp_element_id
3017 RETURN BINARY_INTEGER;
3018 -- -------------------------------------------------------------------------
3019 -- ----------------< get_qualification_type_id >-------------------------
3020 -- -------------------------------------------------------------------------
3021 -- DESCRIPTION
3022 -- This function returns the
3023 --
3024 FUNCTION get_qualification_type_id
3025 (p_data_pump_always_call IN varchar2
3026 ,p_qualification_type_name IN VARCHAR2
3027 )
3028 RETURN BINARY_INTEGER;
3029 PRAGMA RESTRICT_REFERENCES (get_qualification_type_id , WNDS);
3030 -- -------------------------------------------------------------------------
3031 -- --------------------< get_cpo_ovn >--------------------------------
3032 -- -------------------------------------------------------------------------
3033 -- DESCRIPTION
3034 -- This function returns the
3035 --
3036 FUNCTION get_cpo_ovn
3037 (p_data_pump_always_call IN varchar2
3038 ,p_outcome_name IN VARCHAR2
3039 )
3040 RETURN BINARY_INTEGER;
3041 PRAGMA RESTRICT_REFERENCES (get_cpo_ovn , WNDS);
3042 -- -------------------------------------------------------------------------
3043 -- -------------------------< get_outcome_id >---------------------------
3044 -- -------------------------------------------------------------------------
3045 -- DESCRIPTION
3046 -- This function returns the
3047 --
3048 FUNCTION get_outcome_id
3049 (p_data_pump_always_call IN varchar2
3050 ,p_outcome_name IN VARCHAR2
3051 )
3052 RETURN BINARY_INTEGER;
3053 PRAGMA RESTRICT_REFERENCES (get_outcome_id , WNDS);
3054 -- -------------------------------------------------------------------------
3055 -- --------------------< get_eqt_ovn >--------------------------------
3056 -- -------------------------------------------------------------------------
3057 -- DESCRIPTION
3061 (p_data_pump_always_call IN varchar2
3058 -- This function returns the
3059 --
3060 FUNCTION get_eqt_ovn
3062 ,p_qualification_type_name IN VARCHAR2
3063 )
3064 RETURN BINARY_INTEGER;
3065 PRAGMA RESTRICT_REFERENCES (get_eqt_ovn , WNDS);
3066 -- -------------------------------------------------------------------------
3067 -- --------------------< get_ceo_ovn >--------------------------------
3068 -- -------------------------------------------------------------------------
3069 -- DESCRIPTION
3070 -- This function returns the
3071 --
3072 FUNCTION get_ceo_ovn
3073 (p_data_pump_always_call IN varchar2
3074 ,p_element_outcome_name IN VARCHAR2
3075 )
3076 RETURN BINARY_INTEGER;
3077 PRAGMA RESTRICT_REFERENCES (get_ceo_ovn , WNDS);
3078 -- -------------------------------------------------------------------------
3079 -- ------------------< get_competence_element_id >------------------------
3080 -- -------------------------------------------------------------------------
3081 -- DESCRIPTION
3082 -- This function returns the
3083 --
3084 FUNCTION get_competence_element_id
3085 (p_data_pump_always_call IN varchar2
3086 ,p_competence_name IN VARCHAR2
3087 ,p_person_user_key IN VARCHAR2
3088 ,p_business_group_id IN NUMBER
3089 )
3090 RETURN BINARY_INTEGER;
3091 PRAGMA RESTRICT_REFERENCES (get_competence_element_id , WNDS);
3092 --
3093 -- -------------------------------------------------------------------------
3094 -- ------------------< get_cost_flex_stru_num >------------------------
3095 -- -------------------------------------------------------------------------
3096 -- DESCRIPTION
3097 -- This function returns the cost flex structure num
3098 --
3099 FUNCTION get_cost_flex_stru_num
3100 (p_data_pump_always_call IN varchar2
3101 ,p_cost_flex_stru_code IN VARCHAR2
3102 )
3103 RETURN BINARY_INTEGER;
3104 PRAGMA RESTRICT_REFERENCES (get_cost_flex_stru_num , WNDS);
3105 --
3106 -- -------------------------------------------------------------------------
3107 -- ------------------< get_grade_flex_stru_num >------------------------
3108 -- -------------------------------------------------------------------------
3109 -- DESCRIPTION
3110 -- This function returns the grade flex structure num
3111 --
3112 FUNCTION get_grade_flex_stru_num
3113 (p_data_pump_always_call IN varchar2
3114 ,p_grade_flex_stru_code IN VARCHAR2
3115 )
3116 RETURN BINARY_INTEGER;
3117 PRAGMA RESTRICT_REFERENCES (get_grade_flex_stru_num , WNDS);
3118 --
3119 -- -------------------------------------------------------------------------
3120 -- ------------------< get_job_flex_stru_num >------------------------
3121 -- -------------------------------------------------------------------------
3122 -- DESCRIPTION
3123 -- This function returns the job flex structure num
3124 --
3125 FUNCTION get_job_flex_stru_num
3126 (p_data_pump_always_call IN varchar2
3127 ,p_job_flex_stru_code IN VARCHAR2
3128 )
3129 RETURN BINARY_INTEGER;
3130 PRAGMA RESTRICT_REFERENCES (get_job_flex_stru_num , WNDS);
3131 --
3132 -- -------------------------------------------------------------------------
3133 -- ------------------< get_position_flex_stru_num >------------------------
3134 -- -------------------------------------------------------------------------
3135 -- DESCRIPTION
3136 -- This function returns the position flex structure num
3137 --
3138 FUNCTION get_position_flex_stru_num
3139 (p_data_pump_always_call IN varchar2
3140 ,p_position_flex_stru_code IN VARCHAR2
3141 )
3142 RETURN BINARY_INTEGER;
3143 PRAGMA RESTRICT_REFERENCES (get_position_flex_stru_num , WNDS);
3144 --
3145 -- -------------------------------------------------------------------------
3146 -- ------------------< get_group_flex_stru_num >------------------------
3147 -- -------------------------------------------------------------------------
3148 -- DESCRIPTION
3149 -- This function returns the people group flex structure num
3150 --
3151 FUNCTION get_group_flex_stru_num
3152 (p_data_pump_always_call IN varchar2
3153 ,p_group_flex_stru_code IN VARCHAR2
3154 )
3155 RETURN BINARY_INTEGER;
3156 PRAGMA RESTRICT_REFERENCES (get_group_flex_stru_num , WNDS);
3157 --
3158 -- -------------------------------------------------------------------------
3159 -- ------------------< get_competence_flex_stru_num >---------------------
3160 -- -------------------------------------------------------------------------
3161 -- DESCRIPTION
3162 -- This function returns the competence flex structure num
3163 --
3164 FUNCTION get_competence_flex_stru_num
3165 (p_data_pump_always_call IN varchar2
3166 ,p_competence_flex_stru_code IN VARCHAR2
3167 )
3168 RETURN BINARY_INTEGER;
3169 PRAGMA RESTRICT_REFERENCES (get_competence_flex_stru_num , WNDS);
3170 --
3171 -- -------------------------------------------------------------------------
3172 -- -------------------------< get_sec_group_id >----------------------------
3173 -- -------------------------------------------------------------------------
3174 -- DESCRIPTION
3175 -- This function returns the security group id
3176 --
3177 FUNCTION get_sec_group_id
3178 (p_data_pump_always_call IN varchar2
3179 ,p_security_group_name IN VARCHAR2
3180 )
3181 RETURN BINARY_INTEGER;
3185 -- ------------------< get_security_profile_id >---------------------
3182 PRAGMA RESTRICT_REFERENCES (get_sec_group_id , WNDS);
3183 --
3184 -- -------------------------------------------------------------------------
3186 -- -------------------------------------------------------------------------
3187 -- DESCRIPTION
3188 -- This function returns the security_profile_id
3189 --
3190 FUNCTION get_security_profile_id
3191 (p_data_pump_always_call IN VARCHAR2
3192 ,p_security_profile_name IN VARCHAR2
3193 ,p_business_group_id IN NUMBER
3194 )
3195 RETURN BINARY_INTEGER;
3196 PRAGMA RESTRICT_REFERENCES (get_security_profile_id , WNDS);
3197 --
3198 --
3199 -- -------------------------------------------------------------------------
3200 -- --------------------< get_parent_organization_id >-----------------------
3201 -- -------------------------------------------------------------------------
3202 -- DESCRIPTION
3203 -- This function returns the organization_id
3204 --
3205 function get_parent_organization_id
3206 ( p_parent_organization_name in varchar2,
3207 p_business_group_id in number,
3208 p_effective_date in date,
3209 p_language_code in varchar2
3210 )
3211 RETURN BINARY_INTEGER;
3212 PRAGMA RESTRICT_REFERENCES (get_parent_organization_id , WNDS);
3213 --
3214 -- -------------------------------------------------------------------------
3215 -- ---------------------< get_child_organization_id >-----------------------
3216 -- -------------------------------------------------------------------------
3217 -- DESCRIPTION
3218 -- This function returns the organization_id.
3219 --
3220 function get_child_organization_id
3221 ( p_child_organization_name in varchar2,
3222 p_business_group_id in number,
3223 p_effective_date in date,
3224 p_language_code in varchar2
3225 )
3226 RETURN BINARY_INTEGER;
3227 PRAGMA RESTRICT_REFERENCES (get_child_organization_id , WNDS);
3228 --
3229 -- -------------------------------------------------------------------------
3230 -- ---------------------< get_person_extra_info_id >------------------------
3231 -- -------------------------------------------------------------------------
3232 -- DESCRIPTION
3233 -- This function returns the person_extra_info_id.
3234 --
3235 function get_person_extra_info_id
3236 (
3237 p_person_extra_info_user_key in varchar2
3238 ) return number;
3239 pragma restrict_references (get_person_extra_info_id, WNDS);
3240 --
3241 -- -------------------------------------------------------------------------
3242 -- ---------------------< get_person_extra_info_ovn >-----------------------
3243 -- -------------------------------------------------------------------------
3244 -- DESCRIPTION
3245 -- This function returns the ovn for person_extra_info_id.
3246 --
3247 function get_person_extra_info_ovn
3248 ( p_person_extra_info_user_key in varchar2
3249 ) return number;
3250 pragma restrict_references (get_person_extra_info_ovn, WNDS);
3251
3252
3253 --
3254 ------------------------- GET_EMP_FED_TAX_INF_ID -------------------------
3255 /*
3256 NAME
3257 GET_EMP_FED_TAX_INF_ID
3258 DESCRIPTION
3259 Returns a Canada federal tax Inf ID.
3260 NOTES
3261 This function returns a Canada GET_EMP_FED_TAX_INF_ID and is designed for use
3262 with the Data Pump.
3263 */
3264 function GET_EMP_FED_TAX_INF_ID
3265 (
3266 P_EMP_FED_TAX_INF_USER_KEY in varchar2
3267 ) return number;
3268 pragma restrict_references (GET_EMP_FED_TAX_INF_ID, WNDS);
3269
3270 ----------------------- GET_CA_EMP_FEDTAX_INF_OVN --------------------------
3271 /*
3272 NAME
3273 GET_CA_EMP_FEDTAX_INF_OVN
3274 DESCRIPTION
3275 Returns a tax rule Object Version Number.
3276 NOTES
3277 This returns an object version number for Canada Emp Fed tax Inf that has
3278 been created via the Data Pump engine.
3279 */
3280 function GET_CA_EMP_FEDTAX_INF_OVN
3281 (
3282 P_EMP_FED_TAX_INF_USER_KEY in varchar2,
3283 p_effective_date in date
3284 ) return number;
3285 pragma restrict_references (GET_CA_EMP_FEDTAX_INF_OVN, WNDS);
3286
3287
3288 --
3289 ------------------------- GET_EMP_PROVINCE_TAX_INF_ID -------------------------
3290 /*
3291 NAME
3292 GET_EMP_PROVINCE_TAX_INF_ID
3293 DESCRIPTION
3294 Returns a Canada Employee Province tax Inf ID.
3295 NOTES
3296 This function returns a Canada GET_EMP_PROVINCE_TAX_INF_ID and is designed
3297 for use with the Data Pump.
3298 */
3299 function GET_EMP_PROVINCE_TAX_INF_ID
3300 (
3301 P_EMP_PROV_TAX_INF_USER_KEY in varchar2
3302 ) return number;
3303 pragma restrict_references (GET_EMP_PROVINCE_TAX_INF_ID, WNDS);
3304
3305
3306 ----------------------- GET_CA_EMP_PRVTAX_INF_OVN --------------------------
3307 /*
3308 NAME
3309 GET_CA_EMP_PRVTAX_INF_OVN
3310 DESCRIPTION
3311 Returns a Canada Emp Province tax Inf Object Version Number.
3312 NOTES
3313 This returns an object version number for Canada Emp Province tax Inf that has
3314 been created via the Data Pump engine.
3315 */
3316 function GET_CA_EMP_PRVTAX_INF_OVN
3317 (
3318 P_EMP_PROV_TAX_INF_USER_KEY in varchar2,
3319 p_effective_date in date
3320 ) return number;
3321 pragma restrict_references (GET_CA_EMP_PRVTAX_INF_OVN, WNDS);
3322
3323 end hr_pump_get;