APPS.IGS_UC_EXPORT_UCAS_PKG dependencies on IGS_UC_UCAS_CONTROL

Line 28: Replaced reference to igs_uc_cvcontrol_2003_v with igs_uc_ucas_control

24: Who When What
25: anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
26: jbaber 16-Aug-05 Modified for UC307 - HERCULES Small Systems Support
27: jbaber 12-Jul-05 Modified for UC315 - UCAS Support 2006
28: Replaced reference to igs_uc_cvcontrol_2003_v with igs_uc_ucas_control
29: Removed references to export_inst_conts, export_inst_cnt_grp, export_crse_dets,
30: export_crse_vac_ops, export_crse_keywrds and export_offer_abbrev as these are no
31: longer supported by UCAS as updateable views.
32: pmarada 03-Jul-03 Modified as per the UCFD203 build. bug 2669208

Line 42: CURSOR cur_control (cp_system_code igs_uc_ucas_control.system_code%TYPE) IS

38: FROM igs_uc_defaults ;
39:
40: cur_cycle_rec cur_cycle%ROWTYPE;
41:
42: CURSOR cur_control (cp_system_code igs_uc_ucas_control.system_code%TYPE) IS
43: SELECT TO_NUMBER(LPAD(entry_year,4,200))
44: FROM igs_uc_ucas_control
45: WHERE system_code = cp_system_code
46: AND ucas_cycle = cur_cycle_rec.configured_cycle;

Line 44: FROM igs_uc_ucas_control

40: cur_cycle_rec cur_cycle%ROWTYPE;
41:
42: CURSOR cur_control (cp_system_code igs_uc_ucas_control.system_code%TYPE) IS
43: SELECT TO_NUMBER(LPAD(entry_year,4,200))
44: FROM igs_uc_ucas_control
45: WHERE system_code = cp_system_code
46: AND ucas_cycle = cur_cycle_rec.configured_cycle;
47:
48:

Line 51: CURSOR cur_interface(cp_system_code igs_uc_ucas_control.system_code%TYPE) IS

47:
48:
49: l_entry_year igs_uc_defaults.configured_cycle%TYPE;
50:
51: CURSOR cur_interface(cp_system_code igs_uc_ucas_control.system_code%TYPE) IS
52: SELECT ucas_interface FROM igs_uc_cyc_defaults
53: WHERE ucas_cycle = cur_cycle_rec.configured_cycle
54: AND system_code = cp_system_code;
55: l_interface igs_uc_cyc_defaults.ucas_interface%TYPE;