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

Line 872: p_effective_date in ghr_pa_requests.effective_date%type,

868: END;
869:
870: procedure process_nfc_auth_date(
871: --p_person_id in per_people_f.person_id%type,
872: p_effective_date in ghr_pa_requests.effective_date%type,
873: p_pa_request_id in ghr_pa_requests.pa_request_id%type)
874: is
875: cursor get_next_auth_date is
876: select nvl(max(fnd_date.canonical_to_date(rei_information3))+1,p_effective_date)

Line 873: p_pa_request_id in ghr_pa_requests.pa_request_id%type)

869:
870: procedure process_nfc_auth_date(
871: --p_person_id in per_people_f.person_id%type,
872: p_effective_date in ghr_pa_requests.effective_date%type,
873: p_pa_request_id in ghr_pa_requests.pa_request_id%type)
874: is
875: cursor get_next_auth_date is
876: select nvl(max(fnd_date.canonical_to_date(rei_information3))+1,p_effective_date)
877: authentication_date

Line 878: from ghr_pa_requests par, ghr_pa_request_extra_info rei

874: is
875: cursor get_next_auth_date is
876: select nvl(max(fnd_date.canonical_to_date(rei_information3))+1,p_effective_date)
877: authentication_date
878: from ghr_pa_requests par, ghr_pa_request_extra_info rei
879: where par.person_id in ( select person_id from ghr_pa_requests where
880: pa_request_id = p_pa_request_id )
881: and par.effective_date = p_effective_date
882: and par.pa_notification_id is not null

Line 879: where par.person_id in ( select person_id from ghr_pa_requests where

875: cursor get_next_auth_date is
876: select nvl(max(fnd_date.canonical_to_date(rei_information3))+1,p_effective_date)
877: authentication_date
878: from ghr_pa_requests par, ghr_pa_request_extra_info rei
879: where par.person_id in ( select person_id from ghr_pa_requests where
880: pa_request_id = p_pa_request_id )
881: and par.effective_date = p_effective_date
882: and par.pa_notification_id is not null
883: and par.pa_request_id = rei.pa_request_id

Line 902: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,

898: end;
899:
900: function get_nfc_prev_noa(
901: p_person_id in per_people_f.person_id%type,
902: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
903: p_effective_date in ghr_pa_requests.effective_date%type)
904: RETURN VARCHAR2
905: IS
906: CURSOR c_get_prev_details

Line 903: p_effective_date in ghr_pa_requests.effective_date%type)

899:
900: function get_nfc_prev_noa(
901: p_person_id in per_people_f.person_id%type,
902: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
903: p_effective_date in ghr_pa_requests.effective_date%type)
904: RETURN VARCHAR2
905: IS
906: CURSOR c_get_prev_details
907: is

Line 910: from ghr_pa_requests

906: CURSOR c_get_prev_details
907: is
908: select effective_date,first_noa_code,
909: second_noa_code,pa_notification_id,pa_request_id
910: from ghr_pa_requests
911: where pa_notification_id is not null
912: and person_id = p_person_id
913: and pa_notification_id < p_pa_notification_id
914: and effective_date <= p_effective_date

Line 917: from ghr_pa_requests where

913: and pa_notification_id < p_pa_notification_id
914: and effective_date <= p_effective_date
915: and first_noa_code not in ('001') -- Exclude all cancellations
916: and pa_request_id not in ( select altered_pa_request_id
917: from ghr_pa_requests where
918: pa_notification_id = p_pa_notification_id) -- Excludes original action
919: order by pa_notification_id desc;
920: BEGIN
921: FOR c_prev_rec in c_get_prev_details LOOP

Line 933: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,

929: END;
930:
931: procedure get_nfc_auth_codes(
932: p_person_id in per_people_f.person_id%type,
933: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
934: p_effective_date in ghr_pa_requests.effective_date%type,
935: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
936: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type)
937: IS

Line 934: p_effective_date in ghr_pa_requests.effective_date%type,

930:
931: procedure get_nfc_auth_codes(
932: p_person_id in per_people_f.person_id%type,
933: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
934: p_effective_date in ghr_pa_requests.effective_date%type,
935: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
936: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type)
937: IS
938: cursor c_get_prev_details is

Line 935: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,

931: procedure get_nfc_auth_codes(
932: p_person_id in per_people_f.person_id%type,
933: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
934: p_effective_date in ghr_pa_requests.effective_date%type,
935: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
936: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type)
937: IS
938: cursor c_get_prev_details is
939: select effective_date,first_noa_code,

Line 936: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type)

932: p_person_id in per_people_f.person_id%type,
933: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
934: p_effective_date in ghr_pa_requests.effective_date%type,
935: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
936: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type)
937: IS
938: cursor c_get_prev_details is
939: select effective_date,first_noa_code,
940: first_action_la_code1,first_action_la_code2,

Line 942: from ghr_pa_requests

938: cursor c_get_prev_details is
939: select effective_date,first_noa_code,
940: first_action_la_code1,first_action_la_code2,
941: second_action_la_code1,second_action_la_code2
942: from ghr_pa_requests
943: where pa_notification_id is not null
944: and person_id = p_person_id
945: and pa_notification_id < p_pa_notification_id
946: and effective_date <= p_effective_date

Line 949: from ghr_pa_requests where

945: and pa_notification_id < p_pa_notification_id
946: and effective_date <= p_effective_date
947: and first_noa_code not in ('001') -- Exclude all cancellations
948: and pa_request_id not in ( select altered_pa_request_id
949: from ghr_pa_requests where
950: pa_notification_id = p_pa_notification_id) -- Excludes original action
951: order by pa_notification_id desc;
952: BEGIN
953: FOR c_prev_rec in c_get_prev_details LOOP

Line 972: p_pa_request_id in ghr_pa_requests.pa_request_id%type)

968: p_second_auth_code := null;
969: raise;
970: END;
971: function get_nfc_conv_action_code(
972: p_pa_request_id in ghr_pa_requests.pa_request_id%type)
973: RETURN NUMBER
974: IS
975: cursor c_ex_emp is
976: select 'X'

Line 977: from per_people_f per, per_person_types ppt, ghr_pa_requests par

973: RETURN NUMBER
974: IS
975: cursor c_ex_emp is
976: select 'X'
977: from per_people_f per, per_person_types ppt, ghr_pa_requests par
978: where par.pa_request_id = p_pa_request_id
979: and per.person_id = par.person_id
980: and ppt.person_type_id = per.person_type_id
981: and ppt.system_person_type = 'EX_EMP'