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_PROC_FUT_MT dependencies on GHR_PA_REQUESTS

Line 26: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa

22: CURSOR c_futr_actions_poi(c_poi ghr_pois.personnel_office_id%TYPE) IS
23: SELECT a.person_id,a.effective_date,noa.order_of_processing,
24: a.pa_request_id,a.first_noa_code,a.object_version_number,
25: a.employee_last_name, a.employee_first_name,a.employee_national_identifier
26: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa
27: WHERE effective_date <= sysdate
28: AND pa_notification_id IS NULL
29: AND approval_date IS NOT NULL
30: AND a.pa_request_id = b.pa_request_id

Line 51: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa

47:
48: -- Cursor to find total future action records if POI parameter is entered
49: CURSOR c_tot_futr_actions_poi(c_poi ghr_pois.personnel_office_id%TYPE) IS
50: SELECT COUNT(*) fut_cnt
51: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa
52: WHERE effective_date <= sysdate
53: AND pa_notification_id IS NULL
54: AND approval_date IS NOT NULL
55: AND a.pa_request_id = b.pa_request_id

Line 79: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa

75: CURSOR c_futr_actions IS
76: SELECT a.person_id,a.effective_date,noa.order_of_processing,
77: a.pa_request_id,a.first_noa_code,a.object_version_number,
78: a.employee_last_name, a.employee_first_name,a.employee_national_identifier
79: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa
80: WHERE effective_date <= sysdate
81: AND pa_notification_id IS NULL
82: AND approval_date IS NOT NULL
83: AND a.pa_request_id = b.pa_request_id

Line 100: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa

96:
97: -- Cursor to find total future action records when POI parameter is not entered.
98: CURSOR c_tot_futr_actions IS
99: SELECT COUNT(*) fut_cnt
100: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa
101: WHERE effective_date <= sysdate
102: AND pa_notification_id IS NULL
103: AND approval_date IS NOT NULL
104: AND a.pa_request_id = b.pa_request_id

Line 124: l_effective_date ghr_pa_requests.effective_date%type;

120: WHERE session_id = c_session_id;
121:
122: -- Declaration of Local variables
123: l_person_id per_all_people.person_id%type;
124: l_effective_date ghr_pa_requests.effective_date%type;
125: l_batch_size NUMBER;
126: l_thread_size NUMBER;
127: l_batch_no NUMBER;
128: l_batch_counter NUMBER;

Line 205: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

201: -- person, insert the following records into the next batch.
202: FOR l_c_futr_actions IN c_futr_actions LOOP
203:
204: --Bug # 9329643
205: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
206: (p_person_id => l_c_futr_actions.person_id,
207: p_effective_date => l_c_futr_actions.effective_date);
208: l_result := NULL;
209: -- Bug#3726290 New business rule for NOAC 355

Line 314: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

310: END LOOP;
311: ELSE
312: FOR l_c_futr_actions IN c_futr_actions_poi(p_poi) LOOP
313: --Bug # 9329643
314: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
315: (p_person_id => l_c_futr_actions.person_id,
316: p_effective_date => l_c_futr_actions.effective_date);
317: l_result := NULL;
318: -- Bug#3726290 New business rule for NOAC 355

Line 520: CURSOR c_get_req(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS

516: FROM GHR_MTS_TEMP
517: WHERE session_id = c_session_id
518: AND batch_no = c_batch_no;
519:
520: CURSOR c_get_req(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
521: SELECT *
522: FROM ghr_pa_requests
523: WHERE pa_request_id = c_pa_request_id;
524:

Line 522: FROM ghr_pa_requests

518: AND batch_no = c_batch_no;
519:
520: CURSOR c_get_req(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
521: SELECT *
522: FROM ghr_pa_requests
523: WHERE pa_request_id = c_pa_request_id;
524:
525: CURSOR c_sessionid is
526: select userenv('sessionid') sesid from dual;

Line 528: l_sf52_rec ghr_pa_requests%rowtype;

524:
525: CURSOR c_sessionid is
526: select userenv('sessionid') sesid from dual;
527: -- Local Variables
528: l_sf52_rec ghr_pa_requests%rowtype;
529: l_new_line VARCHAR2(1);
530: l_log_text VARCHAR2(2000);
531: l_futr_proc_name VARCHAR2(50);
532: e_refresh EXCEPTION; -- Exception for refresh

Line 542: l_object_version_number ghr_pa_requests.object_version_number%type;

538:
539:
540: -- Start of Bug 3602261
541:
542: l_object_version_number ghr_pa_requests.object_version_number%type;
543:
544: CURSOR c_ovn (p_pa_request_id ghr_pa_requests.pa_request_id%type) IS -- 3769917
545: SELECT par.object_version_number
546: FROM ghr_pa_requests par

Line 544: CURSOR c_ovn (p_pa_request_id ghr_pa_requests.pa_request_id%type) IS -- 3769917

540: -- Start of Bug 3602261
541:
542: l_object_version_number ghr_pa_requests.object_version_number%type;
543:
544: CURSOR c_ovn (p_pa_request_id ghr_pa_requests.pa_request_id%type) IS -- 3769917
545: SELECT par.object_version_number
546: FROM ghr_pa_requests par
547: WHERE par.pa_request_id = p_pa_request_id; -- 3769917
548:

Line 546: FROM ghr_pa_requests par

542: l_object_version_number ghr_pa_requests.object_version_number%type;
543:
544: CURSOR c_ovn (p_pa_request_id ghr_pa_requests.pa_request_id%type) IS -- 3769917
545: SELECT par.object_version_number
546: FROM ghr_pa_requests par
547: WHERE par.pa_request_id = p_pa_request_id; -- 3769917
548:
549: -- End of Bug 3602261
550:

Line 597: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

593: -- Loop through the RPA record
594: FOR l_get_req IN c_get_req(l_batch_mts.pa_request_id) LOOP
595: l_sf52_rec := l_get_req;
596: --Bug # 9329643
597: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
598: (p_person_id => l_sf52_rec.person_id,
599: p_effective_date => l_sf52_rec.effective_date);
600: --============================================
601: BEGIN

Line 909: p_sf52 in out nocopy ghr_pa_requests%rowtype,

905: END create_ghr_errorlog;
906:
907:
908: Procedure Route_Errored_SF52(
909: p_sf52 in out nocopy ghr_pa_requests%rowtype,
910: p_error in varchar2,
911: p_result out nocopy varchar2) is
912:
913: l_u_prh_object_version_number number;

Line 920: l_sf52 ghr_pa_requests%rowtype ;

916:
917: l_log_text varchar2(2000);
918: l_proc varchar2(30);
919: l_new_line varchar2(1);
920: l_sf52 ghr_pa_requests%rowtype ;
921: --Bug # 9329643
922: l_employee_number per_people_f.employee_number%type;
923: Begin
924: l_proc := 'Route_Errerd_SF52';

Line 932: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

928: hr_utility.set_location( 'Entering : ' || l_proc, 10);
929: savepoint route_errored_sf52;
930: hr_utility.set_location( l_proc, 20);
931: --Bug # 9329643
932: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
933: (p_person_id => l_sf52.person_id,
934: p_effective_date => l_sf52.effective_date);
935:
936: l_log_text := 'Request Number : ' || p_sf52.request_number || l_new_line ||

Line 994: FROM ghr_pa_requests a, ghr_pa_routing_history b

990: l_ovn NUMBER;
991:
992: CURSOR c_pending_action_exists(c_person_id NUMBER, c_effective_date Date) IS
993: SELECT 'X'
994: FROM ghr_pa_requests a, ghr_pa_routing_history b
995: WHERE a.effective_date between (c_effective_date - 2) and (c_effective_date + 1)
996: AND a.person_id = c_person_id
997: AND (substr(a.first_noa_code,1,1) = '5' OR a.first_noa_code IN ('760','762','765'))
998: AND pa_notification_id IS NULL

Line 1013: FROM ghr_pa_requests

1009: FROM ghr_pa_routing_history
1010: WHERE pa_request_id = a.pa_request_id);
1011: CURSOR c_processed_action_exists(c_person_id NUMBER, c_effective_date DATE) IS
1012: SELECT 'Y'
1013: FROM ghr_pa_requests
1014: WHERE effective_date between (c_effective_date - 14) and (c_effective_date + 1)
1015: AND person_id = c_person_id
1016: AND (substr(first_noa_code,1,1) = '5' OR first_noa_code IN ('760','762','765'))
1017: AND pa_notification_id IS NOT NULL