APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_REL_CON_INT_ALL

Line 807: UPDATE igs_ad_rel_con_int_all ari4

803: END IF;
804:
805:
806: IF g_rel_contact_inc THEN
807: UPDATE igs_ad_rel_con_int_all ari4
808: SET
809: interface_run_id=l_interface_run_id
810: WHERE ari4.status='2' AND
811: EXISTS (SELECT 1

Line 821: tabname => 'IGS_AD_REL_CON_INT_ALL',

817: ai.status IN ('1','4') AND
818: ai.interface_run_id=l_interface_run_id);
819: -- gather statistics for the table after populating it's interface_run_id
820: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
821: tabname => 'IGS_AD_REL_CON_INT_ALL',
822: cascade => TRUE);
823: UPDATE IGS_AD_REL_CON_INT_all iarc
824: SET STATUS = '1'
825: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 823: UPDATE IGS_AD_REL_CON_INT_all iarc

819: -- gather statistics for the table after populating it's interface_run_id
820: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
821: tabname => 'IGS_AD_REL_CON_INT_ALL',
822: cascade => TRUE);
823: UPDATE IGS_AD_REL_CON_INT_all iarc
824: SET STATUS = '1'
825: WHERE MATCH_IND = '22' AND STATUS = '2'
826: AND INTERFACE_RUN_ID = l_interface_run_id;
827:

Line 1442: DELETE FROM igs_ad_rel_con_int_all WHERE

1438: IF g_rel_contact_inc THEN
1439: -- call the procedure to store statistics in igs_ad_imp_stats
1440: pe_cat_stats('RELATIONS_CONTACTS');
1441:
1442: DELETE FROM igs_ad_rel_con_int_all WHERE
1443: status = '1' AND interface_run_id = l_interface_run_id;
1444:
1445: END IF;
1446:

Line 1478: OR EXISTS (SELECT 1 FROM igs_ad_rel_con_int_all ai WHERE ad.interface_relations_id = ai.interface_relations_id)

1474: SET status = '4', error_code = 'E347'
1475: WHERE ad.interface_run_id = l_interface_run_id AND
1476: ad.status = '1' AND
1477: ( EXISTS (SELECT 1 FROM igs_ad_relemp_int_all ai WHERE ad.interface_relations_id = ai.interface_relations_id)
1478: OR EXISTS (SELECT 1 FROM igs_ad_rel_con_int_all ai WHERE ad.interface_relations_id = ai.interface_relations_id)
1479: OR EXISTS (SELECT 1 FROM IGS_AD_RELACAD_INT_all ai WHERE ad.interface_relations_ID = ai.interface_relations_ID)
1480: OR EXISTS (SELECT 1 FROM igs_ad_reladdr_int_all ai WHERE ad.interface_relations_ID = ai.interface_relations_ID )
1481: );
1482:

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

1979: CURSOR cur_rel_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1980: SELECT count(*) count1,status FROM IGS_AD_RELADDR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1981:
1982: CURSOR cur_relcon_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1983: SELECT count(*) count1,status FROM IGS_AD_REL_CON_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1984:
1985: CURSOR cur_relemp_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1986: SELECT count(*) count1,status FROM IGS_AD_RELEMP_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1987:

Line 3949: l_tab := 'IGS_AD_REL_CON_INT_ALL';

3945: IF l_warning IS NULL THEN
3946: l_warning := 0;
3947: END IF;
3948: l_total_rec := l_success + l_error + l_warning;
3949: l_tab := 'IGS_AD_REL_CON_INT_ALL';
3950: INSERT INTO IGS_AD_IMP_STATS
3951: (
3952: INTERFACE_RUN_ID,
3953: SRC_CAT_CODE,