APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_HOUSING_INT

Line 1011: UPDATE igs_pe_housing_int phi

1007: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_HOUSING');
1008: END IF;
1009:
1010: -- Populating the child interface table with the interface_run_id value.
1011: UPDATE igs_pe_housing_int phi
1012: SET
1013: interface_run_id=l_interface_run_id
1014: WHERE phi.status='2' AND
1015: EXISTS (SELECT 1

Line 1024: tabname => 'IGS_PE_HOUSING_INT',

1020: ai.interface_run_id=l_interface_run_id);
1021:
1022: -- gather statistics for the table after populating it's interface_run_id
1023: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1024: tabname => 'IGS_PE_HOUSING_INT',
1025: cascade => TRUE);
1026: UPDATE igs_pe_housing_int
1027: SET status = '1'
1028: WHERE match_ind = '22' AND status = '2'

Line 1026: UPDATE igs_pe_housing_int

1022: -- gather statistics for the table after populating it's interface_run_id
1023: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1024: tabname => 'IGS_PE_HOUSING_INT',
1025: cascade => TRUE);
1026: UPDATE igs_pe_housing_int
1027: SET status = '1'
1028: WHERE match_ind = '22' AND status = '2'
1029: AND INTERFACE_RUN_ID = l_interface_run_id;
1030:

Line 1507: -- Delete from the table igs_pe_housing_int

1503:
1504: IF g_person_housing_stat_inc THEN
1505: pe_cat_stats('PERSON_HOUSING_STATUS');
1506:
1507: -- Delete from the table igs_pe_housing_int
1508: DELETE FROM igs_pe_housing_int WHERE
1509: STATUS = '1' AND interface_run_id = l_interface_run_id;
1510:
1511: END IF;

Line 1508: DELETE FROM igs_pe_housing_int WHERE

1504: IF g_person_housing_stat_inc THEN
1505: pe_cat_stats('PERSON_HOUSING_STATUS');
1506:
1507: -- Delete from the table igs_pe_housing_int
1508: DELETE FROM igs_pe_housing_int WHERE
1509: STATUS = '1' AND interface_run_id = l_interface_run_id;
1510:
1511: END IF;
1512:

Line 1594: OR EXISTS (SELECT 1 FROM igs_pe_housing_int ai WHERE ad.interface_id = ai.interface_id)

1590: OR EXISTS (SELECT 1 FROM igs_ad_acadhonor_int_all 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)

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

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:
1970: CURSOR cur_person_acad_honors_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1971: SELECT count(*) count1,status FROM IGS_AD_ACADHONOR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1972:

Line 3683: l_tab := 'IGS_PE_HOUSING_INT';

3679: IF l_warning IS NULL THEN
3680: l_warning := 0;
3681: END IF;
3682: l_total_rec := l_success + l_error + l_warning;
3683: l_tab := 'IGS_PE_HOUSING_INT';
3684: INSERT INTO IGS_AD_IMP_STATS
3685: (
3686: INTERFACE_RUN_ID,
3687: SRC_CAT_CODE,