eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_BATC_DEF_DET_ALL

Line 248: CURSOR cur_dec_import_error( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,

244: AND uac.system_code = ud.system_code ;
245: cur_dp_app_choice_rec cur_dp_app_choice%ROWTYPE ;
246:
247: -- Cursor to check for the errorin the import decision process
248: CURSOR cur_dec_import_error( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
249: p_person_id IGS_AD_ADMDE_INT_ALL.person_id%TYPE,
250: p_admission_appl_number IGS_AD_ADMDE_INT_ALL.admission_appl_number%TYPE,
251: p_nominated_course_cd IGS_AD_ADMDE_INT_ALL.nominated_course_cd%TYPE,
252: p_sequence_number IGS_AD_ADMDE_INT_ALL.sequence_number%TYPE ) IS

Line 271: CURSOR cur_batc_def_det ( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ) IS

267: WHERE interface_mkdes_id = p_interface_mkdes_id ;
268: cur_admde_interface_rec cur_admde_interface%ROWTYPE;
269:
270: --Cursor to fetch the record from Admission Decision import Interface batch table
271: CURSOR cur_batc_def_det ( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ) IS
272: SELECT *
273: FROM igs_ad_batc_def_det_all
274: WHERE batch_id = p_batch_id ;
275: cur_batc_def_det_rec cur_batc_def_det%ROWTYPE ;

Line 273: FROM igs_ad_batc_def_det_all

269:
270: --Cursor to fetch the record from Admission Decision import Interface batch table
271: CURSOR cur_batc_def_det ( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ) IS
272: SELECT *
273: FROM igs_ad_batc_def_det_all
274: WHERE batch_id = p_batch_id ;
275: cur_batc_def_det_rec cur_batc_def_det%ROWTYPE ;
276:
277: -- Cursor to fetch the default Pending Reason

Line 334: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;

330: l_app_inst_sys_adm_ou_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
331: l_oss_ou_status_of_app_choice igs_ad_ou_stat.adm_outcome_status%TYPE;
332: l_latest_trans_decision igs_uc_transactions.decision%TYPE;
333:
334: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
335: l_deffered_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
336: l_current_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
337:
338: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;

Line 335: l_deffered_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;

331: l_oss_ou_status_of_app_choice igs_ad_ou_stat.adm_outcome_status%TYPE;
332: l_latest_trans_decision igs_uc_transactions.decision%TYPE;
333:
334: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
335: l_deffered_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
336: l_current_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
337:
338: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;
339: l_app_choice_error_code igs_uc_app_choices.error_code%TYPE ;

Line 336: l_current_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;

332: l_latest_trans_decision igs_uc_transactions.decision%TYPE;
333:
334: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
335: l_deffered_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
336: l_current_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
337:
338: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;
339: l_app_choice_error_code igs_uc_app_choices.error_code%TYPE ;
340:

Line 356: batch_id igs_ad_batc_def_det_all.batch_id%TYPE

352: TYPE batch_det_type IS RECORD
353: ( system_code igs_uc_app_choices.system_code%TYPE,
354: entry_year igs_uc_app_choices.entry_year%TYPE,
355: entry_month igs_uc_app_choices.entry_month%TYPE,
356: batch_id igs_ad_batc_def_det_all.batch_id%TYPE
357: );
358:
359: --Table Type to hold the batch_id created for diferrent system cycle calendars.
360: TYPE batch_det_table_type IS TABLE OF batch_det_type INDEX BY BINARY_INTEGER;

Line 436: -- Insert a record into the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL

432: l_conc_request_id := fnd_global.conc_request_id();
433:
434: FOR c_ch_system_rec IN c_ch_system LOOP
435:
436: -- Insert a record into the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL
437: -- for the deffered and current academic/admission calendar session details for each of the ucas systems
438: -- This Batch ID will be used while populating the Admission Decision Import Process Interface Table
439: FOR cur_ucas_setup_rec IN cur_ucas_setup(c_ch_system_rec.system_code) LOOP
440:

Line 517: -- 1. Get the Batch ID of the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL

513: OPEN cur_ucas_setup(cur_ucas_app_choice_rec.system_code) ;
514: FETCH cur_ucas_setup INTO cur_ucas_setup_rec;
515: CLOSE cur_ucas_setup;
516:
517: -- 1. Get the Batch ID of the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL
518: -- smaddali modified the code to get the batch id corresponding to the UCAS system ,for UCFD102 build , bug 2643048
519: l_batch_id := NULL ;
520: l_batch_id_loc :=NULL;
521: get_batchid_loc(p_system_code => cur_ucas_app_choice_rec.system_code,

Line 1279: -- 1. Get the Batch ID corresponding to the UCAS system available in Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL

1275: OPEN cur_ucas_setup(cur_dp_app_choice_rec.system_code) ;
1276: FETCH cur_ucas_setup INTO cur_ucas_setup_rec;
1277: CLOSE cur_ucas_setup;
1278:
1279: -- 1. Get the Batch ID corresponding to the UCAS system available in Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL
1280: l_batch_id := NULL ;
1281: l_batch_id_loc := NULL;
1282: get_batchid_loc(p_system_code => cur_dp_app_choice_rec.system_code,
1283: p_entry_year => cur_dp_app_choice_rec.entry_year,