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.

[Home] [Help]

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_UC_SYS_CALNDRS

Line 74: IGS_UC_SYS_CALNDRS USC

70: IGS_UC_DEFAULTS UD,
71: IGS_AD_SS_APPL_TYP AAT,
72: IGS_AD_APPL_ALL APL,
73: IGS_AD_PS_APPL_INST_ALL APLINST,
74: IGS_UC_SYS_CALNDRS USC
75: WHERE UAC.APP_NO = CP_APP_NO
76: AND UAC.CHOICE_NO = CP_CHOICE_NO
77: AND UAC.UCAS_CYCLE = CP_UCAS_CYCLE
78: AND UA.APP_NO = UAC.APP_NO

Line 304: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,

300: AND ud.system_code = a.system_code
301: AND ud.current_inst_code = a.institute_code;
302:
303: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
304: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
305: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
306: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
307: SELECT aca_cal_type,
308: aca_cal_seq_no,

Line 305: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,

301: AND ud.current_inst_code = a.institute_code;
302:
303: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
304: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
305: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
306: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
307: SELECT aca_cal_type,
308: aca_cal_seq_no,
309: adm_cal_type,

Line 306: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS

302:
303: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
304: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
305: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
306: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
307: SELECT aca_cal_type,
308: aca_cal_seq_no,
309: adm_cal_type,
310: adm_cal_seq_no

Line 311: FROM igs_uc_sys_calndrs sc

307: SELECT aca_cal_type,
308: aca_cal_seq_no,
309: adm_cal_type,
310: adm_cal_seq_no
311: FROM igs_uc_sys_calndrs sc
312: WHERE sc.system_code = cp_system_code
313: AND sc.entry_year = cp_entry_year
314: AND sc.entry_month = cp_entry_month;
315:

Line 458: -- get the calendar details from the IGS_UC_SYS_CALNDRS table based on the system, Entry Year and Entry Month as 0 (Zero).

454: l_sys_entry_cal_det_rec := NULL;
455: OPEN cur_sys_entry_cal_det (c_ch_system_rec.system_code, c_ch_system_rec.entry_year, c_ch_system_rec.entry_month);
456: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;
457: --If no matching Entry Year and Entry Month record for the system is found in the System Calendars table then
458: -- get the calendar details from the IGS_UC_SYS_CALNDRS table based on the system, Entry Year and Entry Month as 0 (Zero).
459: IF cur_sys_entry_cal_det%NOTFOUND THEN
460: CLOSE cur_sys_entry_cal_det;
461: OPEN cur_sys_entry_cal_det(c_ch_system_rec.system_code, c_ch_system_rec.entry_year, 0);
462: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;

Line 1451: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;

1447: l_app_choice_error_code igs_uc_app_choices.error_code%TYPE ;
1448: l_last_update_login NUMBER(15) ;
1449: l_last_updated_by NUMBER(15) ;
1450: l_description VARCHAR2(2000);
1451: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
1452: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
1453: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
1454: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
1455: l_ch_error igs_uc_app_choices.error_code%TYPE ;

Line 1452: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;

1448: l_last_update_login NUMBER(15) ;
1449: l_last_updated_by NUMBER(15) ;
1450: l_description VARCHAR2(2000);
1451: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
1452: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
1453: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
1454: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
1455: l_ch_error igs_uc_app_choices.error_code%TYPE ;
1456: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;

Line 1453: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;

1449: l_last_updated_by NUMBER(15) ;
1450: l_description VARCHAR2(2000);
1451: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
1452: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
1453: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
1454: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
1455: l_ch_error igs_uc_app_choices.error_code%TYPE ;
1456: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;
1457: l_exp_reply_flag BOOLEAN ;

Line 1454: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;

1450: l_description VARCHAR2(2000);
1451: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
1452: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
1453: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
1454: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
1455: l_ch_error igs_uc_app_choices.error_code%TYPE ;
1456: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;
1457: l_exp_reply_flag BOOLEAN ;
1458:

Line 1503: IGS_UC_SYS_CALNDRS USC

1499: IGS_UC_DEFAULTS UD,
1500: IGS_AD_SS_APPL_TYP AAT,
1501: IGS_AD_APPL_ALL APL,
1502: IGS_AD_PS_APPL_INST_ALL APLINST,
1503: IGS_UC_SYS_CALNDRS USC
1504: WHERE UAC.APP_NO = CP_APP_NO
1505: AND UAC.CHOICE_NO = CP_CHOICE_NO
1506: AND UAC.UCAS_CYCLE = CP_UCAS_CYCLE
1507: AND UA.APP_NO = UAC.APP_NO

Line 1648: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,

1644: SELECT igs_ad_offresp_batch_s.NEXTVAL
1645: FROM dual ;
1646:
1647: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
1648: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
1649: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
1650: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
1651: SELECT aca_cal_type,
1652: aca_cal_seq_no,

Line 1649: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,

1645: FROM dual ;
1646:
1647: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
1648: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
1649: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
1650: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
1651: SELECT aca_cal_type,
1652: aca_cal_seq_no,
1653: adm_cal_type,

Line 1650: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS

1646:
1647: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
1648: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
1649: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
1650: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
1651: SELECT aca_cal_type,
1652: aca_cal_seq_no,
1653: adm_cal_type,
1654: adm_cal_seq_no

Line 1655: FROM igs_uc_sys_calndrs

1651: SELECT aca_cal_type,
1652: aca_cal_seq_no,
1653: adm_cal_type,
1654: adm_cal_seq_no
1655: FROM igs_uc_sys_calndrs
1656: WHERE system_code = cp_system_code
1657: AND entry_year = cp_entry_year
1658: AND entry_month = cp_entry_month;
1659:

Line 1743: -- get the calendar details from the IGS_UC_SYS_CALNDRS table based on the system, Entry Year and Entry Month as 0 (Zero).

1739: l_sys_entry_cal_det_rec := NULL;
1740: OPEN cur_sys_entry_cal_det(cur_ucas_app_choice_rec.system_code, cur_ucas_app_choice_rec.entry_year, cur_ucas_app_choice_rec.entry_month);
1741: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;
1742: --If no matching Entry Year and Entry Month record for the system is found in the System Calendars table then
1743: -- get the calendar details from the IGS_UC_SYS_CALNDRS table based on the system, Entry Year and Entry Month as 0 (Zero).
1744: IF cur_sys_entry_cal_det%NOTFOUND THEN
1745: CLOSE cur_sys_entry_cal_det;
1746: OPEN cur_sys_entry_cal_det(cur_ucas_app_choice_rec.system_code, cur_ucas_app_choice_rec.entry_year, 0);
1747: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;