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_TO_OSS dependencies on IGS_UC_SYS_CALNDRS

Line 55: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;

51: l_program_id CONSTANT NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
52: l_ch_error igs_uc_app_choices.error_code%TYPE ;
53: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;
54: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;
55: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
56: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
57: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
58: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
59: l_update_adm_appl_number igs_ad_apl_int.update_adm_appl_number%TYPE;

Line 56: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;

52: l_ch_error igs_uc_app_choices.error_code%TYPE ;
53: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;
54: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;
55: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
56: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
57: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
58: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
59: l_update_adm_appl_number igs_ad_apl_int.update_adm_appl_number%TYPE;
60: l_update_adm_seq_number igs_ad_ps_appl_inst_int.update_adm_seq_number%TYPE;

Line 57: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;

53: l_ch_batch_id igs_uc_app_choices.batch_id%TYPE ;
54: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;
55: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
56: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
57: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
58: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
59: l_update_adm_appl_number igs_ad_apl_int.update_adm_appl_number%TYPE;
60: l_update_adm_seq_number igs_ad_ps_appl_inst_int.update_adm_seq_number%TYPE;
61:

Line 58: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;

54: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;
55: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
56: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
57: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
58: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
59: l_update_adm_appl_number igs_ad_apl_int.update_adm_appl_number%TYPE;
60: l_update_adm_seq_number igs_ad_ps_appl_inst_int.update_adm_seq_number%TYPE;
61:
62: -- Get the admission application corresponding to the passed choice record

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

247: WHERE system_code = cp_system_code;
248: c_defaults_rec c_defaults%ROWTYPE ;
249:
250: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
251: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
252: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
253: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
254: SELECT sc.aca_cal_type,
255: sc.aca_cal_seq_no,

Line 252: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,

248: c_defaults_rec c_defaults%ROWTYPE ;
249:
250: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
251: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
252: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
253: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
254: SELECT sc.aca_cal_type,
255: sc.aca_cal_seq_no,
256: sc.adm_cal_type,

Line 253: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS

249:
250: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
251: CURSOR cur_sys_entry_cal_det ( cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
252: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
253: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
254: SELECT sc.aca_cal_type,
255: sc.aca_cal_seq_no,
256: sc.adm_cal_type,
257: sc.adm_cal_seq_no

Line 258: FROM igs_uc_sys_calndrs sc

254: SELECT sc.aca_cal_type,
255: sc.aca_cal_seq_no,
256: sc.adm_cal_type,
257: sc.adm_cal_seq_no
258: FROM igs_uc_sys_calndrs sc
259: WHERE sc.system_code = cp_system_code
260: AND sc.entry_year = cp_entry_year
261: AND sc.entry_month = cp_entry_month;
262:

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

369: l_sys_entry_cal_det_rec := NULL;
370: OPEN cur_sys_entry_cal_det(j.system_code, j.entry_year, j.entry_month);
371: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;
372: --If no matching Entry Year and Entry Month record for the system is found in the System Calendars table then
373: -- get the calendar details from the IGS_UC_SYS_CALNDRS table based on the system, Entry Year and Entry Month as 0 (Zero).
374: IF cur_sys_entry_cal_det%NOTFOUND THEN
375: CLOSE cur_sys_entry_cal_det;
376: OPEN cur_sys_entry_cal_det(j.system_code, j.entry_year, 0);
377: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;

Line 781: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;

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 ;
782: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
783: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
784: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
785: l_interface_mkdes_id NUMBER ;

Line 782: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%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 ;
782: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
783: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
784: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
785: l_interface_mkdes_id NUMBER ;
786: l_count NUMBER ;

Line 783: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;

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 ;
782: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
783: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
784: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
785: l_interface_mkdes_id NUMBER ;
786: l_count NUMBER ;
787: l_new_appl BOOLEAN ;

Line 784: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;

780: l_dec_batch_id NUMBER;
781: l_aca_cal_type igs_uc_sys_calndrs.aca_cal_type%TYPE ;
782: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
783: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
784: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
785: l_interface_mkdes_id NUMBER ;
786: l_count NUMBER ;
787: l_new_appl BOOLEAN ;
788: l_new_appl_inst BOOLEAN ;

Line 1135: igs_uc_sys_calndrs ucal,

1131: SELECT
1132: 'X'
1133: FROM
1134: igs_uc_app_choices uac,
1135: igs_uc_sys_calndrs ucal,
1136: igs_ad_appl_all apl,
1137: igs_ad_ps_appl_inst_all aplinst,
1138: igs_en_unit_set us,
1139: igs_en_unit_set_cat usc,

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

1192: AND a.export_to_oss_status = 'NEW'
1193: AND a.institute_code IN (SELECT df.current_inst_code FROM igs_uc_defaults df);
1194:
1195: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
1196: CURSOR cur_sys_entry_cal_det (cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
1197: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
1198: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
1199: SELECT aca_cal_type,
1200: aca_cal_seq_no,

Line 1197: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,

1193: AND a.institute_code IN (SELECT df.current_inst_code FROM igs_uc_defaults df);
1194:
1195: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
1196: CURSOR cur_sys_entry_cal_det (cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
1197: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
1198: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
1199: SELECT aca_cal_type,
1200: aca_cal_seq_no,
1201: adm_cal_type,

Line 1198: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS

1194:
1195: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
1196: CURSOR cur_sys_entry_cal_det (cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
1197: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
1198: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
1199: SELECT aca_cal_type,
1200: aca_cal_seq_no,
1201: adm_cal_type,
1202: adm_cal_seq_no

Line 1203: FROM igs_uc_sys_calndrs

1199: SELECT aca_cal_type,
1200: aca_cal_seq_no,
1201: adm_cal_type,
1202: adm_cal_seq_no
1203: FROM igs_uc_sys_calndrs
1204: WHERE system_code = cp_system_code
1205: AND entry_year = cp_entry_year
1206: AND entry_month = cp_entry_month;
1207:

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

1303: l_sys_entry_cal_det_rec := NULL;
1304: OPEN cur_sys_entry_cal_det(c_ch_system_rec.system_code, c_ch_system_rec.entry_year,c_ch_system_rec.entry_month );
1305: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;
1306: --If no matching Entry Year and Entry Month record for the system is found in the System Calendars table then
1307: -- get the calendar details from the IGS_UC_SYS_CALNDRS table based on the system, Entry Year and Entry Month as 0 (Zero).
1308: IF cur_sys_entry_cal_det%NOTFOUND THEN
1309: CLOSE cur_sys_entry_cal_det;
1310: OPEN cur_sys_entry_cal_det(c_ch_system_rec.system_code, c_ch_system_rec.entry_year, 0);
1311: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;

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

1402: l_sys_entry_cal_det_rec := NULL;
1403: OPEN cur_sys_entry_cal_det(c_new_app_ch_rec.system_code, c_new_app_ch_rec.entry_year, c_new_app_ch_rec.entry_month );
1404: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;
1405: --If no matching Entry Year and Entry Month record for the system is found in the System Calendars table then
1406: -- get the calendar details from the IGS_UC_SYS_CALNDRS table based on the system, Entry Year and Entry Month as 0 (Zero).
1407: IF cur_sys_entry_cal_det%NOTFOUND THEN
1408: CLOSE cur_sys_entry_cal_det;
1409: OPEN cur_sys_entry_cal_det(c_new_app_ch_rec.system_code, c_new_app_ch_rec.entry_year, 0);
1410: FETCH cur_sys_entry_cal_det INTO l_sys_entry_cal_det_rec;

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

2682: AND choice_no = NVL(p_choice_no, choice_no)
2683: AND system_code = cp_system_code;
2684:
2685: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
2686: CURSOR cur_sys_entry_cal_det (cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
2687: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
2688: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
2689: SELECT aca_cal_type,
2690: aca_cal_seq_no,

Line 2687: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,

2683: AND system_code = cp_system_code;
2684:
2685: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
2686: CURSOR cur_sys_entry_cal_det (cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
2687: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
2688: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
2689: SELECT aca_cal_type,
2690: aca_cal_seq_no,
2691: adm_cal_type,

Line 2688: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS

2684:
2685: --Cursor to get the Calendar details for the given System, Entry Month and Entry Year.
2686: CURSOR cur_sys_entry_cal_det (cp_system_code igs_uc_sys_calndrs.system_code%TYPE,
2687: cp_entry_year igs_uc_sys_calndrs.entry_year%TYPE,
2688: cp_entry_month igs_uc_sys_calndrs.entry_month%TYPE ) IS
2689: SELECT aca_cal_type,
2690: aca_cal_seq_no,
2691: adm_cal_type,
2692: adm_cal_seq_no

Line 2693: FROM igs_uc_sys_calndrs

2689: SELECT aca_cal_type,
2690: aca_cal_seq_no,
2691: adm_cal_type,
2692: adm_cal_seq_no
2693: FROM igs_uc_sys_calndrs
2694: WHERE system_code = cp_system_code
2695: AND entry_year = cp_entry_year
2696: AND (entry_month = cp_entry_month OR entry_month = 0)
2697: ORDER BY entry_month DESC;