APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_PRIVACY_INT

Line 1176: UPDATE igs_pe_privacy_int a

1172: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',p_token_name => 'TYPE_NAME',p_token_value => l_meaning);
1173: END IF;
1174:
1175: -- Populating the interface table with the interface_run_id value
1176: UPDATE igs_pe_privacy_int a
1177: SET interface_run_id = l_interface_run_id
1178: WHERE EXISTS (SELECT 1
1179: FROM igs_ad_interface_all
1180: WHERE interface_run_id = l_interface_run_id

Line 1185: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'igs_pe_privacy_int',cascade => TRUE);

1181: AND interface_id = a.interface_id
1182: AND status IN ('1','4'));
1183:
1184: -- Gather statistics of the table
1185: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'igs_pe_privacy_int',cascade => TRUE);
1186:
1187: UPDATE igs_pe_privacy_int iah
1188: SET STATUS = '1'
1189: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 1187: UPDATE igs_pe_privacy_int iah

1183:
1184: -- Gather statistics of the table
1185: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'igs_pe_privacy_int',cascade => TRUE);
1186:
1187: UPDATE igs_pe_privacy_int iah
1188: SET STATUS = '1'
1189: WHERE MATCH_IND = '22' AND STATUS = '2'
1190: AND INTERFACE_RUN_ID = l_interface_run_id;
1191:

Line 1562: DELETE FROM igs_pe_privacy_int WHERE

1558:
1559: IF g_privacy_dtl_inc THEN
1560: pe_cat_stats('PRIVACY_DETAILS');
1561:
1562: DELETE FROM igs_pe_privacy_int WHERE
1563: STATUS = '1' AND interface_run_id = l_interface_run_id;
1564:
1565: END IF;
1566:

Line 1601: OR EXISTS (SELECT 1 FROM igs_pe_privacy_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
1604: COMMIT;
1605:

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

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:
1997: CURSOR cur_privacy_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1998: SELECT count(*) count1,status FROM igs_pe_privacy_int WHERE interface_run_id = p_interface_run_id GROUP BY status;
1999:
2000:
2001: l_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE;
2002: l_success NUMBER;

Line 4161: l_tab := 'IGS_PE_PRIVACY_INT';

4157: IF l_warning IS NULL THEN
4158: l_warning := 0;
4159: END IF;
4160: l_total_rec := l_success + l_error + l_warning;
4161: l_tab := 'IGS_PE_PRIVACY_INT';
4162: INSERT INTO IGS_AD_IMP_STATS
4163: (
4164: INTERFACE_RUN_ID,
4165: SRC_CAT_CODE,