[Home] [Help]
728: p_token_value => l_meaning);
729: END IF;
730:
731: -- Populating the interface table with the interface_run_id value
732: UPDATE igs_ad_perstmt_int a
733: SET interface_run_id = p_interface_run_id,
734: (person_id,admission_appl_number)
735: = (SELECT person_id,NVL(admission_appl_number,update_adm_appl_number)
736: FROM igs_ad_apl_int
741: AND status IN ('1','4'));
742:
743: -- Gather statistics of the table
744: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
745: tabname => 'IGS_AD_PERSTMT_INT',
746: cascade => TRUE);
747:
748: -- Call category entity import procedure
749: igs_ad_imp_003.prc_pe_persstat_details (p_interface_run_id => p_interface_run_id,
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';
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';
1085: COMMIT;
1086: END IF; -- g_applicant_spl_tal_inc
1087:
1088: IF g_applicant_per_stat_inc THEN
1089: DELETE FROM igs_ad_perstmt_int
1090: WHERE status = '1'
1091: AND interface_run_id = p_interface_run_id;
1092: COMMIT;
1093: END IF; -- g_applicant_per_stat_inc