APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_VST_HIST_INT

Line 499: UPDATE IGS_PE_VST_HIST_INT pvhi

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.
499: UPDATE IGS_PE_VST_HIST_INT pvhi
500: SET
501: interface_run_id=l_interface_run_id
502: WHERE pvhi.status='2' AND
503: EXISTS (SELECT 1

Line 514: tabname => 'IGS_PE_VST_HIST_INT',

510: ai.interface_run_id=l_interface_run_id);
511:
512: -- gather statistics for the table after populating it's interface_run_id
513: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
514: tabname => 'IGS_PE_VST_HIST_INT',
515: cascade => TRUE);
516:
517: UPDATE IGS_PE_VST_HIST_INT SET STATUS = '1'
518: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 517: UPDATE IGS_PE_VST_HIST_INT SET STATUS = '1'

513: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
514: tabname => 'IGS_PE_VST_HIST_INT',
515: cascade => TRUE);
516:
517: UPDATE IGS_PE_VST_HIST_INT SET STATUS = '1'
518: WHERE MATCH_IND = '22' AND STATUS = '2'
519: AND INTERFACE_RUN_ID = l_interface_run_id;
520:
521: -- Populating the child interface table with the interface_run_id value.

Line 1343: DELETE FROM IGS_PE_VST_HIST_INT WHERE

1339: IF g_person_int_dtl_inc THEN
1340: -- call the procedure to store statistics in igs_ad_imp_stats
1341: pe_cat_stats('PERSON_INTERNATIONAL_DETAILS');
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'

Line 1350: EXISTS (SELECT 1 FROM igs_pe_vst_hist_int ai WHERE ad.interface_visa_id = ai.interface_visa_id);

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);
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;

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

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:
1924: CURSOR cur_person_eit_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE,p_information_type VARCHAR2) IS
1925: SELECT count(*) count1,status FROM IGS_PE_EIT_INT WHERE interface_run_id = p_interface_run_id AND
1926: information_type = p_information_type GROUP BY status;

Line 2864: l_tab := 'IGS_PE_VST_HIST_INT';

2860: l_warning := 0;
2861: END IF;
2862:
2863: l_total_rec := l_success + l_error + l_warning;
2864: l_tab := 'IGS_PE_VST_HIST_INT';
2865: INSERT INTO IGS_AD_IMP_STATS
2866: (
2867: INTERFACE_RUN_ID,
2868: SRC_CAT_CODE,