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.IGS_AD_IMP_026 dependencies on IGS_PE_VST_HIST_INT

Line 43: CURSOR visit_dtls(cp_vh_status_2 igs_pe_vst_hist_int.status%TYPE,

39: AND vi.interface_run_id = cp_interface_run_id
40: AND i.interface_run_id = cp_interface_run_id;
41:
42:
43: CURSOR visit_dtls(cp_vh_status_2 igs_pe_vst_hist_int.status%TYPE,
44: cp_vi_status_1 igs_pe_visa_int.status%TYPE,
45: cp_interface_run_id igs_pe_vst_hist_int.interface_run_id%TYPE) IS
46: SELECT vh.*, i.person_id,pev.visa_id,pev.visa_issue_date issue_date,pev.visa_expiry_date expiry_date
47: FROM igs_pe_vst_hist_int vh,

Line 45: cp_interface_run_id igs_pe_vst_hist_int.interface_run_id%TYPE) IS

41:
42:
43: CURSOR visit_dtls(cp_vh_status_2 igs_pe_vst_hist_int.status%TYPE,
44: cp_vi_status_1 igs_pe_visa_int.status%TYPE,
45: cp_interface_run_id igs_pe_vst_hist_int.interface_run_id%TYPE) IS
46: SELECT vh.*, i.person_id,pev.visa_id,pev.visa_issue_date issue_date,pev.visa_expiry_date expiry_date
47: FROM igs_pe_vst_hist_int vh,
48: igs_ad_interface_all i,
49: igs_pe_visa_int vi,

Line 47: FROM igs_pe_vst_hist_int vh,

43: CURSOR visit_dtls(cp_vh_status_2 igs_pe_vst_hist_int.status%TYPE,
44: cp_vi_status_1 igs_pe_visa_int.status%TYPE,
45: cp_interface_run_id igs_pe_vst_hist_int.interface_run_id%TYPE) IS
46: SELECT vh.*, i.person_id,pev.visa_id,pev.visa_issue_date issue_date,pev.visa_expiry_date expiry_date
47: FROM igs_pe_vst_hist_int vh,
48: igs_ad_interface_all i,
49: igs_pe_visa_int vi,
50: igs_pe_visa pev
51: WHERE vh.interface_visa_id = vi.interface_visa_id

Line 1646: UPDATE igs_pe_vst_hist_int

1642:
1643: p_err_code := NULL;
1644:
1645: IF p_mode IS NULL THEN
1646: UPDATE igs_pe_vst_hist_int
1647: SET status = '1',
1648: error_code = p_err_code
1649: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
1650: END IF;

Line 1662: UPDATE igs_pe_vst_hist_int

1658: CLOSE birth_dt_cur;
1659: END IF;
1660:
1661: IF p_mode IS NULL THEN
1662: UPDATE igs_pe_vst_hist_int
1663: SET status = '3',
1664: error_code = p_err_code
1665: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
1666:

Line 1668: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,p_err_code,'IGS_PE_VST_HIST_INT');

1664: error_code = p_err_code
1665: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
1666:
1667: IF l_enable_log = 'Y' THEN
1668: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,p_err_code,'IGS_PE_VST_HIST_INT');
1669: END IF;
1670: END IF;
1671:
1672: RETURN FALSE;

Line 1675: UPDATE igs_pe_vst_hist_int

1671:
1672: RETURN FALSE;
1673: WHEN OTHERS THEN
1674: IF p_mode IS NULL THEN
1675: UPDATE igs_pe_vst_hist_int
1676: SET status = '3',
1677: error_code = p_err_code
1678: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
1679: END IF;

Line 1704: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,p_err_code,'IGS_PE_VST_HIST_INT');

1700: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1701: END IF;
1702:
1703: IF l_enable_log = 'Y' THEN
1704: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,p_err_code,'IGS_PE_VST_HIST_INT');
1705: END IF;
1706:
1707: RETURN FALSE;
1708: END Validate_visit_histry;

Line 1796: l_dup_pe igs_pe_vst_hist_int.dup_port_of_entry%TYPE;

1792: l_error_code VARCHAR2(30);
1793: l_status VARCHAR2(10);
1794: l_dup_var BOOLEAN;
1795: visit_rec visit_dtls%ROWTYPE;
1796: l_dup_pe igs_pe_vst_hist_int.dup_port_of_entry%TYPE;
1797: l_dup_efn igs_pe_vst_hist_int.dup_cntry_entry_form_num%TYPE;
1798: l_processed_records NUMBER(5) := 0;
1799: -- The below variable will get populated during duplicate check
1800: l_visit_rec chk_duplicate%ROWTYPE;

Line 1797: l_dup_efn igs_pe_vst_hist_int.dup_cntry_entry_form_num%TYPE;

1793: l_status VARCHAR2(10);
1794: l_dup_var BOOLEAN;
1795: visit_rec visit_dtls%ROWTYPE;
1796: l_dup_pe igs_pe_vst_hist_int.dup_port_of_entry%TYPE;
1797: l_dup_efn igs_pe_vst_hist_int.dup_cntry_entry_form_num%TYPE;
1798: l_processed_records NUMBER(5) := 0;
1799: -- The below variable will get populated during duplicate check
1800: l_visit_rec chk_duplicate%ROWTYPE;
1801:

Line 1857: UPDATE igs_pe_vst_hist_int

1853:
1854: -- IF SUCCESSFUL INSERT THEN
1855:
1856: l_error := NULL;
1857: UPDATE igs_pe_vst_hist_int
1858: SET status = '1',
1859: error_code = l_error
1860: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
1861:

Line 1898: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,l_error,'IGS_PE_VST_HIST_INT');

1894:
1895: END IF;
1896:
1897: IF l_enable_log = 'Y' THEN
1898: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,l_error,'IGS_PE_VST_HIST_INT');
1899: END IF;
1900:
1901: UPDATE igs_pe_vst_hist_int
1902: SET status = '3',

Line 1901: UPDATE igs_pe_vst_hist_int

1897: IF l_enable_log = 'Y' THEN
1898: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,l_error,'IGS_PE_VST_HIST_INT');
1899: END IF;
1900:
1901: UPDATE igs_pe_vst_hist_int
1902: SET status = '3',
1903: error_code = l_error
1904: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
1905:

Line 1976: UPDATE igs_pe_vst_hist_int

1972: IF l_message_name = 'IGS_PE_PORT_DATE_OVERLAP' THEN
1973: p_error_code := 'E564';
1974: p_status := '3';
1975:
1976: UPDATE igs_pe_vst_hist_int
1977: SET status = '3',
1978: error_code = 'E014'
1979: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
1980:

Line 1986: UPDATE igs_pe_vst_hist_int

1982:
1983: p_error_code := 'E014';
1984: p_status := '3';
1985:
1986: UPDATE igs_pe_vst_hist_int
1987: SET status = '3',
1988: error_code = 'E014'
1989: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
1990:

Line 2013: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,l_error,'IGS_PE_VST_HIST_INT');

2009: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2010: END IF;
2011:
2012: IF l_enable_log = 'Y' THEN
2013: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,l_error,'IGS_PE_VST_HIST_INT');
2014: END IF;
2015:
2016: END IF;
2017: END upd_pe_visit_histry;

Line 2047: UPDATE igs_pe_vst_hist_int

2043: END IF;
2044:
2045: IF l_rule = 'E' OR l_rule = 'I' THEN
2046:
2047: UPDATE igs_pe_vst_hist_int
2048: SET status='3',
2049: error_code = 'E695'
2050: WHERE
2051: interface_run_id=l_interface_run_id

Line 2058: UPDATE igs_pe_vst_hist_int vh

2054:
2055:
2056: IF l_rule = 'E' THEN
2057:
2058: UPDATE igs_pe_vst_hist_int vh
2059: SET status='1',
2060: match_ind='19'
2061: WHERE interface_run_id=l_interface_run_id
2062: AND STATUS = '2'

Line 2075: UPDATE igs_pe_vst_hist_int vh

2071: END IF;
2072:
2073: ELSIF l_rule = 'R' THEN
2074:
2075: UPDATE igs_pe_vst_hist_int vh
2076: SET status = '1'
2077: WHERE interface_run_id=l_interface_run_id
2078: AND status = '2'
2079: AND match_ind IN ('18','19','22','23')

Line 2085: UPDATE igs_pe_vst_hist_int vh

2081: FROM igs_pe_visa_int vi
2082: WHERE vi.interface_visa_id = vh.interface_visa_id AND
2083: vi.status = '1');
2084:
2085: UPDATE igs_pe_vst_hist_int vh
2086: SET status = '3',
2087: error_code = 'E695'
2088: WHERE interface_run_id=l_interface_run_id
2089: AND status = '2'

Line 2096: UPDATE igs_pe_vst_hist_int vh

2092: FROM igs_pe_visa_int vi
2093: WHERE vi.interface_visa_id = vh.interface_visa_id AND
2094: vi.status = '1');
2095:
2096: UPDATE igs_pe_vst_hist_int vh
2097: SET status='1',
2098: match_ind = '23'
2099: WHERE interface_run_id=l_interface_run_id
2100: AND status = '2'

Line 2137: UPDATE igs_pe_vst_hist_int vh

2133: ((vs.attribute18 = vh.attribute18) OR ((vs.attribute18 IS NULL) AND (vh.attribute18 IS NULL))) AND
2134: ((vs.attribute19 = vh.attribute19) OR ((vs.attribute19 IS NULL) AND (vh.attribute19 IS NULL))) AND
2135: ((vs.attribute20 = vh.attribute20) OR ((vs.attribute20 IS NULL) AND (vh.attribute20 IS NULL))));
2136:
2137: UPDATE igs_pe_vst_hist_int vh
2138: SET status = '3',
2139: match_ind='20',
2140: (dup_port_of_entry,dup_cntry_entry_form_num) = (SELECT port_of_entry,cntry_entry_form_num
2141: FROM igs_pe_visit_histry vs

Line 2187: UPDATE igs_pe_vst_hist_int

2183: dup_visit_rec => l_visit_rec,
2184: p_error_code => l_error_code,
2185: p_status => l_status );
2186:
2187: UPDATE igs_pe_vst_hist_int
2188: SET match_ind = '18', -- MATCH OCCURED AND USED IMPORTED VALUES
2189: status = l_status ,
2190: error_code = l_error_code
2191: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;

Line 2217: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,'E014','IGS_PE_VST_HIST_INT');

2213: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2214: END IF;
2215:
2216: IF l_enable_log = 'Y' THEN
2217: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,'E014','IGS_PE_VST_HIST_INT');
2218: END IF;
2219:
2220: UPDATE igs_pe_vst_hist_int
2221: SET match_ind = '18',

Line 2220: UPDATE igs_pe_vst_hist_int

2216: IF l_enable_log = 'Y' THEN
2217: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,'E014','IGS_PE_VST_HIST_INT');
2218: END IF;
2219:
2220: UPDATE igs_pe_vst_hist_int
2221: SET match_ind = '18',
2222: status = '3',
2223: error_code = 'E014'
2224: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;

Line 2236: UPDATE igs_pe_vst_hist_int

2232: dup_visit_rec => l_visit_rec,
2233: p_error_code => l_error_code,
2234: p_status => l_status);
2235:
2236: UPDATE igs_pe_vst_hist_int
2237: SET status = l_status ,
2238: error_code = l_error_code
2239: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
2240:

Line 2265: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,'E014','IGS_PE_VST_HIST_INT');

2261: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2262: END IF;
2263:
2264: IF l_enable_log = 'Y' THEN
2265: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,'E014','IGS_PE_VST_HIST_INT');
2266: END IF;
2267:
2268: UPDATE igs_pe_vst_hist_int
2269: SET status = '3',

Line 2268: UPDATE igs_pe_vst_hist_int

2264: IF l_enable_log = 'Y' THEN
2265: igs_ad_imp_001.logerrormessage(visit_rec.interface_visit_histry_id,'E014','IGS_PE_VST_HIST_INT');
2266: END IF;
2267:
2268: UPDATE igs_pe_vst_hist_int
2269: SET status = '3',
2270: error_code = 'E014'
2271: WHERE interface_visit_histry_id = visit_rec.interface_visit_histry_id;
2272: END;