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_PE_PERS_IMP_001 dependencies on IGS_PE_VISA_INT

Line 458: UPDATE IGS_PE_VISA_INT pvi

454: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_INTL_DTL');
455: END IF;
456:
457: -- Populating the child interface table with the interface_run_id value.
458: UPDATE IGS_PE_VISA_INT pvi
459: SET
460: interface_run_id=l_interface_run_id
461: WHERE pvi.status IN ('1','2') AND
462: EXISTS (SELECT 1

Line 471: tabname => 'IGS_PE_VISA_INT',

467: ai.interface_run_id=l_interface_run_id);
468:
469: -- gather statistics for the table after populating it's interface_run_id
470: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
471: tabname => 'IGS_PE_VISA_INT',
472: cascade => TRUE);
473:
474: UPDATE IGS_PE_VISA_INT SET STATUS = '1'
475: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 474: UPDATE IGS_PE_VISA_INT SET STATUS = '1'

470: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
471: tabname => 'IGS_PE_VISA_INT',
472: cascade => TRUE);
473:
474: UPDATE IGS_PE_VISA_INT SET STATUS = '1'
475: WHERE MATCH_IND = '22' AND STATUS = '2'
476: AND INTERFACE_RUN_ID = l_interface_run_id;
477:
478: -- Populating the child interface table with the interface_run_id value.

Line 505: IGS_PE_VISA_INT pi

501: interface_run_id=l_interface_run_id
502: WHERE pvhi.status='2' AND
503: EXISTS (SELECT 1
504: FROM igs_ad_interface_all ai,
505: IGS_PE_VISA_INT pi
506: WHERE
507: pi.INTERFACE_VISA_ID=pvhi.INTERFACE_VISA_ID AND
508: ai.interface_id=pi.interface_id AND
509: ai.status IN ('1','4') AND

Line 1346: UPDATE igs_pe_visa_int ad

1342:
1343: DELETE FROM IGS_PE_VST_HIST_INT WHERE
1344: STATUS = '1' AND interface_run_id = l_interface_run_id;
1345:
1346: UPDATE igs_pe_visa_int ad
1347: SET status = '4', error_code = 'E347'
1348: WHERE ad.interface_run_id = l_interface_run_id AND
1349: ad.status = '1' AND
1350: EXISTS (SELECT 1 FROM igs_pe_vst_hist_int ai WHERE ad.interface_visa_id = ai.interface_visa_id);

Line 1352: -- DELETE FROM TABLE IGS_PE_VISA_INT

1348: WHERE ad.interface_run_id = l_interface_run_id AND
1349: ad.status = '1' AND
1350: EXISTS (SELECT 1 FROM igs_pe_vst_hist_int ai WHERE ad.interface_visa_id = ai.interface_visa_id);
1351:
1352: -- DELETE FROM TABLE IGS_PE_VISA_INT
1353: DELETE FROM IGS_PE_VISA_INT WHERE
1354: STATUS = '1' AND interface_run_id = l_interface_run_id;
1355:
1356: DELETE FROM IGS_PE_PASSPORT_INT WHERE

Line 1353: DELETE FROM IGS_PE_VISA_INT WHERE

1349: ad.status = '1' AND
1350: EXISTS (SELECT 1 FROM igs_pe_vst_hist_int ai WHERE ad.interface_visa_id = ai.interface_visa_id);
1351:
1352: -- DELETE FROM TABLE IGS_PE_VISA_INT
1353: DELETE FROM IGS_PE_VISA_INT WHERE
1354: STATUS = '1' AND interface_run_id = l_interface_run_id;
1355:
1356: DELETE FROM IGS_PE_PASSPORT_INT WHERE
1357: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1581: OR EXISTS (SELECT 1 FROM igs_pe_visa_int ai WHERE ad.interface_id = ai.interface_id)

1577: OR EXISTS (SELECT 1 FROM igs_pe_type_int ai WHERE ad.interface_id = ai.interface_id)
1578: OR EXISTS (SELECT 1 FROM igs_ad_alias_int_all ai WHERE ad.interface_id = ai.interface_id)
1579: OR EXISTS (SELECT 1 FROM igs_ad_disablty_int_all ai WHERE ad.interface_id = ai.interface_id)
1580: OR EXISTS (SELECT 1 FROM igs_ad_emp_int_all ai WHERE ad.interface_id = ai.interface_id)
1581: OR EXISTS (SELECT 1 FROM igs_pe_visa_int ai WHERE ad.interface_id = ai.interface_id)
1582: OR EXISTS (SELECT 1 FROM igs_pe_passport_int ai WHERE ad.interface_id = ai.interface_id)
1583: OR EXISTS (SELECT 1 FROM igs_pe_citizen_int ai WHERE ad.interface_id = ai.interface_id)
1584: OR EXISTS (SELECT 1 FROM igs_pe_fund_src_int ai WHERE ad.interface_id = ai.interface_id)
1585: OR EXISTS (SELECT 1 FROM igs_ad_hlth_ins_int_all ai WHERE ad.interface_id = ai.interface_id)

Line 1916: SELECT count(*) count1,status FROM IGS_PE_VISA_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;

1912: CURSOR cur_person_emp_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1913: SELECT count(*) count1,status FROM IGS_AD_EMP_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1914:
1915: CURSOR cur_person_visa_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1916: SELECT count(*) count1,status FROM IGS_PE_VISA_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1917:
1918: CURSOR cur_person_passport_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1919: SELECT count(*) count1,status FROM IGS_PE_PASSPORT_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1920:

Line 2752: l_tab := 'IGS_PE_VISA_INT';

2748: l_warning := 0;
2749: END IF;
2750:
2751: l_total_rec := l_success + l_error + l_warning;
2752: l_tab := 'IGS_PE_VISA_INT';
2753: INSERT INTO IGS_AD_IMP_STATS
2754: (
2755: INTERFACE_RUN_ID,
2756: SRC_CAT_CODE,