eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_015 dependencies on IGS_AD_OTHINST_INT

Line 562: UPDATE igs_ad_othinst_int a

558: p_token_value => l_meaning);
559: END IF;
560:
561: -- Populating the interface table with the interface_run_id value
562: UPDATE igs_ad_othinst_int a
563: SET interface_run_id = p_interface_run_id,
564: (person_id,admission_appl_number,admission_Application_type)
565: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number), admission_Application_type
566: FROM igs_ad_apl_int

Line 575: tabname => 'IGS_AD_OTHINST_INT',

571: AND status IN ('1','4'));
572:
573: -- Gather statistics of the table
574: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
575: tabname => 'IGS_AD_OTHINST_INT',
576: cascade => TRUE);
577:
578: -- Call category entity import procedure
579: igs_ad_imp_003.prc_apcnt_oth_inst_apld (p_interface_run_id => p_interface_run_id,

Line 943: l_category_entity_ad_table(17).category_name := 'APPLICANT_OTHERINSTS_APPLIED'; l_category_entity_ad_table(17).entity_name := 'IGS_AD_OTHINST_INT';

939: l_category_entity_ad_table(13).category_name := 'APPLICATION'; l_category_entity_ad_table(13).entity_name := 'IGS_AD_APL_INT';
940: l_category_entity_ad_table(14).category_name := 'APPLICATION'; l_category_entity_ad_table(14).entity_name := 'IGS_AD_PS_APPL_INST_INT';
941: l_category_entity_ad_table(15).category_name := 'APPLICANT_HISTORY'; l_category_entity_ad_table(15).entity_name := 'IGS_AD_APPHIST_INT';
942: l_category_entity_ad_table(16).category_name := 'APPLICANT_HISTORY'; l_category_entity_ad_table(16).entity_name := 'IGS_AD_INSTHIST_INT';
943: l_category_entity_ad_table(17).category_name := 'APPLICANT_OTHERINSTS_APPLIED'; l_category_entity_ad_table(17).entity_name := 'IGS_AD_OTHINST_INT';
944: l_category_entity_ad_table(18).category_name := 'APPLICANT_ACADEMIC_INTERESTS'; l_category_entity_ad_table(18).entity_name := 'IGS_AD_ACADINT_INT';
945: l_category_entity_ad_table(19).category_name := 'APPLICANT_INTENT'; l_category_entity_ad_table(19).entity_name := 'IGS_AD_APPINT_INT';
946: l_category_entity_ad_table(20).category_name := 'APPLICANT_SPECIAL_INTERESTS'; l_category_entity_ad_table(20).entity_name := 'IGS_AD_SPLINT_INT';
947: l_category_entity_ad_table(21).category_name := 'APPLICANT_SPECIAL_TALENTS'; l_category_entity_ad_table(21).entity_name := 'IGS_AD_SPLTAL_INT';

Line 1054: DELETE FROM igs_ad_othinst_int

1050: COMMIT;
1051: END IF; -- g_applicant_hist_inc
1052:
1053: IF g_applicant_oth_inst_appl_inc THEN
1054: DELETE FROM igs_ad_othinst_int
1055: WHERE status = '1'
1056: AND interface_run_id = p_interface_run_id;
1057: COMMIT;
1058: END IF; -- g_applicant_oth_inst_appl_inc