APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_PASSPORT_INT

Line 479: UPDATE IGS_PE_PASSPORT_INT ppi

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.
479: UPDATE IGS_PE_PASSPORT_INT ppi
480: SET
481: interface_run_id=l_interface_run_id
482: WHERE ppi.status='2' AND
483: EXISTS (SELECT 1

Line 492: tabname => 'IGS_PE_PASSPORT_INT',

488: ai.interface_run_id=l_interface_run_id);
489:
490: -- gather statistics for the table after populating it's interface_run_id
491: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
492: tabname => 'IGS_PE_PASSPORT_INT',
493: cascade => TRUE);
494: UPDATE IGS_PE_PASSPORT_INT SET STATUS = '1'
495: WHERE MATCH_IND = '22' AND STATUS = '2'
496: AND INTERFACE_RUN_ID = l_interface_run_id;

Line 494: UPDATE IGS_PE_PASSPORT_INT SET STATUS = '1'

490: -- gather statistics for the table after populating it's interface_run_id
491: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
492: tabname => 'IGS_PE_PASSPORT_INT',
493: cascade => TRUE);
494: UPDATE IGS_PE_PASSPORT_INT SET STATUS = '1'
495: WHERE MATCH_IND = '22' AND STATUS = '2'
496: AND INTERFACE_RUN_ID = l_interface_run_id;
497:
498: -- Populating the child interface table with the interface_run_id value.

Line 1356: DELETE FROM IGS_PE_PASSPORT_INT WHERE

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;
1358:
1359: DELETE FROM igs_pe_citizen_int WHERE
1360: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1582: OR EXISTS (SELECT 1 FROM igs_pe_passport_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)
1586: OR EXISTS (SELECT 1 FROM igs_pe_immu_dtl_int ai WHERE ad.interface_id = ai.interface_id)

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

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:
1921: CURSOR cur_person_hist_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1922: SELECT count(*) count1,status FROM IGS_PE_VST_HIST_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1923:

Line 2808: l_tab := 'IGS_PE_PASSPORT_INT';

2804: l_warning := 0;
2805: END IF;
2806:
2807: l_total_rec := l_success + l_error + l_warning;
2808: l_tab := 'IGS_PE_PASSPORT_INT';
2809: INSERT INTO IGS_AD_IMP_STATS
2810: (
2811: INTERFACE_RUN_ID,
2812: SRC_CAT_CODE,