[Home] [Help]
660: p_token_value => l_meaning);
661: END IF;
662:
663: -- Populating the interface table with the interface_run_id value
664: UPDATE igs_ad_splint_int a
665: SET interface_run_id = p_interface_run_id,
666: (person_id,admission_appl_number,admission_Application_type)
667: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number),admission_Application_type
668: FROM igs_ad_apl_int
673: AND status IN ('1','4'));
674:
675: -- Gather statistics of the table
676: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
677: tabname => 'IGS_AD_SPLINT_INT',
678: cascade => TRUE);
679:
680: -- Call category entity import procedure
681: igs_ad_imp_003.prc_apcnt_spl_intrst (p_interface_run_id => p_interface_run_id,
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';
950: l_category_entity_ad_table(24).category_name := 'APPLICANT_NOTES'; l_category_entity_ad_table(24).entity_name := 'IGS_AD_NOTES_INT';
1071: COMMIT;
1072: END IF; -- g_applicant_appl_intent_inc
1073:
1074: IF g_applicant_spl_int_inc THEN
1075: DELETE FROM igs_ad_splint_int
1076: WHERE status = '1'
1077: AND interface_run_id = p_interface_run_id;
1078: COMMIT;
1079: END IF; -- g_applicant_spl_int_inc