APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_RELATIONS_INT_ALL

Line 713: UPDATE IGS_AD_RELATIONS_INT_ALL ari

709: igs_ad_imp_001.set_message(p_name => 'IGS_AD_BEG_PE_REL');
710: END IF;
711:
712: -- Populating the child interface table with the interface_run_id value.
713: UPDATE IGS_AD_RELATIONS_INT_ALL ari
714: SET interface_run_id=l_interface_run_id
715: WHERE ari.status='2' AND
716: EXISTS (SELECT 1
717: FROM igs_ad_interface_all ai

Line 725: tabname => 'IGS_AD_RELATIONS_INT_ALL',

721: ai.interface_run_id=l_interface_run_id);
722:
723: -- gather statistics for the table after populating it's interface_run_id
724: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
725: tabname => 'IGS_AD_RELATIONS_INT_ALL',
726: cascade => TRUE);
727: UPDATE IGS_AD_RELATIONS_INT_all iar
728: SET STATUS = '1'
729: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 727: UPDATE IGS_AD_RELATIONS_INT_all iar

723: -- gather statistics for the table after populating it's interface_run_id
724: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
725: tabname => 'IGS_AD_RELATIONS_INT_ALL',
726: cascade => TRUE);
727: UPDATE IGS_AD_RELATIONS_INT_all iar
728: SET STATUS = '1'
729: WHERE MATCH_IND = '22' AND STATUS = '2'
730: AND INTERFACE_RUN_ID = l_interface_run_id;
731:

Line 739: IGS_AD_RELATIONS_INT_ALL adi

735: SET interface_run_id=l_interface_run_id
736: WHERE ari1.status='2' AND
737: EXISTS (SELECT 1
738: FROM igs_ad_interface_all ai,
739: IGS_AD_RELATIONS_INT_ALL adi
740: WHERE
741: adi.INTERFACE_RELATIONS_ID=ari1.INTERFACE_RELATIONS_ID AND
742: ai.interface_id=adi.interface_id AND
743: ai.status IN ('1','4') AND

Line 763: IGS_AD_RELATIONS_INT_ALL adi

759: SET interface_run_id=l_interface_run_id
760: WHERE ari2.status='2' AND
761: EXISTS (SELECT 1
762: FROM igs_ad_interface_all ai,
763: IGS_AD_RELATIONS_INT_ALL adi
764: WHERE adi.INTERFACE_RELATIONS_ID=ari2.INTERFACE_RELATIONS_ID AND
765: ai.interface_id=adi.interface_id AND
766: ai.status IN ('1','4') AND
767: ai.interface_run_id=l_interface_run_id);

Line 788: IGS_AD_RELATIONS_INT_ALL adi

784: SET interface_run_id=l_interface_run_id
785: WHERE ari3.status='2' AND
786: EXISTS (SELECT 1
787: FROM igs_ad_interface_all ai,
788: IGS_AD_RELATIONS_INT_ALL adi
789: WHERE adi.INTERFACE_RELATIONS_ID=ari3.INTERFACE_RELATIONS_ID AND
790: ai.interface_id=adi.interface_id AND
791: ai.status IN ('1','4') AND
792: ai.interface_run_id=l_interface_run_id);

Line 813: IGS_AD_RELATIONS_INT_ALL adi

809: interface_run_id=l_interface_run_id
810: WHERE ari4.status='2' AND
811: EXISTS (SELECT 1
812: FROM igs_ad_interface_all ai,
813: IGS_AD_RELATIONS_INT_ALL adi
814: WHERE
815: adi.INTERFACE_RELATIONS_ID=ari4.INTERFACE_RELATIONS_ID AND
816: ai.interface_id=adi.interface_id AND
817: ai.status IN ('1','4') AND

Line 1473: UPDATE IGS_AD_RELATIONS_INT_all ad

1469: pe_cat_stats('PERSON_RELATIONS');
1470:
1471:
1472: -- nsidana Bug 3533035 : First update the relations_int table to status 4 in case any child was not processed successfully. Then delete the records having status 1.
1473: UPDATE IGS_AD_RELATIONS_INT_all ad
1474: SET status = '4', error_code = 'E347'
1475: WHERE ad.interface_run_id = l_interface_run_id AND
1476: ad.status = '1' AND
1477: ( EXISTS (SELECT 1 FROM igs_ad_relemp_int_all ai WHERE ad.interface_relations_id = ai.interface_relations_id)

Line 1483: DELETE FROM IGS_AD_RELATIONS_INT_all WHERE

1479: OR EXISTS (SELECT 1 FROM IGS_AD_RELACAD_INT_all ai WHERE ad.interface_relations_ID = ai.interface_relations_ID)
1480: OR EXISTS (SELECT 1 FROM igs_ad_reladdr_int_all ai WHERE ad.interface_relations_ID = ai.interface_relations_ID )
1481: );
1482:
1483: DELETE FROM IGS_AD_RELATIONS_INT_all WHERE
1484: STATUS = '1' AND interface_run_id = l_interface_run_id;
1485: -- end of delete logic
1486:
1487: END IF;

Line 1591: OR EXISTS (SELECT 1 FROM igs_ad_relations_int_all 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)
1592: OR EXISTS (SELECT 1 FROM igs_pe_ath_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1593: OR EXISTS (SELECT 1 FROM igs_pe_ath_prg_int ai WHERE ad.interface_id = ai.interface_id)
1594: OR EXISTS (SELECT 1 FROM igs_pe_housing_int ai WHERE ad.interface_id = ai.interface_id)
1595: OR EXISTS (SELECT 1 FROM igs_pe_flny_dtl_int ai WHERE ad.interface_id = ai.interface_id)

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

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:
1946: CURSOR cur_person_rel_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1947: SELECT count(*) count1,status FROM IGS_AD_RELATIONS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1948:
1949: CURSOR cur_person_ath_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1950: SELECT count(*) count1,status FROM IGS_PE_ATH_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1951:

Line 3302: l_tab := 'IGS_AD_RELATIONS_INT_ALL';

3298: l_warning := 0;
3299: END IF;
3300:
3301: l_total_rec := l_success + l_error + l_warning;
3302: l_tab := 'IGS_AD_RELATIONS_INT_ALL';
3303: INSERT INTO IGS_AD_IMP_STATS
3304: (
3305: INTERFACE_RUN_ID,
3306: SRC_CAT_CODE,