APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_MILITARY_INT_ALL

Line 648: UPDATE igs_ad_military_int_all admi

644: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_MIL');
645: END IF;
646:
647: -- Populating the child interface table with the interface_run_id value.
648: UPDATE igs_ad_military_int_all admi
649: SET
650: interface_run_id=l_interface_run_id
651: WHERE admi.status='2' AND
652: EXISTS (SELECT 1

Line 661: tabname => 'IGS_AD_MILITARY_INT_ALL',

657: ai.interface_run_id=l_interface_run_id);
658:
659: -- gather statistics for the table after populating it's interface_run_id
660: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
661: tabname => 'IGS_AD_MILITARY_INT_ALL',
662: cascade => TRUE);
663:
664: UPDATE IGS_AD_MILITARY_INT_all SET STATUS = '1'
665: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 664: UPDATE IGS_AD_MILITARY_INT_all SET STATUS = '1'

660: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
661: tabname => 'IGS_AD_MILITARY_INT_ALL',
662: cascade => TRUE);
663:
664: UPDATE IGS_AD_MILITARY_INT_all SET STATUS = '1'
665: WHERE MATCH_IND = '22' AND STATUS = '2'
666: AND INTERFACE_RUN_ID = l_interface_run_id;
667:
668: Igs_Ad_Imp_007.PRC_PE_MLTRY_DTLS(

Line 1393: DELETE FROM IGS_AD_MILITARY_INT_all WHERE

1389: IF g_person_mil_dtl_inc THEN
1390:
1391: pe_cat_stats('PERSON_MILITARY_DETAILS');
1392:
1393: DELETE FROM IGS_AD_MILITARY_INT_all WHERE
1394: STATUS = '1' AND interface_run_id = l_interface_run_id;
1395:
1396: END IF;
1397:

Line 1587: OR EXISTS (SELECT 1 FROM igs_ad_military_int_all 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)
1584: OR EXISTS (SELECT 1 FROM igs_pe_fund_src_int ai WHERE ad.interface_id = ai.interface_id)
1585: OR EXISTS (SELECT 1 FROM igs_ad_hlth_ins_int_all ai WHERE ad.interface_id = ai.interface_id)
1586: OR EXISTS (SELECT 1 FROM igs_pe_immu_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1587: OR EXISTS (SELECT 1 FROM igs_ad_military_int_all ai WHERE ad.interface_id = ai.interface_id)
1588: OR EXISTS (SELECT 1 FROM igs_ad_excurr_int_all ai WHERE ad.interface_id = ai.interface_id)
1589: OR EXISTS (SELECT 1 FROM igs_pe_res_dtls_int ai WHERE ad.interface_id = ai.interface_id)
1590: OR EXISTS (SELECT 1 FROM igs_ad_acadhonor_int_all ai WHERE ad.interface_id = ai.interface_id)
1591: OR EXISTS (SELECT 1 FROM igs_ad_relations_int_all ai WHERE ad.interface_id = ai.interface_id)

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

1937: CURSOR cur_person_health_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1938: SELECT count(*) count1,status FROM IGS_AD_HLTH_INS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1939:
1940: CURSOR cur_person_mil_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1941: SELECT count(*) count1,status FROM IGS_AD_MILITARY_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1942:
1943: CURSOR cur_person_act_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1944: SELECT count(*) count1,status FROM IGS_AD_EXCURR_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1945:

Line 3194: l_tab := 'IGS_AD_MILITARY_INT_ALL';

3190: l_warning := 0;
3191: END IF;
3192:
3193: l_total_rec := l_success + l_error + l_warning;
3194: l_tab := 'IGS_AD_MILITARY_INT_ALL';
3195: INSERT INTO IGS_AD_IMP_STATS
3196: (
3197: INTERFACE_RUN_ID,
3198: SRC_CAT_CODE,