APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_API_INT_ALL

Line 104: UPDATE igs_ad_api_int_all aapi

100: WHERE interface_run_id = l_interface_run_id AND
101: status='2');
102:
103: -- Populating the child interface table with the interface_run_id value.
104: UPDATE igs_ad_api_int_all aapi
105: SET interface_run_id=l_interface_run_id
106: WHERE aapi.status='2' AND
107: EXISTS (SELECT 1
108: FROM igs_ad_interface_all ai

Line 115: tabname => 'IGS_AD_API_INT_ALL',

111: ai.status IN ('1','2') AND
112: ai.interface_run_id=l_interface_run_id);
113:
114: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
115: tabname => 'IGS_AD_API_INT_ALL',
116: cascade => TRUE);
117:
118: -- Populating the child interface table with the interface_run_id value.
119: UPDATE igs_ad_stat_int_all adi

Line 184: UPDATE IGS_AD_API_INT_all SET STATUS = '1'

180: UPDATE IGS_AD_ADDRUSAGE_INT_all iau SET STATUS = '1'
181: WHERE MATCH_IND = '22' AND STATUS = '2'
182: AND INTERFACE_RUN_ID = l_interface_run_id;
183:
184: UPDATE IGS_AD_API_INT_all SET STATUS = '1'
185: WHERE MATCH_IND = '22' AND STATUS = '2'
186: AND INTERFACE_RUN_ID = l_interface_run_id;
187:
188: igs_ad_imp_002.prc_pe_dtls

Line 1281: DELETE FROM igs_ad_api_int_all WHERE

1277:
1278: -- call the procedure to store statistics in igs_ad_imp_stats
1279: pe_cat_stats('PERSON_ID_TYPES');
1280:
1281: DELETE FROM igs_ad_api_int_all WHERE
1282: STATUS = '1' AND interface_run_id = l_interface_run_id;
1283:
1284:
1285: IF g_person_stat_inc THEN

Line 1574: OR EXISTS (SELECT 1 FROM igs_ad_api_int_all ai WHERE ad.interface_id = ai.interface_id)

1570: WHERE ad.interface_run_id = l_interface_run_id AND
1571: ( EXISTS (SELECT 1 FROM igs_ad_interface_all ai WHERE ad.interface_id = ai.interface_id AND status = '3')
1572: OR EXISTS (SELECT 1 FROM igs_ad_stat_int_all ai WHERE ad.interface_id = ai.interface_id)
1573: OR EXISTS (SELECT 1 FROM igs_ad_addr_int_all ai WHERE ad.interface_id = ai.interface_id)
1574: OR EXISTS (SELECT 1 FROM igs_ad_api_int_all ai WHERE ad.interface_id = ai.interface_id)
1575: OR EXISTS (SELECT 1 FROM igs_pe_race_int ai WHERE ad.interface_id = ai.interface_id)
1576: OR EXISTS (SELECT 1 FROM igs_pe_eit_int ai WHERE ad.interface_id = ai.interface_id)
1577: OR EXISTS (SELECT 1 FROM igs_pe_type_int ai WHERE ad.interface_id = ai.interface_id)
1578: OR EXISTS (SELECT 1 FROM igs_ad_alias_int_all ai WHERE ad.interface_id = ai.interface_id)

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

1897: CURSOR cur_person_alias_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1898: SELECT count(*) count1,status FROM IGS_AD_ALIAS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1899:
1900: CURSOR cur_person_id_types_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1901: SELECT count(*) count1,status FROM IGS_AD_API_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1902:
1903: CURSOR cur_person_spcl_need_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1904: SELECT count(*) count1,status FROM IGS_AD_DISABLTY_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1905:

Line 2479: l_tab := 'IGS_AD_API_INT_ALL';

2475: l_warning := 0;
2476: END IF;
2477:
2478: l_total_rec := l_success + l_error + l_warning;
2479: l_tab := 'IGS_AD_API_INT_ALL';
2480: INSERT INTO IGS_AD_IMP_STATS
2481: (
2482: INTERFACE_RUN_ID,
2483: SRC_CAT_CODE,