APPS.GHR_PA_REQUESTS_PKG2 dependencies on GHR_PA_REQUESTS_PKG

Line 1: PACKAGE BODY ghr_pa_requests_pkg2 AS

1: PACKAGE BODY ghr_pa_requests_pkg2 AS
2: /* $Header: ghparqs2.pkb 120.7 2011/12/30 10:50:00 vmididho ship $ */
3:
4: -- This function checks if there are any pending PA Request actions for a given person (not including the
5: -- given PA Request)

Line 559: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_first_noa_id);

555: BEGIN
556: hr_utility.set_location('Entering ...' || l_proc,5);
557:
558: l_location_id := null;
559: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_first_noa_id);
560:
561: for cur_loc_rec in cur_loc
562: loop
563: l_location_id := cur_loc_rec.location_id;

Line 567: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_id);

563: l_location_id := cur_loc_rec.location_id;
564: end loop;
565:
566: IF l_noa_family_code = 'CORRECT' then
567: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_id);
568: END IF;
569:
570: hr_utility.set_location('Location_id ...' || l_location_id,10);
571: hr_utility.set_location('noa_family_code ...' || l_noa_family_code,10);

Line 582: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

578: loop
579: l_exists := TRUE;
580: end loop;
581: if l_location_id is not null then
582: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
583: (p_location_id => l_location_id
584: ,p_duty_station_id => l_duty_station_id);
585:
586: hr_utility.set_location('duty station id ...' || l_duty_station_id,15);

Line 588: ghr_pa_requests_pkg.get_duty_station_details

584: ,p_duty_station_id => l_duty_station_id);
585:
586: hr_utility.set_location('duty station id ...' || l_duty_station_id,15);
587:
588: ghr_pa_requests_pkg.get_duty_station_details
589: (p_duty_station_id => l_duty_station_id
590: ,p_effective_date => p_effective_date
591: ,p_duty_station_code => l_duty_station_code
592: ,p_duty_station_desc => l_duty_station_desc);

Line 1012: END ghr_pa_requests_pkg2;

1008: END IF;
1009: END;
1010:
1011:
1012: END ghr_pa_requests_pkg2;