APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_UC_CYC_DEFAULTS

Line 74: CURSOR cur_clearing (cp_system_code igs_uc_cyc_defaults.system_code%TYPE,

70: CURSOR cur_system_code(cp_appno igs_uc_applicants.app_no%TYPE) IS
71: SELECT system_code FROM igs_uc_applicants WHERE app_no = cp_appno;
72:
73: -- Check whether clearing flag is set for the system
74: CURSOR cur_clearing (cp_system_code igs_uc_cyc_defaults.system_code%TYPE,
75: cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE ) IS
76: SELECT clearing_flag FROM igs_uc_cyc_defaults
77: WHERE system_code = cp_system_code
78: AND ucas_cycle = cp_ucas_cycle;

Line 75: cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE ) IS

71: SELECT system_code FROM igs_uc_applicants WHERE app_no = cp_appno;
72:
73: -- Check whether clearing flag is set for the system
74: CURSOR cur_clearing (cp_system_code igs_uc_cyc_defaults.system_code%TYPE,
75: cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE ) IS
76: SELECT clearing_flag FROM igs_uc_cyc_defaults
77: WHERE system_code = cp_system_code
78: AND ucas_cycle = cp_ucas_cycle;
79: l_clearing igs_uc_cyc_defaults.clearing_flag%TYPE;

Line 76: SELECT clearing_flag FROM igs_uc_cyc_defaults

72:
73: -- Check whether clearing flag is set for the system
74: CURSOR cur_clearing (cp_system_code igs_uc_cyc_defaults.system_code%TYPE,
75: cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE ) IS
76: SELECT clearing_flag FROM igs_uc_cyc_defaults
77: WHERE system_code = cp_system_code
78: AND ucas_cycle = cp_ucas_cycle;
79: l_clearing igs_uc_cyc_defaults.clearing_flag%TYPE;
80:

Line 79: l_clearing igs_uc_cyc_defaults.clearing_flag%TYPE;

75: cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE ) IS
76: SELECT clearing_flag FROM igs_uc_cyc_defaults
77: WHERE system_code = cp_system_code
78: AND ucas_cycle = cp_ucas_cycle;
79: l_clearing igs_uc_cyc_defaults.clearing_flag%TYPE;
80:
81: -- Check whether exists any clearing record for the applicant.
82: CURSOR cur_app_clearing(cp_app_no igs_uc_app_clearing.app_no%TYPE) IS
83: SELECT 'X'

Line 118: l_system_code igs_uc_cyc_defaults.system_code%TYPE;

114: l_decision igs_uc_app_choices.decision%TYPE;
115: l_reply igs_uc_app_choices.reply%TYPE;
116: l_ucas_program_code igs_uc_app_choices.ucas_program_code%TYPE;
117: l_campus igs_uc_app_choices.campus%TYPE;
118: l_system_code igs_uc_cyc_defaults.system_code%TYPE;
119: l_system_name igs_uc_defaults.name%TYPE;
120: l_validate_error_cd igs_lookup_values.lookup_code%TYPE;
121: l_transaction_toy igs_uc_ucas_control.transaction_toy_code%TYPE;
122: