DBA Data[Home] [Help]

APPS.IGS_UC_EXPUNGE_APP dependencies on IGS_AD_BATC_DEF_DET_ALL

Line 289: l_dec_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;

285: l_appl_inst_rec cur_oss_ad_appl_inst%ROWTYPE;
286: l_defaults_rec cur_defaults%ROWTYPE;
287: l_alt_pers_id_rec cur_alt_pers_id%ROWTYPE;
288:
289: l_dec_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
290: l_interface_mkdes_id igs_ad_admde_int_all.interface_mkdes_id%TYPE;
291: l_interface_run_id igs_ad_admde_int_all.interface_run_id%TYPE;
292: l_error_message fnd_new_messages.message_text%TYPE;
293: l_person_no igs_pe_person_base_v.person_number%TYPE;

Line 421: -- Insert a record into the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL with calendar details of Application Instance

417: --Loop through all the Admission Application Instances which are to be Suspended FOR UCAS Wrong Application number.
418: FOR l_oss_ad_appl_inst_rec IN cur_oss_ad_appl_inst(l_wrong_app_rec.app_no, l_expunge_choice_det(l_loc))
419: LOOP
420:
421: -- Insert a record into the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL with calendar details of Application Instance
422: -- This Batch ID will be used while populating the Admission Decision Import Process Interface Table
423: l_rowid := NULL;
424: l_dec_batch_id := NULL;
425: igs_ad_batc_def_det_pkg.insert_row ( x_rowid => l_rowid,