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_APPINT_INT

Line 630: UPDATE igs_ad_appint_int a

626: p_token_value => l_meaning);
627: END IF;
628:
629: -- Populating the interface table with the interface_run_id value
630: UPDATE igs_ad_appint_int a
631: SET interface_run_id = p_interface_run_id,
632: (person_id,admission_appl_number,admission_Application_type)
633: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
634: FROM igs_ad_apl_int

Line 643: tabname => 'IGS_AD_APPINT_INT',

639: AND status IN ('1','4'));
640:
641: -- Gather statistics of the table
642: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
643: tabname => 'IGS_AD_APPINT_INT',
644: cascade => TRUE);
645:
646: -- Call category entity import procedure
647: igs_ad_imp_003.prc_apcnt_indt (p_interface_run_id => p_interface_run_id,

Line 945: l_category_entity_ad_table(19).category_name := 'APPLICANT_INTENT'; l_category_entity_ad_table(19).entity_name := 'IGS_AD_APPINT_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';
949: l_category_entity_ad_table(23).category_name := 'APPLICANT_FEE_DTLS'; l_category_entity_ad_table(23).entity_name := 'IGS_AD_FEE_INT';

Line 1068: DELETE FROM igs_ad_appint_int

1064: COMMIT;
1065: END IF; -- g_applicant_acad_int_inc
1066:
1067: IF g_applicant_appl_intent_inc THEN
1068: DELETE FROM igs_ad_appint_int
1069: WHERE status = '1'
1070: AND interface_run_id = p_interface_run_id;
1071: COMMIT;
1072: END IF; -- g_applicant_appl_intent_inc