APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_FLNY_DTL_INT

Line 961: UPDATE igs_pe_flny_dtl_int pfi

957: END IF;
958:
959: -- Update interface tables for Felony and hearing details.
960:
961: UPDATE igs_pe_flny_dtl_int pfi
962: SET
963: interface_run_id=l_interface_run_id
964: WHERE pfi.status='2' AND
965: EXISTS (SELECT 1

Line 973: tabname => 'IGS_PE_FLNY_DTL_INT',

969: ai.status IN ('1','4') AND
970: ai.interface_run_id=l_interface_run_id);
971: -- gather statistics for the table after populating it's interface_run_id
972: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
973: tabname => 'IGS_PE_FLNY_DTL_INT',
974: cascade => TRUE);
975: UPDATE igs_pe_flny_dtl_int
976: SET status = '1'
977: WHERE match_ind = '22' AND status = '2'

Line 975: UPDATE igs_pe_flny_dtl_int

971: -- gather statistics for the table after populating it's interface_run_id
972: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
973: tabname => 'IGS_PE_FLNY_DTL_INT',
974: cascade => TRUE);
975: UPDATE igs_pe_flny_dtl_int
976: SET status = '1'
977: WHERE match_ind = '22' AND status = '2'
978: AND INTERFACE_RUN_ID = l_interface_run_id;
979:

Line 1517: -- Delete from the table igs_pe_flny_dtl_int

1513:
1514: IF g_person_disc_dtls_inc THEN
1515: pe_cat_stats('PERSON_DISCIPLINARY_DTLS');
1516:
1517: -- Delete from the table igs_pe_flny_dtl_int
1518: DELETE FROM igs_pe_flny_dtl_int WHERE
1519: STATUS = '1' AND interface_run_id = l_interface_run_id;
1520:
1521: -- Delete from the table igs_pe_hear_dtl_int

Line 1518: DELETE FROM igs_pe_flny_dtl_int WHERE

1514: IF g_person_disc_dtls_inc THEN
1515: pe_cat_stats('PERSON_DISCIPLINARY_DTLS');
1516:
1517: -- Delete from the table igs_pe_flny_dtl_int
1518: DELETE FROM igs_pe_flny_dtl_int WHERE
1519: STATUS = '1' AND interface_run_id = l_interface_run_id;
1520:
1521: -- Delete from the table igs_pe_hear_dtl_int
1522: DELETE FROM igs_pe_hear_dtl_int WHERE

Line 1595: OR EXISTS (SELECT 1 FROM igs_pe_flny_dtl_int ai WHERE ad.interface_id = ai.interface_id)

1591: OR EXISTS (SELECT 1 FROM igs_ad_relations_int_all ai WHERE ad.interface_id = ai.interface_id)
1592: OR EXISTS (SELECT 1 FROM igs_pe_ath_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1593: OR EXISTS (SELECT 1 FROM igs_pe_ath_prg_int ai WHERE ad.interface_id = ai.interface_id)
1594: OR EXISTS (SELECT 1 FROM igs_pe_housing_int ai WHERE ad.interface_id = ai.interface_id)
1595: OR EXISTS (SELECT 1 FROM igs_pe_flny_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1596: OR EXISTS (SELECT 1 FROM igs_pe_hear_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1597: OR EXISTS (SELECT 1 FROM igs_ad_contacts_int_all ai WHERE ad.interface_id = ai.interface_id)
1598: OR EXISTS (SELECT 1 FROM igs_ad_language_int_all ai WHERE ad.interface_id = ai.interface_id)
1599: OR EXISTS (SELECT 1 FROM igs_pe_cred_int ai WHERE ad.interface_id = ai.interface_id)

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

1958: CURSOR cur_person_contact_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1959: SELECT count(*) count1,status FROM IGS_AD_CONTACTS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1960:
1961: CURSOR cur_person_flny_dtls_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1962: SELECT count(*) count1,status FROM IGS_PE_FLNY_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1963:
1964: CURSOR cur_person_hear_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1965: SELECT count(*) count1,status FROM IGS_PE_HEAR_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1966:

Line 3574: l_tab := 'IGS_PE_FLNY_DTL_INT';

3570: l_warning := 0;
3571: END IF;
3572:
3573: l_total_rec := l_success + l_error + l_warning;
3574: l_tab := 'IGS_PE_FLNY_DTL_INT';
3575: INSERT INTO IGS_AD_IMP_STATS
3576: (
3577: INTERFACE_RUN_ID,
3578: SRC_CAT_CODE,