28:
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: if p_requested_by_title is not null then
32: l_title := ghr_api.get_position_title
33: (p_person_id => p_requested_by_person_id
34: ,p_effective_date => trunc(nvl(p_effective_date,sysdate))
35: );
36: hr_utility.set_location(l_proc, 20);
33: (p_person_id => p_requested_by_person_id
34: ,p_effective_date => trunc(nvl(p_effective_date,sysdate))
35: );
36: hr_utility.set_location(l_proc, 20);
37: if nvl(l_title,hr_api.g_varchar2) <> p_requested_by_title then
38: hr_utility.set_message(8301,'GHR_38094_INV_REQ_TITLE');
39: hr_utility.raise_error;
40: end if;
41: hr_utility.set_location(l_proc, 30);
62:
63: begin
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: if p_authorized_by_title is not null then
66: l_title := ghr_api.get_position_title
67: (p_person_id => p_authorized_by_person_id
68: ,p_effective_date => trunc(nvl(p_effective_date,sysdate))
69: );
70: hr_utility.set_location(l_proc, 20);
67: (p_person_id => p_authorized_by_person_id
68: ,p_effective_date => trunc(nvl(p_effective_date,sysdate))
69: );
70: hr_utility.set_location(l_proc, 20);
71: if nvl(l_title,hr_api.g_varchar2) <> p_authorized_by_title then
72: hr_utility.set_message(8301,'GHR_38095_INV_AUTH_TITLE');
73: hr_utility.raise_error;
74: end if;
75: hr_utility.set_location(l_proc, 30);
248: if p_to_position_id is not null then
249: for bgp_id in c_bgp_id loop
250: l_bgp_id := bgp_id.business_group_id;
251: end loop;
252: l_title := ghr_api.get_position_title_pos
253: (p_position_id => p_to_position_id
254: ,p_business_group_id => l_bgp_id
255: ,p_effective_date => p_effective_date
256: );
255: ,p_effective_date => p_effective_date
256: );
257:
258: if p_to_position_title is not null then
259: if nvl(l_title,hr_api.g_varchar2) <> p_to_position_title then
260: hr_utility.set_message(8301,'GHR_38072_INV_TO_POS_TITLE');
261: hr_utility.raise_error;
262: end if;
263: end if;
261: hr_utility.raise_error;
262: end if;
263: end if;
264:
265: l_desc_no := ghr_api.get_position_desc_no_pos
266: (p_position_id => p_to_position_id
267: ,p_business_group_id => l_bgp_id
268: ,p_effective_date => p_effective_date
269: );
267: ,p_business_group_id => l_bgp_id
268: ,p_effective_date => p_effective_date
269: );
270: if p_to_position_number is not null then
271: if nvl(l_desc_no ,hr_api.g_varchar2) <> p_to_position_number then
272: hr_utility.set_message(8301,'GHR_38073_INV_TO_POS_NUMBER');
273: hr_utility.raise_error;
274: end if;
275: end if;
273: hr_utility.raise_error;
274: end if;
275: end if;
276:
277: l_seq_no := ghr_api.get_position_sequence_no_pos
278: (p_position_id => p_to_position_id
279: ,p_business_group_id => l_bgp_id
280: ,p_effective_date => p_effective_date
281: );
280: ,p_effective_date => p_effective_date
281: );
282:
283: if p_to_position_seq_no is not null then
284: if nvl(l_seq_no ,hr_api.g_number) <> p_to_position_seq_no then
285: hr_utility.set_message(8301,'GHR_38267_INV_TO_POS_SEQ_NUMB');
286: hr_utility.raise_error;
287: end if;
288: end if;
309: --
310: If p_award_uom is not null then
311: --
312: l_not_exists :=
313: hr_api.not_exists_in_hr_lookups
314: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
315: ,p_lookup_code => p_award_uom
316: ,p_lookup_type => 'GHR_US_AWARD_UOM'
317: );
345: --
346: If p_appropriation_code1 is not null then
347: --
348: l_not_exists :=
349: hr_api.not_exists_in_hr_lookups
350: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
351: ,p_lookup_code => p_appropriation_code1
352: ,p_lookup_type => 'GHR_US_APPROPRIATION_CODE1'
353: );
381: --
382: If p_appropriation_code2 is not null then
383: --
384: l_not_exists :=
385: hr_api.not_exists_in_hr_lookups
386: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
387: ,p_lookup_code => p_appropriation_code2
388: ,p_lookup_type => 'GHR_US_APPROPRIATION_CODE2'
389: );
418: --
419: If p_annuitant_indicator is not null then
420: --
421: l_not_exists :=
422: hr_api.not_exists_in_hr_lookups
423: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
424: ,p_lookup_code => p_annuitant_indicator
425: ,p_lookup_type => 'GHR_US_ANNUITANT_INDICATOR'
426: );
454: --
455: If p_bargaining_unit_status is not null then
456: --
457: l_not_exists :=
458: hr_api.not_exists_in_hr_lookups
459: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
460: ,p_lookup_code => p_bargaining_unit_status
461: ,p_lookup_type => 'GHR_US_BARG_UNIT_STATUS'
462: );
488: --
489: If p_supervisory_status is not null then
490: --
491: l_not_exists :=
492: hr_api.not_exists_in_hr_lookups
493: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
494: ,p_lookup_code => p_supervisory_status
495: ,p_lookup_type => 'GHR_US_SUPERVISORY_STATUS'
496: );
522: --
523: If p_functional_class is not null then
524: --
525: l_not_exists :=
526: hr_api.not_exists_in_hr_lookups
527: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
528: ,p_lookup_code => p_functional_class
529: ,p_lookup_type => 'GHR_US_FUNCTIONAL_CLASS'
530: );
557: -- Check mandatory parameters have been set
558: If p_position_occupied is not null then
559: --
560: l_not_exists :=
561: hr_api.not_exists_in_hr_lookups
562: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
563: ,p_lookup_code => p_position_occupied
564: ,p_lookup_type => 'GHR_US_POSITION_OCCUPIED'
565: );
592: --
593: If p_fegli is not null then
594: --
595: l_not_exists :=
596: hr_api.not_exists_in_hr_lookups
597: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
598: ,p_lookup_code => p_fegli
599: ,p_lookup_type => 'GHR_US_FEGLI'
600: );
630: --
631: If p_retirement_plan is not null then
632: --
633: l_not_exists :=
634: hr_api.not_exists_in_hr_lookups
635: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
636: ,p_lookup_code => p_retirement_plan
637: ,p_lookup_type => 'GHR_US_RETIREMENT_PLAN'
638: );
666: --
667: If p_tenure is not null then
668: --
669: l_not_exists :=
670: hr_api.not_exists_in_hr_lookups
671: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
672: ,p_lookup_code => p_tenure
673: ,p_lookup_type => 'GHR_US_TENURE'
674: );
702: --
703: If p_pay_rate_determinant is not null then
704: --
705: l_not_exists :=
706: hr_api.not_exists_in_hr_lookups
707: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
708: ,p_lookup_code => p_pay_rate_determinant
709: ,p_lookup_type => 'GHR_US_PAY_RATE_DETERMINANT'
710: );
738: --
739: If p_pay_basis is not null then
740: --
741: l_not_exists :=
742: hr_api.not_exists_in_hr_lookups
743: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
744: ,p_lookup_code => p_pay_basis
745: ,p_lookup_type => 'GHR_US_PAY_BASIS'
746: );
776: --
777: If p_pay_plan is not null then
778: --
779: l_not_exists :=
780: hr_api.not_exists_in_hr_lookups
781: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
782: ,p_lookup_code => p_pay_plan
783: ,p_lookup_type => 'GHR_US_PAY_PLAN'
784: );
812: --
813: If p_grade_or_level is not null then
814: --
815: l_not_exists :=
816: hr_api.not_exists_in_hr_lookups
817: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
818: ,p_lookup_code => p_grade_or_level
819: ,p_lookup_type => 'GHR_US_GRADE_OR_LEVEL' -- check this
820: );
848: --
849: If p_to_occ_code is not null then
850: --
851: l_not_exists :=
852: hr_api.not_exists_in_hr_lookups
853: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
854: ,p_lookup_code => p_to_occ_code
855: ,p_lookup_type => 'GHR_US_OCC_SERIES'
856: );
884: --
885: If p_step_or_rate is not null then
886: --
887: l_not_exists :=
888: hr_api.not_exists_in_hr_lookups
889: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
890: ,p_lookup_code => p_step_or_rate
891: ,p_lookup_type => 'GHR_US_STEP'
892: );
920: --
921: If p_citizenship is not null then
922: --
923: l_not_exists :=
924: hr_api.not_exists_in_hr_lookups
925: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
926: ,p_lookup_code => p_citizenship
927: ,p_lookup_type => 'GHR_US_CITIZENSHIP'
928: );
957: --
958: If p_veterans_status is not null then
959: --
960: l_not_exists :=
961: hr_api.not_exists_in_hr_lookups
962: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
963: ,p_lookup_code => p_veterans_status
964: ,p_lookup_type => 'GHR_US_VET_STATUS' -- check this
965: );
993: --
994: If p_veterans_preference is not null then
995: --
996: l_not_exists :=
997: hr_api.not_exists_in_hr_lookups
998: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
999: ,p_lookup_code => p_veterans_preference
1000: ,p_lookup_type => 'GHR_US_VETERANS_PREF' -- check this
1001: );
1029: --
1030: If p_work_schedule is not null then
1031: --
1032: l_not_exists :=
1033: hr_api.not_exists_in_hr_lookups
1034: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
1035: ,p_lookup_code => p_work_schedule
1036: ,p_lookup_type => 'GHR_US_WORK_SCHEDULE' -- check this
1037: );
1065: --
1066: If p_academic_discipline is not null then
1067: --
1068: l_not_exists :=
1069: hr_api.not_exists_in_hr_lookups
1070: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
1071: ,p_lookup_code => p_academic_discipline
1072: ,p_lookup_type => 'GHR_US_ACADEMIC_DISCIPLINE'
1073: );
1101: --
1102: If p_education_level is not null then
1103: --
1104: l_not_exists :=
1105: hr_api.not_exists_in_hr_lookups
1106: (p_effective_date => trunc(nvl(p_effective_date,sysdate))
1107: ,p_lookup_code => p_education_level
1108: ,p_lookup_type => 'GHR_US_EDUCATIONAL_LEVEL'
1109: );