APPS.GHR_PA_REQUESTS_PKG2 dependencies on GHR_PA_REQUESTS

Line 1: PACKAGE BODY ghr_pa_requests_pkg2 AS

1: PACKAGE BODY ghr_pa_requests_pkg2 AS
2: /* $Header: ghparqs2.pkb 120.5 2005/08/25 11:30:26 vravikan noship $ */
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 30: ,ghr_pa_requests par

26: DECODE(prh.action_taken,'FUTURE_ACTION', ', APPROVED',
27: ', Routed To '||DECODE(gbx.name,null, 'User:'||prh.user_name, 'Groupbox:'||gbx.name)) list_info
28: FROM ghr_groupboxes gbx
29: ,ghr_pa_routing_history prh
30: ,ghr_pa_requests par
31: WHERE gbx.groupbox_id(+) = prh.groupbox_id
32: AND par.person_id = p_person_id
33: AND par.pa_request_id <> NVL(p_pa_request_id,-999)
34: AND prh.pa_request_id = par.pa_request_id

Line 76: ,ghr_pa_requests par

72: DECODE(par.second_noa_cancel_or_correct,'CANCEL','(CANCELED)')||
73: --- ', Effective Date:'||TO_CHAR(par.effective_date,'DD-MON-YYYY') list_info
74: ', Effective Date:'||fnd_date.date_to_chardate(par.effective_date) list_info
75: FROM ghr_pa_routing_history prh
76: ,ghr_pa_requests par
77: WHERE par.person_id = p_person_id
78: AND par.effective_date >= p_effective_date
79: AND prh.pa_request_id = par.pa_request_id
80: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)

Line 154: FROM ghr_pa_requests par

150: RETURN BOOLEAN IS
151: --
152: CURSOR c_par IS
153: SELECT par.noa_family_code
154: FROM ghr_pa_requests par
155: WHERE par.pa_request_id = p_altered_pa_request_id;
156:
157: BEGIN
158: -- get the noa_family code of the altered pa request id

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 670: IN ghr_pa_requests.altered_pa_request_id%type)

666:
667: --
668:
669: FUNCTION get_corr_cop (p_altered_pa_request_id
670: IN ghr_pa_requests.altered_pa_request_id%type)
671: RETURN NUMBER IS
672:
673: cursor cur_other is
674: select EMPLOYEE_ASSIGNMENT_ID,

Line 676: from ghr_pa_requests

672:
673: cursor cur_other is
674: select EMPLOYEE_ASSIGNMENT_ID,
675: EFFECTIVE_DATE
676: from ghr_pa_requests
677: where pa_request_id = p_altered_pa_request_id;
678:
679: l_assignment_id NUMBER(15);
680: l_effective_date DATE;

Line 874: END ghr_pa_requests_pkg2;

870: --
871: END check_mddds_pay;
872: --
873: --
874: END ghr_pa_requests_pkg2;