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

Line 35: --smaddali ,bug2643048 UCFD102 build. Modified procedure to add check for igs_uc_defaults.system_code

31: for all valid choices in status OC of the passed application
32: Known limitations,enhancements,remarks:
33: Change History
34: Who When What
35: --smaddali ,bug2643048 UCFD102 build. Modified procedure to add check for igs_uc_defaults.system_code
36: -- and modified insert row of igs_ad_apl_int to insert values for columns alt_appl_id and admission_application_type
37: -- and to get the admission and academic calendars set up in igs_uc_defaults for the application choice system
38: --pmarada 22-aug-2003 REmoved the insert row call to igs_ad_stat_int table, this is not required.bug 3094409
39: --jchakrab 03-Oct-2005 Modified for 4506750 Impact - added extra filter for IGS_AD_CODE_CLASSES.class_type_code

Line 37: -- and to get the admission and academic calendars set up in igs_uc_defaults for the application choice system

33: Change History
34: Who When What
35: --smaddali ,bug2643048 UCFD102 build. Modified procedure to add check for igs_uc_defaults.system_code
36: -- and modified insert row of igs_ad_apl_int to insert values for columns alt_appl_id and admission_application_type
37: -- and to get the admission and academic calendars set up in igs_uc_defaults for the application choice system
38: --pmarada 22-aug-2003 REmoved the insert row call to igs_ad_stat_int table, this is not required.bug 3094409
39: --jchakrab 03-Oct-2005 Modified for 4506750 Impact - added extra filter for IGS_AD_CODE_CLASSES.class_type_code
40: --jchakrab 10-Oct-2005 Modified for 4424068 - added CANCEL functionality for prog version change
41: --jchin 20-jan-2006 Modified for R12 perf improvements - bug 3691277 and 3691250

Line 156: a.institute_code = (SELECT df.current_inst_code FROM igs_uc_defaults df

152: a.route_b_pref_round, b.application_source , a.app_no , a.system_code, a.ucas_cycle, a.entry_year, a.entry_month
153: FROM igs_uc_app_choices a, igs_uc_applicants b
154: WHERE a.app_no=b.app_no AND
155: b.app_no=NVL(p_app_no ,b.app_no) AND
156: a.institute_code = (SELECT df.current_inst_code FROM igs_uc_defaults df
157: WHERE df.system_code = a.system_code) AND
158: a.export_to_oss_status = 'OC' AND
159: a.choice_no = NVL(p_choice_no,a.choice_no)
160: ORDER BY a.choice_no ;

Line 226: AND cr.institute = (SELECT current_inst_code FROM igs_uc_defaults df WHERE df.system_code = cr.system_code)

222: cr.oss_attendance_mode
223: FROM igs_uc_crse_dets cr
224: WHERE cr.ucas_program_code = cp_ucas_program_code
225: AND cr.ucas_campus = cp_ucas_campus
226: AND cr.institute = (SELECT current_inst_code FROM igs_uc_defaults df WHERE df.system_code = cr.system_code)
227: AND cr.system_code = cp_system_code
228: AND cr.oss_program_code IS NOT NULL
229: AND cr.oss_location IS NOT NULL;
230: oss_prog_mapped_rec cur_oss_prog_mapped%ROWTYPE;

Line 244: CURSOR c_defaults( cp_system_code igs_uc_defaults.system_code%TYPE) IS

240: AND a.ucas_cycle = cp_ucas_cycle;
241: app_choices_rec cur_app_choices%ROWTYPE;
242:
243: -- smaddali added cursor ,for bug 2643048
244: CURSOR c_defaults( cp_system_code igs_uc_defaults.system_code%TYPE) IS
245: SELECT *
246: FROM igs_uc_defaults def
247: WHERE system_code = cp_system_code;
248: c_defaults_rec c_defaults%ROWTYPE ;

Line 246: FROM igs_uc_defaults def

242:
243: -- smaddali added cursor ,for bug 2643048
244: CURSOR c_defaults( cp_system_code igs_uc_defaults.system_code%TYPE) IS
245: SELECT *
246: FROM igs_uc_defaults def
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.

Line 809: ch.institute_code = (SELECT df.current_inst_code FROM igs_uc_defaults df

805: FROM igs_uc_app_choices ch
806: WHERE ch.app_no = NVL(p_app_no,ch.app_no) AND
807: ch.export_to_oss_status = 'NEW' AND
808: ch.choice_no = NVL(p_choice_no , ch.choice_no) AND
809: ch.institute_code = (SELECT df.current_inst_code FROM igs_uc_defaults df
810: WHERE df.system_code = ch.system_code)
811: ORDER BY ch.ucas_cycle, ch.app_no, ch.choice_no;
812:
813: -- Get all valid application choices with status OO belonging to current institution

Line 821: ch.institute_code = (SELECT df.current_inst_code FROM igs_uc_defaults df

817: FROM igs_uc_app_choices ch
818: WHERE ch.app_no = NVL(p_app_no,ch.app_no) AND
819: ch.export_to_oss_status ='OO' AND
820: ch.choice_no = NVL(p_choice_no , ch.choice_no) AND
821: ch.institute_code = (SELECT df.current_inst_code FROM igs_uc_defaults df
822: WHERE df.system_code = ch.system_code)
823: ORDER BY ch.ucas_cycle, ch.app_no, ch.choice_no;
824:
825: -- Get the admission application corresponding to the passed application choice

Line 1072: CURSOR c_defaults( cp_system_code igs_uc_defaults.system_code%TYPE) IS

1068: AND CFG.SEQUENCE_NO = P_SEQ_NO;
1069: c_unit_set_cd_rec c_unit_set_cd%ROWTYPE;
1070:
1071: -- smaddali added cursors ,for bug 2643048 UCFD102 build
1072: CURSOR c_defaults( cp_system_code igs_uc_defaults.system_code%TYPE) IS
1073: SELECT *
1074: FROM igs_uc_defaults def
1075: WHERE def.system_code = NVL(cp_system_code, def.system_code);
1076: c_defaults_rec c_defaults%ROWTYPE ;

Line 1074: FROM igs_uc_defaults def

1070:
1071: -- smaddali added cursors ,for bug 2643048 UCFD102 build
1072: CURSOR c_defaults( cp_system_code igs_uc_defaults.system_code%TYPE) IS
1073: SELECT *
1074: FROM igs_uc_defaults def
1075: WHERE def.system_code = NVL(cp_system_code, def.system_code);
1076: c_defaults_rec c_defaults%ROWTYPE ;
1077:
1078: CURSOR c_obs_ou_stat ( cp_out_stat igs_ad_ou_stat.adm_outcome_status%TYPE) IS

Line 1193: AND a.institute_code IN (SELECT df.current_inst_code FROM igs_uc_defaults df);

1189: FROM igs_uc_app_choices a
1190: WHERE a.app_no = NVL(p_app_no, a.app_no)
1191: AND a.choice_no = NVL(p_choice_no,a.choice_no)
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,

Line 1212: CURSOR cur_apc_det ( cp_application_type igs_uc_defaults.application_type%TYPE) IS

1208: l_sys_entry_cal_det_rec cur_sys_entry_cal_det%ROWTYPE;
1209:
1210: --Cursor to get the Admission Process Category and Admission Process Type for the
1211: --Admission Application Type defined for the System in UCAS Setup.
1212: CURSOR cur_apc_det ( cp_application_type igs_uc_defaults.application_type%TYPE) IS
1213: SELECT admission_cat, s_admission_process_type
1214: FROM igs_ad_ss_appl_typ
1215: WHERE admission_application_type = cp_application_type
1216: AND closed_ind = 'N';

Line 2240: ch.institute_code = (SELECT df.current_inst_code FROM igs_uc_defaults df

2236: FROM igs_uc_app_choices ch
2237: WHERE ch.app_no = NVL(p_app_no,ch.app_no) AND
2238: ch.export_to_oss_status = 'AP' AND
2239: ch.choice_no = NVL(p_choice_no , ch.choice_no) AND
2240: ch.institute_code = (SELECT df.current_inst_code FROM igs_uc_defaults df
2241: WHERE df.system_code = ch.system_code)
2242: ORDER BY ch.app_no , ch.choice_no ;
2243: c_ap_ch_rec c_ap_ch%ROWTYPE ;
2244:

Line 2340: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF

2336: -- jchakrab changed c_oc_app_ch to a ref cursor to execute different queries based on parameter values (3691186)
2337: IF p_app_no IS NOT NULL AND p_choice_no IS NOT NULL THEN
2338: OPEN c_oc_app_ch FOR
2339: SELECT DISTINCT AP.APP_NO
2340: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF
2341: WHERE AP.APP_NO = CH.APP_NO AND
2342: CH.APP_NO = P_APP_NO AND
2343: DF.SYSTEM_CODE = CH.SYSTEM_CODE AND
2344: CH.EXPORT_TO_OSS_STATUS = 'OC' AND

Line 2352: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF

2348:
2349: ELSIF p_app_no IS NOT NULL AND p_choice_no IS NULL THEN
2350: OPEN c_oc_app_ch FOR
2351: SELECT DISTINCT AP.APP_NO
2352: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF
2353: WHERE AP.APP_NO = CH.APP_NO AND
2354: CH.APP_NO = P_APP_NO AND
2355: DF.SYSTEM_CODE = CH.SYSTEM_CODE AND
2356: CH.EXPORT_TO_OSS_STATUS = 'OC' AND

Line 2363: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF

2359:
2360: ELSE
2361: OPEN c_oc_app_ch FOR
2362: SELECT DISTINCT AP.APP_NO
2363: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF
2364: WHERE AP.APP_NO = CH.APP_NO AND
2365: DF.SYSTEM_CODE = CH.SYSTEM_CODE AND
2366: CH.EXPORT_TO_OSS_STATUS = 'OC' AND
2367: CH.INSTITUTE_CODE = DF.CURRENT_INST_CODE

Line 2671: CURSOR c_defaults( cp_system_code igs_uc_defaults.system_code%TYPE) IS

2667: WHERE a.app_no = NVL(p_app_no, a.app_no) AND
2668: a.choice_no = NVL(p_choice_no,a.choice_no) ;
2669:
2670: -- smaddali added cursor ,for bug 2643048
2671: CURSOR c_defaults( cp_system_code igs_uc_defaults.system_code%TYPE) IS
2672: SELECT *
2673: FROM igs_uc_defaults def
2674: WHERE system_code = cp_system_code;
2675: c_defaults_rec c_defaults%ROWTYPE ;

Line 2673: FROM igs_uc_defaults def

2669:
2670: -- smaddali added cursor ,for bug 2643048
2671: CURSOR c_defaults( cp_system_code igs_uc_defaults.system_code%TYPE) IS
2672: SELECT *
2673: FROM igs_uc_defaults def
2674: WHERE system_code = cp_system_code;
2675: c_defaults_rec c_defaults%ROWTYPE ;
2676:
2677: --Curosor to get the Entry Year, Entry Month details that are need to check for calendar setup.

Line 2678: CURSOR cur_app_choice_entry_det (cp_system_code igs_uc_defaults.system_code%TYPE) IS

2674: WHERE system_code = cp_system_code;
2675: c_defaults_rec c_defaults%ROWTYPE ;
2676:
2677: --Curosor to get the Entry Year, Entry Month details that are need to check for calendar setup.
2678: CURSOR cur_app_choice_entry_det (cp_system_code igs_uc_defaults.system_code%TYPE) IS
2679: SELECT DISTINCT entry_year, entry_month
2680: FROM igs_uc_app_choices
2681: WHERE app_no = NVL(p_app_no, app_no)
2682: AND choice_no = NVL(p_choice_no, choice_no)

Line 2714: CURSOR cur_apc_det ( cp_application_type igs_uc_defaults.application_type%TYPE) IS

2710: l_found_flag VARCHAR2(1);
2711:
2712: --Cursor to get the Admission Process Category and Admission Process Type for the
2713: --Admission Application Type defined for the System in UCAS Setup.
2714: CURSOR cur_apc_det ( cp_application_type igs_uc_defaults.application_type%TYPE) IS
2715: SELECT admission_cat, s_admission_process_type
2716: FROM igs_ad_ss_appl_typ
2717: WHERE admission_application_type = cp_application_type
2718: AND closed_ind = 'N';