[Home] [Help]
761: p_token_value => l_meaning);
762: END IF;
763:
764: -- Populating the interface table with the interface_run_id value
765: UPDATE igs_ad_fee_int a
766: SET interface_run_id = p_interface_run_id,
767: (person_id,admission_appl_number)
768: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number)
769: FROM igs_ad_apl_int
774: AND status IN ('1','4'));
775:
776: -- Gather statistics of the table
777: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
778: tabname => 'IGS_AD_FEE_INT',
779: cascade => TRUE);
780:
781: -- Call category entity import procedure
782: igs_ad_imp_003.prc_appl_fees (p_interface_run_id => p_interface_run_id,
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';
951: l_category_entity_ad_table(25).category_name := 'APPLICANT_UNITSETS_APPLIED'; l_category_entity_ad_table(25).entity_name := 'IGS_AD_UNITSETS_INT';
952: l_category_entity_ad_table(26).category_name := 'APPLICANT_EDU_GOALS'; l_category_entity_ad_table(26).entity_name := 'IGS_AD_EDUGOAL_INT';
953:
1092: COMMIT;
1093: END IF; -- g_applicant_per_stat_inc
1094:
1095: IF g_applicant_fee_dtls_inc THEN
1096: DELETE FROM igs_ad_fee_int
1097: WHERE status = '1'
1098: AND interface_run_id = p_interface_run_id;
1099: COMMIT;
1100: END IF; -- g_applicant_fee_dtls_inc