APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_BATC_DEF_DET_ALL

Line 774: l_description igs_ad_batc_def_det_all.description%TYPE ;

770: jchakrab 04-May-2006 Modified for 5203018 - modified to close c_cancel_appl cursor correctly
771: jchakrab 22-May-2006 Modified for 5165624
772: ***************************************************************** */
773:
774: l_description igs_ad_batc_def_det_all.description%TYPE ;
775: l_rowid VARCHAR2(50) ;
776:
777: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
778:

Line 777: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;

773:
774: l_description igs_ad_batc_def_det_all.description%TYPE ;
775: l_rowid VARCHAR2(50) ;
776:
777: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
778:
779: l_appl_batch_id NUMBER;
780: l_dec_batch_id NUMBER;
781: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;

Line 993: CURSOR c_dec_int( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,

989: ORDER BY a.preference_number DESC ;
990:
991:
992: -- Get the admission decision import interface record for the passed admission application instace.
993: CURSOR c_dec_int( p_batch_id IGS_AD_BATC_DEF_DET_ALL.batch_id%TYPE ,
994: p_person_id IGS_AD_ADMDE_INT.person_id%TYPE,
995: p_admission_appl_number IGS_AD_ADMDE_INT.admission_appl_number%TYPE,
996: p_nominated_course_cd IGS_AD_ADMDE_INT.nominated_course_cd%TYPE,
997: p_sequence_number IGS_AD_ADMDE_INT.sequence_number%TYPE ) IS

Line 1225: batch_id igs_ad_batc_def_det_all.batch_id%TYPE

1221: TYPE batch_det_type IS RECORD
1222: ( system_code igs_uc_app_choices.system_code%TYPE,
1223: entry_year igs_uc_app_choices.entry_year%TYPE,
1224: entry_month igs_uc_app_choices.entry_month%TYPE,
1225: batch_id igs_ad_batc_def_det_all.batch_id%TYPE
1226: );
1227:
1228: --Table Type to hold the batch_id created for diferrent system cycle calendars.
1229: TYPE batch_det_table_type IS TABLE OF batch_det_type INDEX BY BINARY_INTEGER;

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

1278: BEGIN
1279:
1280: l_batch_id_loc := 0;
1281:
1282: -- Insert a record into the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL
1283: -- for the deffered academic/admission calendar session details
1284: -- This Batch ID will be used while populating the Admission Decision Import Process Interface Table
1285: FOR c_ch_system_rec IN c_ch_system LOOP
1286:

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

1532: END IF ;
1533: CLOSE c_old_oustat ;
1534:
1535: -- populate decision import interface tables
1536: -- 1. Get the Batch ID of the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL
1537: l_dec_batch_id := NULL;
1538: l_batch_id_loc :=NULL;
1539: get_batchid_loc(p_system_code => c_new_app_ch_rec.system_code,
1540: p_entry_year => c_new_app_ch_rec.entry_year,

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

1874: END IF ;
1875: CLOSE c_old_oustat ;
1876:
1877: -- populate decision import interface tables
1878: -- 1. Get the Batch ID of the Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL
1879: l_dec_batch_id := NULL;
1880: l_batch_id_loc :=NULL;
1881: get_batchid_loc(p_system_code => c_new_app_ch_rec.system_code,
1882: p_entry_year => c_new_app_ch_rec.entry_year,

Line 2059: -- available in Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL

2055: FETCH c_defaults INTO c_defaults_rec;
2056: CLOSE c_defaults ;
2057:
2058: -- Get the Batch ID created for the calendar setup for this Application choice corresponding to the UCAS system, Entry Year and Entry Month
2059: -- available in Admission Decision Import Batch table,IGS_AD_BATC_DEF_DET_ALL
2060: l_dec_batch_id := NULL ;
2061: l_batch_id_loc :=NULL;
2062: get_batchid_loc(p_system_code => c_oo_ch_rec.system_code,
2063: p_entry_year => c_oo_ch_rec.entry_year,