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_AD_INTERFACE_ALL

Line 36: igs_ad_interface_all i

32:
33: CURSOR visa_dtls(cp_interface_run_id igs_pe_visa_int.interface_run_id%TYPE) IS
34: SELECT vi.*, i.person_id
35: FROM igs_pe_visa_int vi,
36: igs_ad_interface_all i
37: WHERE vi.interface_id = i.interface_id
38: AND vi.STATUS = '2'
39: AND vi.interface_run_id = cp_interface_run_id
40: AND i.interface_run_id = cp_interface_run_id;

Line 48: igs_ad_interface_all i,

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
52: AND vi.interface_id = i.interface_id

Line 63: igs_ad_interface_all i

59:
60: CURSOR pass_dtls(cp_interface_run_id igs_pe_passport_int.interface_run_id%TYPE) IS
61: SELECT pi.*, i.person_id
62: FROM igs_pe_passport_int pi,
63: igs_ad_interface_all i
64: WHERE pi.interface_id = i.interface_id
65: AND pi.STATUS = '2'
66: AND pi.interface_run_id = cp_interface_run_id
67: AND i.interface_run_id = cp_interface_run_id;

Line 411: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

407: l_label VARCHAR2(100);
408: l_debug_str VARCHAR2(2000);
409: l_enable_log VARCHAR2(1);
410: l_request_id NUMBER;
411: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
412: l_processed_records NUMBER(5) := 0;
413:
414: -- VALIDATE RECORD FUNCTION
415:

Line 708: igs_ad_interface_all ad

704: WHERE interface_run_id=l_interface_run_id
705: AND STATUS = '2'
706: AND EXISTS( SELECT vs.rowid
707: FROM igs_pe_visa vs,
708: igs_ad_interface_all ad
709: WHERE ad.interface_id = vi.interface_id AND
710: ad.interface_run_id = l_interface_run_id AND
711: vs.person_id = ad.person_id AND
712: vs.visa_type = UPPER(vi.visa_type) AND

Line 742: igs_ad_interface_all ad

738: AND status = '2'
739: AND match_ind IS NULL
740: AND EXISTS( SELECT vs.rowid
741: FROM igs_pe_visa vs,
742: igs_ad_interface_all ad
743: WHERE ad.interface_id = vi.interface_id AND
744: ad.interface_run_id = l_interface_run_id AND
745: vs.visa_type = UPPER(vi.visa_type) AND
746: UPPER(vs.visa_number) = UPPER(vi.visa_number) AND

Line 784: igs_ad_interface_all ad

780: SET status = '3',
781: match_ind='20',
782: dup_visa_id = (SELECT visa_id
783: FROM igs_pe_visa vs,
784: igs_ad_interface_all ad
785: WHERE ad.interface_id = vi.interface_id AND
786: ad.interface_run_id = l_interface_run_id AND
787: vs.person_id = ad.person_id AND
788: vs.visa_type = UPPER(vi.visa_type) AND

Line 796: igs_ad_interface_all ad

792: status = '2' AND
793: match_ind IS NULL AND
794: EXISTS (SELECT vs.rowid
795: FROM igs_pe_visa vs,
796: igs_ad_interface_all ad
797: WHERE ad.interface_id = vi.interface_id AND
798: ad.interface_run_id = l_interface_run_id AND
799: vs.person_id = ad.person_id AND
800: vs.visa_type = UPPER(vi.visa_type) AND

Line 1097: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

1093: l_label VARCHAR2(100);
1094: l_debug_str VARCHAR2(2000);
1095: l_enable_log VARCHAR2(1);
1096: l_request_id NUMBER;
1097: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
1098:
1099: PROCEDURE crt_pe_pass(pass_rec IN pass_dtls%ROWTYPE,
1100: error_code OUT NOCOPY VARCHAR2,
1101: status OUT NOCOPY VARCHAR2)

Line 1333: igs_ad_interface_all ad

1329: interface_run_id=l_interface_run_id
1330: AND STATUS = '2'
1331: AND EXISTS( SELECT ps.rowid
1332: FROM igs_pe_passport ps,
1333: igs_ad_interface_all ad
1334: WHERE ad.interface_id = pi.interface_id AND
1335: ad.interface_run_id = l_interface_run_id AND
1336: ps.person_id = ad.person_id AND
1337: ps.passport_cntry_code = UPPER(pi.passport_cntry_code) AND

Line 1367: igs_ad_interface_all ad

1363: AND status = '2'
1364: AND match_ind IS NULL
1365: AND EXISTS( SELECT ps.rowid
1366: FROM igs_pe_passport ps,
1367: igs_ad_interface_all ad
1368: WHERE ad.interface_id = pi.interface_id AND
1369: ad.interface_run_id = l_interface_run_id AND
1370: ps.person_id = ad.person_id AND
1371: ps.passport_cntry_code = UPPER(pi.passport_cntry_code) AND

Line 1401: igs_ad_interface_all ad

1397: SET status = '3',
1398: match_ind='20',
1399: dup_passport_id = (SELECT passport_id
1400: FROM igs_pe_passport ps,
1401: igs_ad_interface_all ad
1402: WHERE ad.interface_id = pi.interface_id AND
1403: ad.interface_run_id = l_interface_run_id AND
1404: ps.person_id = ad.person_id AND
1405: ps.passport_cntry_code = UPPER(pi.passport_cntry_code) AND

Line 1412: igs_ad_interface_all ad

1408: status = '2' AND
1409: match_ind IS NULL AND
1410: EXISTS (SELECT ps.rowid
1411: FROM igs_pe_passport ps,
1412: igs_ad_interface_all ad
1413: WHERE ad.interface_id = pi.interface_id AND
1414: ps.person_id = ad.person_id AND
1415: ad.interface_run_id = l_interface_run_id AND
1416: ps.passport_cntry_code = UPPER(pi.passport_cntry_code) AND

Line 1807: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

1803: l_label VARCHAR2(100);
1804: l_debug_str VARCHAR2(2000);
1805: l_enable_log VARCHAR2(1);
1806: l_request_id NUMBER;
1807: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
1808:
1809: PROCEDURE crt_pe_visit_histry(visit_rec IN visit_dtls%ROWTYPE,
1810: error_code OUT NOCOPY VARCHAR2,
1811: status OUT NOCOPY VARCHAR2)

Line 2328: igs_ad_interface_all i

2324: cp_information_type igs_pe_eit_int.information_type%TYPE) IS
2325:
2326: SELECT ei.*, i.person_id
2327: FROM igs_pe_eit_int ei,
2328: igs_ad_interface_all i
2329: WHERE ei.interface_id = i.interface_id
2330: AND ei.STATUS = cp_ei_status_2
2331: AND ei.interface_run_id = cp_interface_run_id
2332: AND i.interface_run_id = cp_interface_run_id

Line 2352: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

2348: l_label VARCHAR2(100);
2349: l_debug_str VARCHAR2(2000);
2350: l_enable_log VARCHAR2(1);
2351: l_request_id NUMBER;
2352: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
2353:
2354: FUNCTION validate_record(eit_rec IN eit_dtls%ROWTYPE)
2355: RETURN BOOLEAN IS
2356:

Line 2732: igs_ad_interface_all ad

2728: AND STATUS = '2'
2729: AND UPPER(information_type) ='PE_INT_PERM_RES'
2730: AND EXISTS( SELECT es.rowid
2731: FROM igs_pe_eit es,
2732: igs_ad_interface_all ad
2733: WHERE ad.interface_id = ei.interface_id AND
2734: es.person_id = ad.person_id AND
2735: ad.interface_run_id = l_interface_run_id AND
2736: es.information_type = UPPER(ei.information_type) AND

Line 2766: igs_ad_interface_all ad

2762: AND UPPER(information_type) ='PE_INT_PERM_RES'
2763: AND match_ind IS NULL
2764: AND EXISTS( SELECT es.rowid
2765: FROM igs_pe_eit es,
2766: igs_ad_interface_all ad
2767: WHERE ad.interface_id = ei.interface_id AND
2768: es.person_id = ad.person_id AND
2769: ad.interface_run_id = l_interface_run_id AND
2770: es.information_type = UPPER(ei.information_type) AND

Line 2784: igs_ad_interface_all ad

2780: SET status = '3',
2781: match_ind='20',
2782: dup_pe_eit_id = (SELECT pe_eit_id
2783: FROM igs_pe_eit es,
2784: igs_ad_interface_all ad
2785: WHERE ad.interface_id = ei.interface_id AND
2786: es.person_id = ad.person_id AND
2787: ad.interface_run_id = l_interface_run_id AND
2788: es.information_type = UPPER(ei.information_type) AND

Line 2796: igs_ad_interface_all ad

2792: information_type ='PE_INT_PERM_RES' AND
2793: match_ind IS NULL AND
2794: EXISTS (SELECT es.rowid
2795: FROM igs_pe_eit es,
2796: igs_ad_interface_all ad
2797: WHERE ad.interface_id = ei.interface_id AND
2798: es.person_id = ad.person_id AND
2799: ad.interface_run_id = l_interface_run_id AND
2800: es.information_type = UPPER(ei.information_type) AND

Line 2983: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

2979: l_label VARCHAR2(100);
2980: l_debug_str VARCHAR2(2000);
2981: l_enable_log VARCHAR2(1);
2982: l_request_id NUMBER;
2983: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
2984:
2985: CURSOR addr_cur(cp_interface_run_id igs_ad_addr_int_all.interface_run_id%TYPE) IS
2986: SELECT ai.*, i.person_id
2987: FROM igs_ad_addr_int_all ai, igs_ad_interface_all i

Line 2987: FROM igs_ad_addr_int_all ai, igs_ad_interface_all i

2983: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
2984:
2985: CURSOR addr_cur(cp_interface_run_id igs_ad_addr_int_all.interface_run_id%TYPE) IS
2986: SELECT ai.*, i.person_id
2987: FROM igs_ad_addr_int_all ai, igs_ad_interface_all i
2988: WHERE ai.status = '2' AND
2989: i.interface_run_id = cp_interface_run_id AND
2990: ai.interface_id = i.interface_id AND
2991: i.status = '1';

Line 3056: igs_ad_interface_all ad,

3052: WHERE interface_run_id=l_interface_run_id
3053: AND STATUS = '2'
3054: AND EXISTS( SELECT hs.rowid
3055: FROM hz_party_sites hs,
3056: igs_ad_interface_all ad,
3057: hz_locations hl
3058: WHERE ad.interface_id = ai.interface_id AND
3059: hs.party_id = ad.person_id AND
3060: hs.location_id = hl.location_id AND

Line 3096: igs_ad_interface_all ad

3092: AND match_ind IS NULL
3093: AND EXISTS( SELECT hs.rowid
3094: FROM hz_locations hl,
3095: hz_party_sites hs,
3096: igs_ad_interface_all ad
3097: WHERE ad.interface_id = ai.interface_id AND
3098: hs.party_id = ad.person_id AND
3099: hs.location_id = hl.location_id AND
3100: NVL(UPPER(hl.address1), 'X') = NVL(UPPER(ai.addr_line_1), 'X') AND

Line 3117: igs_ad_interface_all ad,

3113: SET status = '3',
3114: match_ind='20',
3115: dup_party_site_id = (SELECT hs.party_site_id
3116: FROM hz_party_sites hs,
3117: igs_ad_interface_all ad,
3118: hz_locations hl
3119: WHERE ad.interface_id = ai.interface_id AND
3120: ROWNUM = 1 AND
3121: hs.party_id = ad.person_id AND

Line 3137: igs_ad_interface_all ad,

3133: status = '2' AND
3134: match_ind IS NULL AND
3135: EXISTS (SELECT hs.rowid
3136: FROM hz_party_sites hs,
3137: igs_ad_interface_all ad,
3138: hz_locations hl
3139: WHERE ad.interface_id = ai.interface_id AND
3140: hs.party_id = ad.person_id AND
3141: hs.location_id = hl.location_id AND