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 506: CURSOR c_get_req(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS

502: FROM GHR_MTS_TEMP
503: WHERE session_id = c_session_id
504: AND batch_no = c_batch_no;
505:
506: CURSOR c_get_req(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
507: SELECT *
508: FROM ghr_pa_requests
509: WHERE pa_request_id = c_pa_request_id;
510:

Line 508: FROM ghr_pa_requests

504: AND batch_no = c_batch_no;
505:
506: CURSOR c_get_req(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
507: SELECT *
508: FROM ghr_pa_requests
509: WHERE pa_request_id = c_pa_request_id;
510:
511: CURSOR c_sessionid is
512: select userenv('sessionid') sesid from dual;

Line 514: l_sf52_rec ghr_pa_requests%rowtype;

510:
511: CURSOR c_sessionid is
512: select userenv('sessionid') sesid from dual;
513: -- Local Variables
514: l_sf52_rec ghr_pa_requests%rowtype;
515: l_new_line VARCHAR2(1);
516: l_log_text VARCHAR2(2000);
517: l_futr_proc_name VARCHAR2(50);
518: e_refresh EXCEPTION; -- Exception for refresh

Line 528: l_object_version_number ghr_pa_requests.object_version_number%type;

524:
525:
526: -- Start of Bug 3602261
527:
528: l_object_version_number ghr_pa_requests.object_version_number%type;
529:
530: CURSOR c_ovn (p_pa_request_id ghr_pa_requests.pa_request_id%type) IS -- 3769917
531: SELECT par.object_version_number
532: FROM ghr_pa_requests par

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

526: -- Start of Bug 3602261
527:
528: l_object_version_number ghr_pa_requests.object_version_number%type;
529:
530: CURSOR c_ovn (p_pa_request_id ghr_pa_requests.pa_request_id%type) IS -- 3769917
531: SELECT par.object_version_number
532: FROM ghr_pa_requests par
533: WHERE par.pa_request_id = p_pa_request_id; -- 3769917
534:

Line 532: FROM ghr_pa_requests par

528: l_object_version_number ghr_pa_requests.object_version_number%type;
529:
530: CURSOR c_ovn (p_pa_request_id ghr_pa_requests.pa_request_id%type) IS -- 3769917
531: SELECT par.object_version_number
532: FROM ghr_pa_requests par
533: WHERE par.pa_request_id = p_pa_request_id; -- 3769917
534:
535: -- End of Bug 3602261
536:

Line 887: p_sf52 in out nocopy ghr_pa_requests%rowtype,

883: END create_ghr_errorlog;
884:
885:
886: Procedure Route_Errored_SF52(
887: p_sf52 in out nocopy ghr_pa_requests%rowtype,
888: p_error in varchar2,
889: p_result out nocopy varchar2) is
890:
891: l_u_prh_object_version_number number;

Line 898: l_sf52 ghr_pa_requests%rowtype ;

894:
895: l_log_text varchar2(2000);
896: l_proc varchar2(30);
897: l_new_line varchar2(1);
898: l_sf52 ghr_pa_requests%rowtype ;
899: Begin
900: l_proc := 'Route_Errerd_SF52';
901: l_new_line := substr('
902: ',1,1);

Line 964: FROM ghr_pa_requests a, ghr_pa_routing_history b

960: l_ovn NUMBER;
961:
962: CURSOR c_pending_action_exists(c_person_id NUMBER, c_effective_date Date) IS
963: SELECT 'X'
964: FROM ghr_pa_requests a, ghr_pa_routing_history b
965: WHERE a.effective_date between (c_effective_date - 2) and (c_effective_date + 1)
966: AND a.person_id = c_person_id
967: AND (substr(a.first_noa_code,1,1) = '5' OR a.first_noa_code IN ('760','762','765'))
968: AND pa_notification_id IS NULL

Line 983: FROM ghr_pa_requests

979: FROM ghr_pa_routing_history
980: WHERE pa_request_id = a.pa_request_id);
981: CURSOR c_processed_action_exists(c_person_id NUMBER, c_effective_date DATE) IS
982: SELECT 'Y'
983: FROM ghr_pa_requests
984: WHERE effective_date between (c_effective_date - 14) and (c_effective_date + 1)
985: AND person_id = c_person_id
986: AND (substr(first_noa_code,1,1) = '5' OR first_noa_code IN ('760','762','765'))
987: AND pa_notification_id IS NOT NULL