APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_RELADDR_INT_ALL

Line 734: UPDATE igs_ad_reladdr_int_all ari1

730: AND INTERFACE_RUN_ID = l_interface_run_id;
731:
732: IF g_rel_addr_inc THEN
733:
734: UPDATE igs_ad_reladdr_int_all ari1
735: SET interface_run_id=l_interface_run_id
736: WHERE ari1.status='2' AND
737: EXISTS (SELECT 1
738: FROM igs_ad_interface_all ai,

Line 748: tabname => 'IGS_AD_RELADDR_INT_ALL',

744: ai.interface_run_id=l_interface_run_id);
745:
746: -- gather statistics for the table after populating it's interface_run_id
747: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
748: tabname => 'IGS_AD_RELADDR_INT_ALL',
749: cascade => TRUE);
750: UPDATE IGS_AD_RELADDR_INT_all iara
751: SET STATUS = '1'
752: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 750: UPDATE IGS_AD_RELADDR_INT_all iara

746: -- gather statistics for the table after populating it's interface_run_id
747: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
748: tabname => 'IGS_AD_RELADDR_INT_ALL',
749: cascade => TRUE);
750: UPDATE IGS_AD_RELADDR_INT_all iara
751: SET STATUS = '1'
752: WHERE MATCH_IND = '22' AND STATUS = '2'
753: AND INTERFACE_RUN_ID = l_interface_run_id;
754:

Line 1452: DELETE FROM igs_ad_reladdr_int_all WHERE

1448: IF g_rel_addr_inc THEN
1449:
1450: pe_cat_stats('RELATIONS_ADDRESS');
1451:
1452: DELETE FROM igs_ad_reladdr_int_all WHERE
1453: status = '1' AND interface_run_id = l_interface_run_id;
1454:
1455: END IF;
1456:

Line 1480: OR EXISTS (SELECT 1 FROM igs_ad_reladdr_int_all ai WHERE ad.interface_relations_ID = ai.interface_relations_ID )

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:
1483: DELETE FROM IGS_AD_RELATIONS_INT_all WHERE
1484: STATUS = '1' AND interface_run_id = l_interface_run_id;

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

1976: CURSOR cur_relacad_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1977: SELECT count(*) count1,status FROM IGS_AD_RELACAD_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1978:
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:

Line 3897: l_tab := 'IGS_AD_RELADDR_INT_ALL';

3893: l_warning := 0;
3894: END IF;
3895:
3896: l_total_rec := l_success + l_error + l_warning;
3897: l_tab := 'IGS_AD_RELADDR_INT_ALL';
3898: INSERT INTO IGS_AD_IMP_STATS
3899: (
3900: INTERFACE_RUN_ID,
3901: SRC_CAT_CODE,