APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_DISABLTY_INT_ALL

Line 351: UPDATE igs_ad_disablty_int_all adi

347: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_SPL_NEED');
348: END IF;
349:
350: -- pupulate the child table with the interface run ID from the package.
351: UPDATE igs_ad_disablty_int_all adi
352: SET interface_run_id=l_interface_run_id
353: WHERE adi.status='2' AND
354: EXISTS (SELECT 1
355: FROM igs_ad_interface_all ai

Line 361: tabname => 'IGS_AD_DISABLTY_INT_ALL',

357: ai.status IN ('1','4') AND
358: ai.interface_run_id=l_interface_run_id);
359:
360: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
361: tabname => 'IGS_AD_DISABLTY_INT_ALL',
362: cascade => TRUE);
363:
364: -- pupulate the child table with the interface run ID from the package.
365: UPDATE IGS_AD_DISABLTY_INT_all SET STATUS = '1'

Line 365: UPDATE IGS_AD_DISABLTY_INT_all SET STATUS = '1'

361: tabname => 'IGS_AD_DISABLTY_INT_ALL',
362: cascade => TRUE);
363:
364: -- pupulate the child table with the interface run ID from the package.
365: UPDATE IGS_AD_DISABLTY_INT_all SET STATUS = '1'
366: WHERE MATCH_IND = '22' AND STATUS = '2'
367: AND INTERFACE_RUN_ID = l_interface_run_id;
368:
369: UPDATE igs_pe_sn_srvce_int snci

Line 374: igs_ad_disablty_int_all adi

370: SET interface_run_id=l_interface_run_id
371: WHERE snci.status='2' AND
372: EXISTS (SELECT 1
373: FROM igs_ad_interface_all ai,
374: igs_ad_disablty_int_all adi
375: WHERE ai.interface_id=adi.interface_id AND
376: adi.INTERFACE_DISABLTY_ID=snci.INTERFACE_DISABLTY_ID AND
377: ai.status IN ('1','4') AND
378: ai.interface_run_id=l_interface_run_id);

Line 397: igs_ad_disablty_int_all adi

393: interface_run_id=l_interface_run_id
394: WHERE psci.status='2' AND
395: EXISTS (SELECT 1
396: FROM igs_ad_interface_all ai,
397: igs_ad_disablty_int_all adi
398: WHERE
399: ai.interface_id=adi.interface_id AND
400: adi.INTERFACE_DISABLTY_ID=psci.INTERFACE_DISABLTY_ID AND
401: ai.status IN ('1','4') AND

Line 1324: DELETE FROM IGS_AD_DISABLTY_INT_all WHERE

1320:
1321: DELETE FROM igs_pe_sn_conct_int WHERE
1322: STATUS = '1' AND interface_run_id = l_interface_run_id;
1323:
1324: DELETE FROM IGS_AD_DISABLTY_INT_all WHERE
1325: STATUS = '1' AND interface_run_id = l_interface_run_id;
1326:
1327: END IF;
1328:

Line 1579: OR EXISTS (SELECT 1 FROM igs_ad_disablty_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)
1579: OR EXISTS (SELECT 1 FROM igs_ad_disablty_int_all ai WHERE ad.interface_id = ai.interface_id)
1580: OR EXISTS (SELECT 1 FROM igs_ad_emp_int_all ai WHERE ad.interface_id = ai.interface_id)
1581: OR EXISTS (SELECT 1 FROM igs_pe_visa_int ai WHERE ad.interface_id = ai.interface_id)
1582: OR EXISTS (SELECT 1 FROM igs_pe_passport_int ai WHERE ad.interface_id = ai.interface_id)
1583: OR EXISTS (SELECT 1 FROM igs_pe_citizen_int ai WHERE ad.interface_id = ai.interface_id)

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

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:
1906: CURSOR cur_person_srvc_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1907: SELECT count(*) count1,status FROM IGS_PE_SN_SRVCE_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1908:

Line 2533: l_tab := 'IGS_AD_DISABLTY_INT_ALL';

2529: l_warning := 0;
2530: END IF;
2531:
2532: l_total_rec := l_success + l_error + l_warning;
2533: l_tab := 'IGS_AD_DISABLTY_INT_ALL';
2534: INSERT INTO IGS_AD_IMP_STATS
2535: (
2536: INTERFACE_RUN_ID,
2537: SRC_CAT_CODE,