[Home] [Help]
829: p_token_value => l_meaning);
830: END IF;
831:
832: -- Populating the interface table with the interface_run_id value
833: UPDATE igs_ad_unitsets_int a
834: SET interface_run_id = p_interface_run_id,
835: (person_id,admission_appl_number,nominated_course_cd,sequence_number,admission_Application_type )
836: = (SELECT person_id,admission_appl_number,nominated_course_cd,NVL(sequence_number,update_adm_seq_number),admission_Application_type
837: FROM igs_ad_ps_appl_inst_int
842: AND status IN ('1','4'));
843:
844: -- Gather statistics of the table
845: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
846: tabname => 'IGS_AD_UNITSETS_INT',
847: cascade => TRUE);
848:
849: -- Call category entity import procedure
850: igs_ad_imp_010.prc_apcnt_uset_apl (p_interface_run_id => p_interface_run_id,
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:
954: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN
955: l_category_entity_ad_table(27).category_name := 'INQUIRY_INSTANCE'; l_category_entity_ad_table(27).entity_name := 'IGR_I_APPL_INT';
1022: COMMIT;
1023: END IF; -- g_applicant_notes_inc
1024:
1025: IF g_applicant_des_unit_sets_inc THEN
1026: DELETE FROM igs_ad_unitsets_int
1027: WHERE status = '1'
1028: AND interface_run_id = p_interface_run_id;
1029: COMMIT;
1030: END IF; -- g_applicant_des_unit_sets_inc