APPS.GHR_NFC_ERROR_PROC dependencies on GHR_POS_INTERFACE_ERR_DTLS

Line 1801: FROM ghr_pos_interface_err_dtls gpid

1797: --Check error table if the master record exists
1798: CURSOR c_chk_mast_exist
1799: IS
1800: SELECT count(*) cnt
1801: FROM ghr_pos_interface_err_dtls gpid
1802: WHERE gpid.susp_mast_indv='2055';
1803: --Check for master error record.
1804: CURSOR c_chk_mast_err
1805: IS

Line 1811: ,ghr_pos_interface_err_dtls gpid

1807: berd.val_26 f_function_cd,
1808: gpid.susp_function_cd e_function_cd,
1809: gpid.pos_interface_err_dtl_id
1810: FROM ben_ext_rslt_dtl berd
1811: ,ghr_pos_interface_err_dtls gpid
1812: WHERE TO_CHAR(gpid.position_id) = berd.val_71
1813: AND gpid.susp_mast_indv ='2055'
1814: AND gpid.susp_mast_indv=berd.val_02
1815: AND berd.request_id=p_request_id

Line 1822: FROM ghr_pos_interface_err_dtls gpid

1818: --Check the record that is not is the transmission file.
1819: CURSOR c_chk_unpick_mast
1820: IS
1821: SELECT *
1822: FROM ghr_pos_interface_err_dtls gpid
1823: WHERE NOT EXISTS (
1824: SELECT 'X'
1825: FROM ben_ext_rslt_dtl berd
1826: WHERE to_char(gpid.position_id) = berd.val_71

Line 1837: FROM ghr_pos_interface_err_dtls gpid

1833: --Check error table if the detail record exists
1834: CURSOR c_chk_ind_exist
1835: IS
1836: SELECT COUNT(*) cnt
1837: FROM ghr_pos_interface_err_dtls gpid
1838: WHERE gpid.susp_mast_indv='2056';
1839:
1840: --Check for detail error record.
1841: CURSOR c_chk_ind_err

Line 1848: ,ghr_pos_interface_err_dtls gpid

1844: berd.val_45 f_function_cd,
1845: gpid.susp_function_cd e_function_cd,
1846: gpid.pos_interface_err_dtl_id
1847: FROM ben_ext_rslt_dtl berd
1848: ,ghr_pos_interface_err_dtls gpid
1849: WHERE to_char(gpid.position_id) = berd.val_71
1850: AND gpid.susp_mast_indv ='2056'
1851: AND gpid.susp_mast_indv=berd.val_02
1852: AND berd.request_id=p_request_id

Line 1860: FROM ghr_pos_interface_err_dtls gpid

1856: --Check the detail record that is not is the transmission file.
1857: CURSOR c_chk_unpick_ind
1858: IS
1859: SELECT *
1860: FROM ghr_pos_interface_err_dtls gpid
1861: WHERE NOT EXISTS (
1862: SELECT 'X'
1863: FROM ben_ext_rslt_dtl berd
1864: WHERE to_char(gpid.position_id) = berd.val_71

Line 1925: DELETE FROM ghr_pos_interface_err_dtls perr

1921: ,p_rslt_dtl_id => l_rslt_dtl_id
1922: ) ;
1923: CLOSE c_prev_ext_rslt;
1924: -- Bug 5012619
1925: DELETE FROM ghr_pos_interface_err_dtls perr
1926: WHERE pos_interface_err_dtl_id = l_chk_unpick_mast.pos_interface_err_dtl_id;
1927:
1928: END LOOP;
1929: CLOSE c_chk_unpick_mast;

Line 1976: DELETE FROM ghr_pos_interface_err_dtls perr

1972: ) ;
1973:
1974: CLOSE c_prev_ext_rslt;
1975: -- Bug 5012619
1976: DELETE FROM ghr_pos_interface_err_dtls perr
1977: WHERE pos_interface_err_dtl_id = l_chk_unpick_ind.pos_interface_err_dtl_id;
1978:
1979: END LOOP;
1980: CLOSE c_chk_unpick_ind;

Line 2220: INSERT INTO ghr_pos_interface_err_dtls

2216: ,l_incumbant_ssn
2217: ;
2218:
2219: EXIT WHEN l_cur%NOTFOUND;
2220: INSERT INTO ghr_pos_interface_err_dtls
2221: ( pos_interface_err_dtl_id
2222: ,request_id
2223: ,result_id
2224: ,result_dtl_id

Line 2249: (ghr_pos_interface_err_dtls_s.nextval

2245: ,susp_data_field
2246: ,susp_serv_agcy
2247: )
2248: VALUES
2249: (ghr_pos_interface_err_dtls_s.nextval
2250: ,p_request_id
2251: ,l_result_id
2252: ,l_result_dtl_id
2253: ,p_record_id

Line 2465: DELETE FROM ghr_pos_interface_err_dtls;

2461: l_val:='VAL_';
2462: l_val1:='VAL_0';
2463:
2464: IF p_file_type='PMSO' THEN
2465: DELETE FROM ghr_pos_interface_err_dtls;
2466: OPEN c_get_info_mast;
2467: LOOP
2468: FETCH c_get_info_mast INTO l_get_info;
2469: EXIT WHEN c_get_info_mast%NOTFOUND;