APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_UC_APP_CHOICES

Line 52: CURSOR cur_cycle(cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS

48: (reverse chronological order - newest change first)
49: ***************************************************************/
50:
51: -- Get the ucas_cycle from app_choices;
52: CURSOR cur_cycle(cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS
53: SELECT MAX(ucas_cycle) FROM igs_uc_app_choices
54: WHERE app_no = cp_app_no
55: AND choice_no = cp_choice_no;
56:

Line 53: SELECT MAX(ucas_cycle) FROM igs_uc_app_choices

49: ***************************************************************/
50:
51: -- Get the ucas_cycle from app_choices;
52: CURSOR cur_cycle(cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS
53: SELECT MAX(ucas_cycle) FROM igs_uc_app_choices
54: WHERE app_no = cp_app_no
55: AND choice_no = cp_choice_no;
56:
57: l_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE;

Line 57: l_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE;

53: SELECT MAX(ucas_cycle) FROM igs_uc_app_choices
54: WHERE app_no = cp_app_no
55: AND choice_no = cp_choice_no;
56:
57: l_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE;
58:
59: -- Get the decision and reply, program details for the applicant choice.
60: CURSOR c_app_choices(cp_app_no igs_uc_app_choices.app_no%TYPE,
61: cp_choice_no igs_uc_app_choices.choice_no%TYPE,

Line 60: CURSOR c_app_choices(cp_app_no igs_uc_app_choices.app_no%TYPE,

56:
57: l_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE;
58:
59: -- Get the decision and reply, program details for the applicant choice.
60: CURSOR c_app_choices(cp_app_no igs_uc_app_choices.app_no%TYPE,
61: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
62: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE) IS
63: SELECT decision, reply , ucas_program_code, campus
64: FROM igs_uc_app_choices

Line 61: cp_choice_no igs_uc_app_choices.choice_no%TYPE,

57: l_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE;
58:
59: -- Get the decision and reply, program details for the applicant choice.
60: CURSOR c_app_choices(cp_app_no igs_uc_app_choices.app_no%TYPE,
61: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
62: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE) IS
63: SELECT decision, reply , ucas_program_code, campus
64: FROM igs_uc_app_choices
65: WHERE app_no= cp_app_no

Line 62: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE) IS

58:
59: -- Get the decision and reply, program details for the applicant choice.
60: CURSOR c_app_choices(cp_app_no igs_uc_app_choices.app_no%TYPE,
61: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
62: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE) IS
63: SELECT decision, reply , ucas_program_code, campus
64: FROM igs_uc_app_choices
65: WHERE app_no= cp_app_no
66: AND choice_no = cp_choice_no

Line 64: FROM igs_uc_app_choices

60: CURSOR c_app_choices(cp_app_no igs_uc_app_choices.app_no%TYPE,
61: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
62: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE) IS
63: SELECT decision, reply , ucas_program_code, campus
64: FROM igs_uc_app_choices
65: WHERE app_no= cp_app_no
66: AND choice_no = cp_choice_no
67: AND ucas_cycle = cp_ucas_cycle;
68:

Line 112: l_decision_value igs_uc_app_choices.decision%TYPE;

108: WHERE system_code = p_system_code;
109:
110: app_clr_rnd_rec cur_app_clr_rnd%ROWTYPE;
111:
112: l_decision_value igs_uc_app_choices.decision%TYPE;
113: l_transaction_type igs_uc_transactions.transaction_type%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;

Line 114: l_decision igs_uc_app_choices.decision%TYPE;

110: app_clr_rnd_rec cur_app_clr_rnd%ROWTYPE;
111:
112: l_decision_value igs_uc_app_choices.decision%TYPE;
113: l_transaction_type igs_uc_transactions.transaction_type%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;

Line 115: l_reply igs_uc_app_choices.reply%TYPE;

111:
112: l_decision_value igs_uc_app_choices.decision%TYPE;
113: l_transaction_type igs_uc_transactions.transaction_type%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;

Line 116: l_ucas_program_code igs_uc_app_choices.ucas_program_code%TYPE;

112: l_decision_value igs_uc_app_choices.decision%TYPE;
113: l_transaction_type igs_uc_transactions.transaction_type%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;

Line 117: l_campus igs_uc_app_choices.campus%TYPE;

113: l_transaction_type igs_uc_transactions.transaction_type%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;