APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_CODE_CLASSES

Line 39: --jchakrab 03-Oct-2005 Modified for 4506750 Impact - added extra filter for IGS_AD_CODE_CLASSES.class_type_code

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
42: --jchakrab 22-May-2006 Modified for 5165624
43: ***************************************************************** */

Line 140: FROM igs_ad_code_classes

136: appl_inst_int_id_rec c_appl_inst_int_id%ROWTYPE;
137: -- Get ucas application source from code classes
138: CURSOR cur_code_id IS
139: SELECT code_id
140: FROM igs_ad_code_classes
141: WHERE class = 'SYS_APPL_SOURCE'
142: AND name = 'UCAS'
143: AND class_type_code = 'ADM_CODE_CLASSES';
144:

Line 145: l_code_id igs_ad_code_classes.code_id%TYPE;

141: WHERE class = 'SYS_APPL_SOURCE'
142: AND name = 'UCAS'
143: AND class_type_code = 'ADM_CODE_CLASSES';
144:
145: l_code_id igs_ad_code_classes.code_id%TYPE;
146: -- Get all the application choices belonging to the passed app_no and choice_no in status OC
147: -- if choice no is null then get all the choices in status OC belonging to the current institution
148: -- smaddali modified cursor to select system_code also ,for bug 2643048
149: CURSOR c_uc_app_ch IS