APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_CRED_INT

Line 1114: UPDATE igs_pe_Cred_int a

1110: p_token_value => l_meaning);
1111: END IF;
1112:
1113: -- Populating the interface table with the interface_run_id value
1114: UPDATE igs_pe_Cred_int a
1115: SET interface_run_id = l_interface_run_id
1116: WHERE EXISTS (SELECT 1
1117: FROM igs_ad_interface_all
1118: WHERE interface_run_id = l_interface_run_id

Line 1124: tabname => 'IGS_PE_CRED_INT',

1120: AND status IN ('1','4'));
1121:
1122: -- Gather statistics of the table
1123: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
1124: tabname => 'IGS_PE_CRED_INT',
1125: cascade => TRUE);
1126:
1127: -- Call category entity import procedure
1128: igs_ad_imp_013.prc_pe_cred_details (p_interface_run_id => l_interface_run_id,

Line 1546: DELETE FROM IGS_PE_CRED_INT WHERE

1542:
1543: IF g_person_creds_inc THEN
1544: pe_cat_stats('PERSON_CREDENTIALS');
1545:
1546: DELETE FROM IGS_PE_CRED_INT WHERE
1547: STATUS = '1' AND interface_run_id = l_interface_run_id;
1548:
1549: END IF;
1550:

Line 1599: OR EXISTS (SELECT 1 FROM igs_pe_cred_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)
1601: OR EXISTS (SELECT 1 FROM igs_pe_privacy_int ai WHERE ad.interface_id = ai.interface_id));
1602:
1603: -- Commit all the transactions

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

1988: CURSOR cur_ad_interface_all (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1989: SELECT count(*) count1,status FROM IGS_AD_INTERFACE_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1990:
1991: CURSOR cur_cred_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1992: SELECT count(*) count1,status FROM igs_pe_cred_int WHERE interface_run_id = p_interface_run_id GROUP BY status;
1993:
1994: CURSOR cur_acadhis_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1995: SELECT count(*) count1,status FROM igs_ad_acadhis_int_all WHERE interface_run_id = p_interface_run_id GROUP BY status;
1996:

Line 4055: l_tab := 'IGS_PE_CRED_INT';

4051: IF l_warning IS NULL THEN
4052: l_warning := 0;
4053: END IF;
4054: l_total_rec := l_success + l_error + l_warning;
4055: l_tab := 'IGS_PE_CRED_INT';
4056: INSERT INTO IGS_AD_IMP_STATS
4057: (
4058: INTERFACE_RUN_ID,
4059: SRC_CAT_CODE,