APPS.GHR_PA_REQUESTS_PKG2 dependencies on GHR_DUTY_STATIONS_F

Line 493: (p_duty_station_code in ghr_duty_stations_f.duty_station_code%TYPE)

489:
490: end chk_position_obligated;
491:
492: FUNCTION opm_mandated_duty_stations
493: (p_duty_station_code in ghr_duty_stations_f.duty_station_code%TYPE)
494: RETURN BOOLEAN IS
495: l_ret_val boolean := FALSE;
496: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
497: BEGIN

Line 496: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;

492: FUNCTION opm_mandated_duty_stations
493: (p_duty_station_code in ghr_duty_stations_f.duty_station_code%TYPE)
494: RETURN BOOLEAN IS
495: l_ret_val boolean := FALSE;
496: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
497: BEGIN
498: l_duty_station_code := p_duty_station_code;
499: if l_duty_station_code in
500: ('040355019', '060920071', '181788003', '181789003', '195549095',

Line 524: ,p_form_ds_code IN ghr_duty_stations_f.duty_station_code%TYPE

520:
521: PROCEDURE duty_station_warn (p_first_noa_id IN NUMBER
522: ,p_second_noa_id IN NUMBER
523: ,p_person_id IN NUMBER
524: ,p_form_ds_code IN ghr_duty_stations_f.duty_station_code%TYPE
525: ,p_effective_date IN DATE
526: ,p_message_set OUT NOCOPY BOOLEAN) IS
527:
528: l_proc varchar2(30) := 'duty_station_warn';

Line 533: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;

529:
530: l_noa_family_code ghr_families.noa_family_code%TYPE;
531: l_location_id hr_locations.location_id%TYPE;
532: l_duty_station_id VARCHAR2(150);
533: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
534: l_duty_station_desc VARCHAR2(200);
535: l_exists BOOLEAN := FALSE;
536: l_message_set BOOLEAN := FALSE;
537: duty_sta_exp EXCEPTION;