APPS.IGS_UC_EXT_MARVIN dependencies on IGS_UC_DEFAULTS

Line 264: FROM igs_uc_defaults ;

260: || for the bug # 2643048
261: */
262: CURSOR cur_c1 IS
263: SELECT DISTINCT current_inst_code
264: FROM igs_uc_defaults ;
265:
266: l_max_line NUMBER(7) DEFAULT 99999; --DEFAULT 17;
267: l_total_lines NUMBER(7);
268: l_inst_code igs_uc_defaults.current_inst_code%TYPE;

Line 268: l_inst_code igs_uc_defaults.current_inst_code%TYPE;

264: FROM igs_uc_defaults ;
265:
266: l_max_line NUMBER(7) DEFAULT 99999; --DEFAULT 17;
267: l_total_lines NUMBER(7);
268: l_inst_code igs_uc_defaults.current_inst_code%TYPE;
269:
270: BEGIN
271:
272: -- Get the Institution Code

Line 1233: FROM IGS_UC_DEFAULTS ;

1229: -- Find the UCAS System Configured Cycle
1230: CURSOR ucas_cycles_cur IS
1231: SELECT MAX(configured_cycle) configured_cycle,
1232: MAX(current_cycle) current_cycle
1233: FROM IGS_UC_DEFAULTS ;
1234: ucas_cycles_rec ucas_cycles_cur%ROWTYPE;
1235:
1236: -- Find the Current Institute Code and Security Key
1237: CURSOR cur_inst_code IS

Line 1239: FROM IGS_UC_DEFAULTS ;

1235:
1236: -- Find the Current Institute Code and Security Key
1237: CURSOR cur_inst_code IS
1238: SELECT DISTINCT current_inst_code, ucas_security_key
1239: FROM IGS_UC_DEFAULTS ;
1240:
1241: -- Bug No: 3156212. Cursor changed to consider only MARVIN interface.
1242: -- Fetch all the UCAS Systems setup in the System
1243: CURSOR ucas_systems_cur (cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS

Line 1246: FROM IGS_UC_DEFAULTS ucd, IGS_UC_CYC_DEFAULTS uccd

1242: -- Fetch all the UCAS Systems setup in the System
1243: CURSOR ucas_systems_cur (cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE) IS
1244: SELECT DISTINCT ucd.system_code system_code,
1245: DECODE(ucd.system_code,'U',1,'G',2,'N',3,'S',4,5)
1246: FROM IGS_UC_DEFAULTS ucd, IGS_UC_CYC_DEFAULTS uccd
1247: WHERE ucd.system_code = uccd.system_code AND
1248: uccd.ucas_cycle = cp_ucas_cycle AND
1249: uccd.ucas_interface = 'M'
1250: ORDER BY 2;

Line 1253: l_inst_code igs_uc_defaults.current_inst_code%TYPE;

1249: uccd.ucas_interface = 'M'
1250: ORDER BY 2;
1251:
1252:
1253: l_inst_code igs_uc_defaults.current_inst_code%TYPE;
1254: l_sec_key igs_uc_defaults.ucas_security_key%TYPE;
1255: l_directory VARCHAR2(240) ;
1256: l_dummy ucas_systems_cur%ROWTYPE;
1257: l_trans_exist BOOLEAN := FALSE; -- addded for bug#3872286

Line 1254: l_sec_key igs_uc_defaults.ucas_security_key%TYPE;

1250: ORDER BY 2;
1251:
1252:
1253: l_inst_code igs_uc_defaults.current_inst_code%TYPE;
1254: l_sec_key igs_uc_defaults.ucas_security_key%TYPE;
1255: l_directory VARCHAR2(240) ;
1256: l_dummy ucas_systems_cur%ROWTYPE;
1257: l_trans_exist BOOLEAN := FALSE; -- addded for bug#3872286
1258: