APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_ADDRUSAGE_INT_ALL

Line 149: UPDATE IGS_AD_ADDRUSAGE_INT_ALL ait

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

Line 160: tabname => 'IGS_AD_ADDRUSAGE_INT_ALL',

156: ai.status IN ('1','2') AND
157: ai.interface_run_id=l_interface_run_id);
158:
159: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
160: tabname => 'IGS_AD_ADDRUSAGE_INT_ALL',
161: cascade => TRUE);
162:
163: -- Update records with match_ind '22' to status = '1'
164: -- Person Details

Line 180: UPDATE IGS_AD_ADDRUSAGE_INT_all iau SET STATUS = '1'

176: WHERE MATCH_IND = '22' AND STATUS = '2'
177: AND INTERFACE_RUN_ID = l_interface_run_id;
178:
179: -- Address Usages
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'

Line 1272: DELETE FROM igs_ad_addrusage_int_all WHERE

1268: -- Delete from the table IGS_AD_ADDRUSAGE_INT
1269: pe_cat_stats('PERSON_ADDRESS');
1270:
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;

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

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

Line 2369: l_tab := 'IGS_AD_ADDRUSAGE_INT_ALL';

2365: l_warning := 0;
2366: END IF;
2367:
2368: l_total_rec := l_success + l_error + l_warning;
2369: l_tab := 'IGS_AD_ADDRUSAGE_INT_ALL';
2370: INSERT INTO IGS_AD_IMP_STATS
2371: (
2372: INTERFACE_RUN_ID,
2373: SRC_CAT_CODE,