APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_ADDR_INT_ALL

Line 133: UPDATE IGS_AD_ADDR_INT_ALL ait

129: tabname => 'IGS_AD_STAT_INT_ALL',
130: cascade => TRUE);
131:
132: -- Populating the child interface table with the interface_run_id value.
133: UPDATE IGS_AD_ADDR_INT_ALL ait
134: SET
135: interface_run_id=l_interface_run_id
136: WHERE ait.status='2' AND
137: EXISTS (SELECT 1

Line 145: tabname => 'IGS_AD_ADDR_INT_ALL',

141: ai.status IN ('1','2') AND
142: ai.interface_run_id=l_interface_run_id);
143:
144: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
145: tabname => 'IGS_AD_ADDR_INT_ALL',
146: cascade => TRUE);
147:
148: -- Populating the child interface table with the interface_run_id value.
149: UPDATE IGS_AD_ADDRUSAGE_INT_ALL ait

Line 153: FROM IGS_AD_ADDR_INT_ALL ai

149: UPDATE IGS_AD_ADDRUSAGE_INT_ALL ait
150: SET interface_run_id=l_interface_run_id
151: WHERE ait.status='2' AND
152: EXISTS (SELECT 1
153: FROM IGS_AD_ADDR_INT_ALL ai
154: WHERE
155: ai.interface_addr_id = ait.interface_addr_id AND
156: ai.status IN ('1','2') AND
157: ai.interface_run_id=l_interface_run_id);

Line 175: UPDATE IGS_AD_ADDR_INT_all SET STATUS = '1'

171: WHERE MATCH_IND = '22' AND STATUS = '2'
172: AND INTERFACE_RUN_ID = l_interface_run_id;
173:
174: -- Address Details
175: UPDATE IGS_AD_ADDR_INT_all SET STATUS = '1'
176: WHERE MATCH_IND = '22' AND STATUS = '2'
177: AND INTERFACE_RUN_ID = l_interface_run_id;
178:
179: -- Address Usages

Line 1275: DELETE FROM igs_ad_addr_int_all WHERE

1271: -- new logic to delete processed records from interface table
1272: DELETE FROM igs_ad_addrusage_int_all WHERE
1273: STATUS = '1' AND interface_run_id = l_interface_run_id;
1274:
1275: DELETE FROM igs_ad_addr_int_all WHERE
1276: STATUS = '1' AND interface_run_id = l_interface_run_id;
1277:
1278: -- call the procedure to store statistics in igs_ad_imp_stats
1279: pe_cat_stats('PERSON_ID_TYPES');

Line 1573: OR EXISTS (SELECT 1 FROM igs_ad_addr_int_all ai WHERE ad.interface_id = ai.interface_id)

1569: SET record_status = '3'
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)

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

1888: CURSOR cur_person_race_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1889: SELECT count(*) count1,status FROM IGS_PE_RACE_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1890:
1891: CURSOR cur_person_addr_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1892: SELECT count(*) count1,status FROM IGS_AD_ADDR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1893:
1894: CURSOR cur_person_addrusage_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1895: SELECT count(*) count1, status FROM IGS_AD_ADDRUSAGE_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1896:

Line 2313: l_tab := 'IGS_AD_ADDR_INT_ALL';

2309: l_warning := 0;
2310: END IF;
2311:
2312: l_total_rec := l_success + l_error + l_warning;
2313: l_tab := 'IGS_AD_ADDR_INT_ALL';
2314: INSERT INTO IGS_AD_IMP_STATS
2315: (
2316: INTERFACE_RUN_ID,
2317: SRC_CAT_CODE,