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_INTERFACE_ERR_DTLS

Line 1367: FROM ghr_pa_interface_err_dtls gpid

1363: CURSOR c_chk_err_exist
1364: IS
1365: SELECT count(err_doc_type) cnt
1366: ,gpid.err_doc_type doc_typ
1367: FROM ghr_pa_interface_err_dtls gpid
1368: WHERE gpid.err_doc_type IN ('063','110','347')
1369:
1370: GROUP BY gpid.err_doc_type;
1371:

Line 1380: FROM ghr_pa_interface_err_dtls gpid

1376: ,gpid.result_dtl_id
1377: ,gpid.result_id
1378: ,gpid.ext_request_id
1379: ,gpid.pa_interface_err_dtl_id
1380: FROM ghr_pa_interface_err_dtls gpid
1381: WHERE gpid.err_doc_type='347'
1382: AND NOT EXISTS
1383: (SELECT 'Xl'
1384: FROM ben_ext_rslt_dtl berd

Line 1439: FROM ghr_pa_interface_err_dtls gpid

1435: ,NULL ext_doc_typ
1436: ,NULL business_group_id
1437: ,'N' identifier
1438: ,gpid.pa_interface_err_dtl_id
1439: FROM ghr_pa_interface_err_dtls gpid
1440: WHERE gpid.err_doc_type=cp_doc_typ
1441: AND NOT EXISTS
1442: (SELECT 'X'
1443: FROM ben_ext_rslt_dtl berd

Line 1483: FROM ghr_pa_interface_err_dtls gpid

1479: ,berd.val_03 ext_doc_typ
1480: ,berd.business_group_id
1481: ,DECODE(berd.val_29,'001','D','002','C') identifier
1482: ,gpid.pa_interface_err_dtl_id
1483: FROM ghr_pa_interface_err_dtls gpid
1484: ,ben_ext_rslt_dtl berd
1485: WHERE gpid.err_doc_type=cp_doc_typ
1486: AND gpid.person_id=berd.person_id
1487: AND gpid.err_doc_type=berd.val_03

Line 1527: FROM ghr_pa_interface_err_dtls gpid

1523: ,NULL ext_doc_typ
1524: ,null business_group_id
1525: ,'N' identifier
1526: ,gpid.pa_interface_err_dtl_id
1527: FROM ghr_pa_interface_err_dtls gpid
1528: WHERE gpid.err_doc_type='110'
1529: AND NOT EXISTS
1530: (SELECT 'X'
1531: FROM ben_ext_rslt_dtl berd

Line 1571: FROM ghr_pa_interface_err_dtls gpid

1567: ,berd.val_03 ext_doc_typ
1568: ,berd.business_group_id
1569: ,DECODE(berd.val_38,'001','D','002','C') identifier
1570: ,gpid.pa_interface_err_dtl_id
1571: FROM ghr_pa_interface_err_dtls gpid
1572: ,ben_ext_rslt_dtl berd
1573: WHERE gpid.err_doc_type='110'
1574: AND gpid.person_id=berd.person_id
1575: AND gpid.err_doc_type=berd.val_03

Line 1671: DELETE FROM ghr_pa_interface_err_dtls perr

1667: CLOSE c_get_prev_rmk_data;
1668:
1669: l_rslt_dtl:=l_rslt_dtl_temp;
1670: --- Bug 5012619
1671: DELETE FROM ghr_pa_interface_err_dtls perr
1672: WHERE pa_interface_err_dtl_id = l_chk_data_in_file.pa_interface_err_dtl_id;
1673: --
1674: ELSIF l_chk_data_in_file.identifier='C' THEN
1675: UPDATE ben_ext_rslt_dtl berd

Line 1717: DELETE FROM ghr_pa_interface_err_dtls perr

1713: ) ;
1714:
1715: l_rslt_dtl:=l_rslt_dtl_temp;
1716: --- Bug 5012619
1717: DELETE FROM ghr_pa_interface_err_dtls perr
1718: WHERE pa_interface_err_dtl_id = l_chk_data_in_file_aw.pa_interface_err_dtl_id;
1719: --
1720: ELSIF l_chk_data_in_file_aw.identifier='C' THEN
1721: UPDATE ben_ext_rslt_dtl berd

Line 1760: DELETE FROM ghr_pa_interface_err_dtls perr

1756: (p_val_tab =>l_rslt_dtl
1757: ,p_rslt_dtl_id =>l_rslt_dtl_id
1758: ) ;
1759: --- Bug 5012619
1760: DELETE FROM ghr_pa_interface_err_dtls perr
1761: WHERE pa_interface_err_dtl_id = l_chk_add_in_file.pa_interface_err_dtl_id;
1762: --
1763: CLOSE c_get_prev_val_add;
1764: END LOOP;

Line 2081: INSERT INTO ghr_pa_interface_err_dtls

2077: l_noa2:=NULL;
2078: END IF;
2079:
2080: END IF;
2081: INSERT INTO ghr_pa_interface_err_dtls
2082: ( pa_interface_err_dtl_id
2083: ,ext_request_id
2084: ,result_id
2085: ,result_dtl_id

Line 2110: ghr_pa_interface_err_dtls_s.nextval

2106: ,error_elem_content
2107: )
2108: VALUES
2109: (
2110: ghr_pa_interface_err_dtls_s.nextval
2111: ,p_request_id
2112: ,l_result_id
2113: ,l_result_dtl_id
2114: ,p_record_id

Line 2567: DELETE FROM ghr_pa_interface_err_dtls;

2563: l_count :=l_attr.next(l_count);
2564: END LOOP;
2565: END IF;
2566: ELSE
2567: DELETE FROM ghr_pa_interface_err_dtls;
2568: OPEN c_get_pa_info;
2569: LOOP
2570: FETCH c_get_pa_info INTO l_get_pa_info;
2571: EXIT WHEN c_get_pa_info%NOTFOUND;

Line 2956: FROM ghr_pa_interface_err_dtls perr

2952: AND berd.ext_rslt_id = p_rslt_id
2953: AND val_01 = TO_CHAR(l_del_rec(l_recs));
2954: -- -- Bug 4937846
2955: DELETE
2956: FROM ghr_pa_interface_err_dtls perr
2957: WHERE perr.ext_request_id= p_request_id
2958: AND perr.result_id = p_rslt_id
2959: AND pa_request_id = l_del_rec(l_recs);
2960: