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

Line 939: FROM ghr_pa_requests gpa

935: ,cp_date DATE
936: )
937: IS
938: SELECT *
939: FROM ghr_pa_requests gpa
940: WHERE pa_request_id=cp_alt_req_id;
941:
942: CURSOR c_chk_same_action (cp_request_id NUMBER
943: ,cp_rslt_id NUMBER

Line 2733: CURSOR c_rpa_values(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

2729: WHERE berd.request_id =cp_request_id
2730: AND berd.ext_rslt_id =cp_rslt_id
2731: AND berd.val_01 = cp_val_01;
2732:
2733: CURSOR c_rpa_values(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
2734: SELECT par.*
2735: FROM ghr_pa_requests par
2736: WHERE pa_request_id = c_pa_request_id;
2737:

Line 2735: FROM ghr_pa_requests par

2731: AND berd.val_01 = cp_val_01;
2732:
2733: CURSOR c_rpa_values(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
2734: SELECT par.*
2735: FROM ghr_pa_requests par
2736: WHERE pa_request_id = c_pa_request_id;
2737:
2738: CURSOR c_rpa_for_person(c_person_id ghr_pa_requests.person_id%type,
2739: c_canc_rpa_id ghr_pa_requests.pa_request_id%type,

Line 2738: CURSOR c_rpa_for_person(c_person_id ghr_pa_requests.person_id%type,

2734: SELECT par.*
2735: FROM ghr_pa_requests par
2736: WHERE pa_request_id = c_pa_request_id;
2737:
2738: CURSOR c_rpa_for_person(c_person_id ghr_pa_requests.person_id%type,
2739: c_canc_rpa_id ghr_pa_requests.pa_request_id%type,
2740: c_approval_date ghr_pa_requests.approval_date%type)
2741: IS
2742: SELECT pa_request_id

Line 2739: c_canc_rpa_id ghr_pa_requests.pa_request_id%type,

2735: FROM ghr_pa_requests par
2736: WHERE pa_request_id = c_pa_request_id;
2737:
2738: CURSOR c_rpa_for_person(c_person_id ghr_pa_requests.person_id%type,
2739: c_canc_rpa_id ghr_pa_requests.pa_request_id%type,
2740: c_approval_date ghr_pa_requests.approval_date%type)
2741: IS
2742: SELECT pa_request_id
2743: FROM ghr_pa_requests

Line 2740: c_approval_date ghr_pa_requests.approval_date%type)

2736: WHERE pa_request_id = c_pa_request_id;
2737:
2738: CURSOR c_rpa_for_person(c_person_id ghr_pa_requests.person_id%type,
2739: c_canc_rpa_id ghr_pa_requests.pa_request_id%type,
2740: c_approval_date ghr_pa_requests.approval_date%type)
2741: IS
2742: SELECT pa_request_id
2743: FROM ghr_pa_requests
2744: WHERE person_id = c_person_id

Line 2743: FROM ghr_pa_requests

2739: c_canc_rpa_id ghr_pa_requests.pa_request_id%type,
2740: c_approval_date ghr_pa_requests.approval_date%type)
2741: IS
2742: SELECT pa_request_id
2743: FROM ghr_pa_requests
2744: WHERE person_id = c_person_id
2745: AND first_noa_cancel_or_correct = 'CANCEL'
2746: AND pa_request_id < c_canc_rpa_id
2747: AND TRUNC(approval_date) = c_approval_date;

Line 2749: CURSOR c_child_rpas(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

2745: AND first_noa_cancel_or_correct = 'CANCEL'
2746: AND pa_request_id < c_canc_rpa_id
2747: AND TRUNC(approval_date) = c_approval_date;
2748:
2749: CURSOR c_child_rpas(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
2750: SELECT pa_request_id
2751: FROM ghr_pa_requests
2752: WHERE pa_notification_id IS NOT NULL
2753: START WITH pa_request_id = c_pa_request_id

Line 2751: FROM ghr_pa_requests

2747: AND TRUNC(approval_date) = c_approval_date;
2748:
2749: CURSOR c_child_rpas(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
2750: SELECT pa_request_id
2751: FROM ghr_pa_requests
2752: WHERE pa_notification_id IS NOT NULL
2753: START WITH pa_request_id = c_pa_request_id
2754: CONNECT BY PRIOR pa_request_id = altered_pa_request_id; -- Bug 4923152
2755:

Line 2756: CURSOR c_child_rpas_correct(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

2752: WHERE pa_notification_id IS NOT NULL
2753: START WITH pa_request_id = c_pa_request_id
2754: CONNECT BY PRIOR pa_request_id = altered_pa_request_id; -- Bug 4923152
2755:
2756: CURSOR c_child_rpas_correct(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
2757: SELECT pa_request_id
2758: FROM ghr_pa_requests
2759: WHERE pa_notification_id IS NOT NULL
2760: START WITH pa_request_id = c_pa_request_id

Line 2758: FROM ghr_pa_requests

2754: CONNECT BY PRIOR pa_request_id = altered_pa_request_id; -- Bug 4923152
2755:
2756: CURSOR c_child_rpas_correct(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
2757: SELECT pa_request_id
2758: FROM ghr_pa_requests
2759: WHERE pa_notification_id IS NOT NULL
2760: START WITH pa_request_id = c_pa_request_id
2761: CONNECT BY PRIOR altered_pa_request_id = pa_request_id; -- Bug 4923152
2762:

Line 2766: l_orig_pa ghr_pa_requests%rowtype;

2762:
2763: TYPE t_del_rec IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
2764: l_del_rec t_del_rec;
2765: l_del_corr_rec t_del_rec;
2766: l_orig_pa ghr_pa_requests%rowtype;
2767: l_canc_pa ghr_pa_requests%rowtype;
2768: l_orig_pa_request_id ghr_pa_requests.pa_request_id%type;
2769: l_canc_pa_request_id ghr_pa_requests.pa_request_id%type;
2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;

Line 2767: l_canc_pa ghr_pa_requests%rowtype;

2763: TYPE t_del_rec IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
2764: l_del_rec t_del_rec;
2765: l_del_corr_rec t_del_rec;
2766: l_orig_pa ghr_pa_requests%rowtype;
2767: l_canc_pa ghr_pa_requests%rowtype;
2768: l_orig_pa_request_id ghr_pa_requests.pa_request_id%type;
2769: l_canc_pa_request_id ghr_pa_requests.pa_request_id%type;
2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;
2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;

Line 2768: l_orig_pa_request_id ghr_pa_requests.pa_request_id%type;

2764: l_del_rec t_del_rec;
2765: l_del_corr_rec t_del_rec;
2766: l_orig_pa ghr_pa_requests%rowtype;
2767: l_canc_pa ghr_pa_requests%rowtype;
2768: l_orig_pa_request_id ghr_pa_requests.pa_request_id%type;
2769: l_canc_pa_request_id ghr_pa_requests.pa_request_id%type;
2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;
2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;
2772: l_person_id ghr_pa_requests.person_id%type;

Line 2769: l_canc_pa_request_id ghr_pa_requests.pa_request_id%type;

2765: l_del_corr_rec t_del_rec;
2766: l_orig_pa ghr_pa_requests%rowtype;
2767: l_canc_pa ghr_pa_requests%rowtype;
2768: l_orig_pa_request_id ghr_pa_requests.pa_request_id%type;
2769: l_canc_pa_request_id ghr_pa_requests.pa_request_id%type;
2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;
2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;
2772: l_person_id ghr_pa_requests.person_id%type;
2773: l_berd_original ben_ext_rslt_dtl%rowtype;

Line 2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;

2766: l_orig_pa ghr_pa_requests%rowtype;
2767: l_canc_pa ghr_pa_requests%rowtype;
2768: l_orig_pa_request_id ghr_pa_requests.pa_request_id%type;
2769: l_canc_pa_request_id ghr_pa_requests.pa_request_id%type;
2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;
2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;
2772: l_person_id ghr_pa_requests.person_id%type;
2773: l_berd_original ben_ext_rslt_dtl%rowtype;
2774: l_berd_corrected ben_ext_rslt_dtl%rowtype;

Line 2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;

2767: l_canc_pa ghr_pa_requests%rowtype;
2768: l_orig_pa_request_id ghr_pa_requests.pa_request_id%type;
2769: l_canc_pa_request_id ghr_pa_requests.pa_request_id%type;
2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;
2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;
2772: l_person_id ghr_pa_requests.person_id%type;
2773: l_berd_original ben_ext_rslt_dtl%rowtype;
2774: l_berd_corrected ben_ext_rslt_dtl%rowtype;
2775: TYPE t_correct_records IS TABLE OF ben_ext_rslt_dtl%rowtype INDEX BY PLS_INTEGER;

Line 2772: l_person_id ghr_pa_requests.person_id%type;

2768: l_orig_pa_request_id ghr_pa_requests.pa_request_id%type;
2769: l_canc_pa_request_id ghr_pa_requests.pa_request_id%type;
2770: l_first_noa_code ghr_pa_requests.first_noa_code%type;
2771: l_second_noa_code ghr_pa_requests.second_noa_code%type;
2772: l_person_id ghr_pa_requests.person_id%type;
2773: l_berd_original ben_ext_rslt_dtl%rowtype;
2774: l_berd_corrected ben_ext_rslt_dtl%rowtype;
2775: TYPE t_correct_records IS TABLE OF ben_ext_rslt_dtl%rowtype INDEX BY PLS_INTEGER;
2776: l_correct_records t_correct_records;

Line 2781: l_skip_person_id ghr_pa_requests.person_id%type;

2777: l_result NUMBER;
2778: TYPE t_skip_records IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
2779: l_skip_records t_skip_records;
2780: l_skip_this BOOLEAN;
2781: l_skip_person_id ghr_pa_requests.person_id%type;
2782: l_effective_date ghr_pa_requests.effective_date%type;
2783:
2784: PROCEDURE debug_prg(txt varchar2) IS
2785: BEGIN

Line 2782: l_effective_date ghr_pa_requests.effective_date%type;

2778: TYPE t_skip_records IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
2779: l_skip_records t_skip_records;
2780: l_skip_this BOOLEAN;
2781: l_skip_person_id ghr_pa_requests.person_id%type;
2782: l_effective_date ghr_pa_requests.effective_date%type;
2783:
2784: PROCEDURE debug_prg(txt varchar2) IS
2785: BEGIN
2786: hr_utility.set_location(txt,120);