APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_RELEMP_INT_ALL

Line 758: UPDATE igs_ad_relemp_int_all ari2

754:
755: END IF;
756:
757: IF g_rel_empl_dtl_inc THEN
758: UPDATE igs_ad_relemp_int_all ari2
759: SET interface_run_id=l_interface_run_id
760: WHERE ari2.status='2' AND
761: EXISTS (SELECT 1
762: FROM igs_ad_interface_all ai,

Line 771: tabname => 'IGS_AD_RELEMP_INT_ALL',

767: ai.interface_run_id=l_interface_run_id);
768:
769: -- gather statistics for the table after populating it's interface_run_id
770: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
771: tabname => 'IGS_AD_RELEMP_INT_ALL',
772: cascade => TRUE);
773: UPDATE IGS_AD_RELEMP_INT_all ire
774: SET STATUS = '1'
775: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 773: UPDATE IGS_AD_RELEMP_INT_all ire

769: -- gather statistics for the table after populating it's interface_run_id
770: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
771: tabname => 'IGS_AD_RELEMP_INT_ALL',
772: cascade => TRUE);
773: UPDATE IGS_AD_RELEMP_INT_all ire
774: SET STATUS = '1'
775: WHERE MATCH_IND = '22' AND STATUS = '2'
776: AND INTERFACE_RUN_ID = l_interface_run_id;
777:

Line 1433: DELETE FROM IGS_AD_RELEMP_INT_all WHERE

1429: IF g_rel_empl_dtl_inc THEN
1430: -- call the procedure to store statistics in igs_ad_imp_stats
1431: pe_cat_stats('RELATIONS_EMPLOYMENT_DETAILS');
1432:
1433: DELETE FROM IGS_AD_RELEMP_INT_all WHERE
1434: STATUS = '1' AND interface_run_id = l_interface_run_id;
1435:
1436: END IF;
1437:

Line 1477: ( EXISTS (SELECT 1 FROM igs_ad_relemp_int_all ai WHERE ad.interface_relations_id = ai.interface_relations_id)

1473: UPDATE IGS_AD_RELATIONS_INT_all ad
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: );

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

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:
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:

Line 4001: l_tab := 'IGS_AD_RELEMP_INT_ALL';

3997: IF l_warning IS NULL THEN
3998: l_warning := 0;
3999: END IF;
4000: l_total_rec := l_success + l_error + l_warning;
4001: l_tab := 'IGS_AD_RELEMP_INT_ALL';
4002: INSERT INTO IGS_AD_IMP_STATS
4003: (
4004: INTERFACE_RUN_ID,
4005: SRC_CAT_CODE,