APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_RELACAD_INT_ALL

Line 783: UPDATE Igs_Ad_Relacad_Int_all ari3

779:
780:
781: IF g_rel_acad_hist_inc THEN
782:
783: UPDATE Igs_Ad_Relacad_Int_all ari3
784: SET interface_run_id=l_interface_run_id
785: WHERE ari3.status='2' AND
786: EXISTS (SELECT 1
787: FROM igs_ad_interface_all ai,

Line 796: tabname => 'IGS_AD_RELACAD_INT_ALL',

792: ai.interface_run_id=l_interface_run_id);
793:
794: -- gather statistics for the table after populating it's interface_run_id
795: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
796: tabname => 'IGS_AD_RELACAD_INT_ALL',
797: cascade => TRUE);
798: UPDATE IGS_AD_RELACAD_INT_ALL iara
799: SET STATUS = '1'
800: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 798: UPDATE IGS_AD_RELACAD_INT_ALL iara

794: -- gather statistics for the table after populating it's interface_run_id
795: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
796: tabname => 'IGS_AD_RELACAD_INT_ALL',
797: cascade => TRUE);
798: UPDATE IGS_AD_RELACAD_INT_ALL iara
799: SET STATUS = '1'
800: WHERE MATCH_IND = '22' AND STATUS = '2'
801: AND INTERFACE_RUN_ID = l_interface_run_id;
802:

Line 1461: DELETE FROM IGS_AD_RELACAD_INT_all WHERE

1457: IF g_rel_acad_hist_inc THEN
1458: -- call the procedure to store statistics in igs_ad_imp_stats
1459: pe_cat_stats('RELATIONS_ACAD_HISTORY');
1460:
1461: DELETE FROM IGS_AD_RELACAD_INT_all WHERE
1462: STATUS = '1' AND interface_run_id = l_interface_run_id;
1463:
1464: END IF;
1465:

Line 1479: OR EXISTS (SELECT 1 FROM IGS_AD_RELACAD_INT_all ai WHERE ad.interface_relations_ID = ai.interface_relations_ID)

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:
1483: DELETE FROM IGS_AD_RELATIONS_INT_all WHERE

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

1973: CURSOR cur_person_res_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1974: SELECT count(*) count1,status FROM IGS_PE_RES_DTLS_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1975:
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:

Line 3844: l_tab := 'IGS_AD_RELACAD_INT_ALL';

3840: l_warning := 0;
3841: END IF;
3842:
3843: l_total_rec := l_success + l_error + l_warning;
3844: l_tab := 'IGS_AD_RELACAD_INT_ALL';
3845: INSERT INTO IGS_AD_IMP_STATS
3846: (
3847: INTERFACE_RUN_ID,
3848: SRC_CAT_CODE,