APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_HEAR_DTL_INT

Line 980: UPDATE igs_pe_hear_dtl_int phi

976: SET status = '1'
977: WHERE match_ind = '22' AND status = '2'
978: AND INTERFACE_RUN_ID = l_interface_run_id;
979:
980: UPDATE igs_pe_hear_dtl_int phi
981: SET
982: interface_run_id=l_interface_run_id
983: WHERE phi.status='2' AND
984: EXISTS (SELECT 1

Line 992: tabname => 'IGS_PE_HEAR_DTL_INT',

988: ai.status IN ('1','4') AND
989: ai.interface_run_id=l_interface_run_id);
990: -- gather statistics for the table after populating it's interface_run_id
991: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
992: tabname => 'IGS_PE_HEAR_DTL_INT',
993: cascade => TRUE);
994: UPDATE igs_pe_hear_dtl_int
995: SET status = '1'
996: WHERE match_ind = '22' AND status = '2'

Line 994: UPDATE igs_pe_hear_dtl_int

990: -- gather statistics for the table after populating it's interface_run_id
991: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
992: tabname => 'IGS_PE_HEAR_DTL_INT',
993: cascade => TRUE);
994: UPDATE igs_pe_hear_dtl_int
995: SET status = '1'
996: WHERE match_ind = '22' AND status = '2'
997: AND INTERFACE_RUN_ID = l_interface_run_id;
998:

Line 1521: -- Delete from the table igs_pe_hear_dtl_int

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
1523: STATUS = '1' AND interface_run_id = l_interface_run_id;
1524:
1525: END IF;

Line 1522: DELETE FROM igs_pe_hear_dtl_int WHERE

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
1523: STATUS = '1' AND interface_run_id = l_interface_run_id;
1524:
1525: END IF;
1526:

Line 1596: OR EXISTS (SELECT 1 FROM igs_pe_hear_dtl_int 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)
1600: OR EXISTS (SELECT 1 FROM igs_ad_acadhis_int_all ai WHERE ad.interface_id = ai.interface_id)

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

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:
1967: CURSOR cur_person_housing_stat_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1968: SELECT count(*) count1,status FROM IGS_PE_HOUSING_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1969:

Line 3630: l_tab := 'IGS_PE_HEAR_DTL_INT';

3626: l_warning := 0;
3627: END IF;
3628:
3629: l_total_rec := l_success + l_error + l_warning;
3630: l_tab := 'IGS_PE_HEAR_DTL_INT';
3631: INSERT INTO IGS_AD_IMP_STATS
3632: (
3633: INTERFACE_RUN_ID,
3634: SRC_CAT_CODE,