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_US_NFC_EXTRACTS

Line 1027: ,ghr_us_nfc_extracts.g_ext_start_dt

1023: FETCH c_chk_dup_action INTO l_chk_dup_action;
1024: EXIT WHEN c_chk_dup_action%NOTFOUND;
1025: OPEN c_get_dup_act (l_chk_dup_action.val_01
1026: ,l_chk_dup_action.val_150
1027: ,ghr_us_nfc_extracts.g_ext_start_dt
1028: );
1029: FETCH c_get_dup_act INTO l_get_dup_act;
1030:
1031: /*The extract pulls two records when the correction is done for

Line 1042: IF TRUNC(l_get_dup_act.approval_date) < ghr_us_nfc_extracts.g_ext_start_dt THEN

1038: approval date.
1039: Caveat is there could be an approval date for future action and
1040: this may happen in a very rare case.
1041: */
1042: IF TRUNC(l_get_dup_act.approval_date) < ghr_us_nfc_extracts.g_ext_start_dt THEN
1043: DELETE from ben_ext_rslt_dtl berd
1044: WHERE berd.request_id=p_request_id
1045: AND berd.ext_rslt_id=p_rslt_id
1046: AND berd.person_id=l_chk_dup_action.person_id

Line 2869: -- IF ghr_us_nfc_extracts.g_ext_start_dt >= TRUNC(l_orig_pa.approval_date) AND

2865:
2866: IF l_first_noa_code = '001' THEN
2867: debug_prg('Before comparing dates');
2868: -- If Actions done on the same date, add them to delete record.
2869: -- IF ghr_us_nfc_extracts.g_ext_start_dt >= TRUNC(l_orig_pa.approval_date) AND
2870: IF (
2871: (TRUNC(l_orig_pa.approval_date)
2872: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))
2873: )

Line 2872: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))

2868: -- If Actions done on the same date, add them to delete record.
2869: -- IF ghr_us_nfc_extracts.g_ext_start_dt >= TRUNC(l_orig_pa.approval_date) AND
2870: IF (
2871: (TRUNC(l_orig_pa.approval_date)
2872: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))
2873: )
2874: OR
2875: (TRUNC(l_orig_pa.effective_date)
2876: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))

Line 2876: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))

2872: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))
2873: )
2874: OR
2875: (TRUNC(l_orig_pa.effective_date)
2876: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))
2877: )
2878: )
2879: AND TRUNC(l_orig_pa.approval_date) = TRUNC(l_canc_pa.approval_date) THEN
2880: -- If it's Appointment action, delete all old actions done between appt and cancellation.

Line 2898: END IF; -- IF ghr_us_nfc_extracts.g_ext_star

2894: l_skip_records(l_skip_records.count+1) := l_child_rpas.pa_request_id;
2895: END LOOP;
2896: END IF; -- IF l_second_noa_code = '100' THEN
2897: l_skip_person_id := l_person_id;
2898: END IF; -- IF ghr_us_nfc_extracts.g_ext_star
2899: -- Correction action goes here...
2900: ELSIF l_first_noa_code = '002' THEN
2901: ----------
2902: -- Berd corrected

Line 2907: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))

2903: l_berd_corrected := l_chk_dup_action;
2904: -- Change sysdate after testing.
2905: IF (
2906: (TRUNC(l_orig_pa.approval_date)
2907: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))
2908: )
2909: OR
2910: (TRUNC(l_orig_pa.effective_date)
2911: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))

Line 2911: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))

2907: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))
2908: )
2909: OR
2910: (TRUNC(l_orig_pa.effective_date)
2911: BETWEEN TRUNC(ghr_us_nfc_extracts.g_ext_start_dt) AND TRUNC(NVL(ghr_us_nfc_extracts.g_ext_end_dt,ghr_us_nfc_extracts.g_ext_start_dt))
2912: )
2913: )
2914: AND TRUNC(l_orig_pa.approval_date) = TRUNC(l_canc_pa.approval_date) THEN
2915: --l_del_rec(l_del_corr_rec.count+1) := l_orig_pa_request_id;