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_ACADINT_INT

Line 596: UPDATE igs_ad_acadint_int a

592: p_token_value => l_meaning);
593: END IF;
594:
595: -- Populating the interface table with the interface_run_id value
596: UPDATE igs_ad_acadint_int a
597: SET interface_run_id = p_interface_run_id,
598: (person_id,admission_appl_number, admission_Application_type)
599: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
600: FROM igs_ad_apl_int

Line 609: tabname => 'IGS_AD_ACADINT_INT',

605: AND status IN ('1','4'));
606:
607: -- Gather statistics of the table
608: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
609: tabname => 'IGS_AD_ACADINT_INT',
610: cascade => TRUE);
611:
612: -- Call category entity import procedure
613: igs_ad_imp_003.prc_acad_int (p_interface_run_id => p_interface_run_id,

Line 944: l_category_entity_ad_table(18).category_name := 'APPLICANT_ACADEMIC_INTERESTS'; l_category_entity_ad_table(18).entity_name := 'IGS_AD_ACADINT_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';
948: l_category_entity_ad_table(22).category_name := 'APPLICANT_PERSONAL_STATEMENTS'; l_category_entity_ad_table(22).entity_name := 'IGS_AD_PERSTMT_INT';

Line 1061: DELETE FROM igs_ad_acadint_int

1057: COMMIT;
1058: END IF; -- g_applicant_oth_inst_appl_inc
1059:
1060: IF g_applicant_acad_int_inc THEN
1061: DELETE FROM igs_ad_acadint_int
1062: WHERE status = '1'
1063: AND interface_run_id = p_interface_run_id;
1064: COMMIT;
1065: END IF; -- g_applicant_acad_int_inc