eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_SF52_VALIDN_PKG dependencies on HR_API

Line 32: l_title := ghr_api.get_position_title

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);

Line 37: if nvl(l_title,hr_api.g_varchar2) <> p_requested_by_title then

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);

Line 66: l_title := ghr_api.get_position_title

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);

Line 71: if nvl(l_title,hr_api.g_varchar2) <> p_authorized_by_title then

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);

Line 252: l_title := ghr_api.get_position_title_pos

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: );

Line 259: if nvl(l_title,hr_api.g_varchar2) <> p_to_position_title then

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;

Line 265: l_desc_no := ghr_api.get_position_desc_no_pos

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: );

Line 271: if nvl(l_desc_no ,hr_api.g_varchar2) <> p_to_position_number then

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;

Line 277: l_seq_no := ghr_api.get_position_sequence_no_pos

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: );

Line 284: if nvl(l_seq_no ,hr_api.g_number) <> p_to_position_seq_no then

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;

Line 313: hr_api.not_exists_in_hr_lookups

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: );

Line 349: hr_api.not_exists_in_hr_lookups

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: );

Line 385: hr_api.not_exists_in_hr_lookups

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: );

Line 422: hr_api.not_exists_in_hr_lookups

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: );

Line 458: hr_api.not_exists_in_hr_lookups

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: );

Line 492: hr_api.not_exists_in_hr_lookups

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: );

Line 526: hr_api.not_exists_in_hr_lookups

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: );

Line 561: hr_api.not_exists_in_hr_lookups

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: );

Line 596: hr_api.not_exists_in_hr_lookups

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: );

Line 634: hr_api.not_exists_in_hr_lookups

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: );

Line 670: hr_api.not_exists_in_hr_lookups

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: );

Line 706: hr_api.not_exists_in_hr_lookups

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: );

Line 742: hr_api.not_exists_in_hr_lookups

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: );

Line 780: hr_api.not_exists_in_hr_lookups

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: );

Line 816: hr_api.not_exists_in_hr_lookups

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: );

Line 852: hr_api.not_exists_in_hr_lookups

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: );

Line 888: hr_api.not_exists_in_hr_lookups

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: );

Line 924: hr_api.not_exists_in_hr_lookups

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: );

Line 961: hr_api.not_exists_in_hr_lookups

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: );

Line 997: hr_api.not_exists_in_hr_lookups

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: );

Line 1033: hr_api.not_exists_in_hr_lookups

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: );

Line 1069: hr_api.not_exists_in_hr_lookups

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: );

Line 1105: hr_api.not_exists_in_hr_lookups

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: );