APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_UC_APP_CHOICES

Line 78: SELECT decision,reply FROM igs_uc_app_choices

74: AND ucas_cycle = p_ucas_cycle
75: AND transaction_type = cp_transaction_type;
76:
77: CURSOR cur_app_choice_decision IS
78: SELECT decision,reply FROM igs_uc_app_choices
79: WHERE app_no = P_App_no
80: AND choice_no = P_Choice_no
81: AND ucas_cycle = p_ucas_cycle;
82:

Line 104: SELECT COUNT(*) FROM igs_uc_app_choices

100: SELECT COUNT(*) FROM igs_uc_applicants WHERE app_no = p_app_no;
101:
102: -- Get the count of records exists in the choices tabel between 1 to 6 choices, for PE
103: CURSOR cur_choices IS
104: SELECT COUNT(*) FROM igs_uc_app_choices
105: WHERE app_no = p_app_no AND (choice_no BETWEEN 1 AND 6)
106: AND ucas_cycle = p_ucas_cycle
107: AND institute_code = (SELECT current_inst_code FROM igs_uc_defaults WHERE system_code = p_system_code);
108:

Line 110: CURSOR cur_rec_found(cp_appno igs_uc_app_choices.app_no%TYPE,

106: AND ucas_cycle = p_ucas_cycle
107: AND institute_code = (SELECT current_inst_code FROM igs_uc_defaults WHERE system_code = p_system_code);
108:
109: -- Check whether record exists in app_chocies for the cycle
110: CURSOR cur_rec_found(cp_appno igs_uc_app_choices.app_no%TYPE,
111: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
112: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE,
113: cp_system_code igs_uc_app_choices.system_code%TYPE) IS
114: SELECT 'X' FROM igs_uc_app_choices

Line 111: cp_choice_no igs_uc_app_choices.choice_no%TYPE,

107: AND institute_code = (SELECT current_inst_code FROM igs_uc_defaults WHERE system_code = p_system_code);
108:
109: -- Check whether record exists in app_chocies for the cycle
110: CURSOR cur_rec_found(cp_appno igs_uc_app_choices.app_no%TYPE,
111: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
112: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE,
113: cp_system_code igs_uc_app_choices.system_code%TYPE) IS
114: SELECT 'X' FROM igs_uc_app_choices
115: WHERE app_no = cp_appno

Line 112: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE,

108:
109: -- Check whether record exists in app_chocies for the cycle
110: CURSOR cur_rec_found(cp_appno igs_uc_app_choices.app_no%TYPE,
111: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
112: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE,
113: cp_system_code igs_uc_app_choices.system_code%TYPE) IS
114: SELECT 'X' FROM igs_uc_app_choices
115: WHERE app_no = cp_appno
116: AND choice_no = cp_choice_no

Line 113: cp_system_code igs_uc_app_choices.system_code%TYPE) IS

109: -- Check whether record exists in app_chocies for the cycle
110: CURSOR cur_rec_found(cp_appno igs_uc_app_choices.app_no%TYPE,
111: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
112: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE,
113: cp_system_code igs_uc_app_choices.system_code%TYPE) IS
114: SELECT 'X' FROM igs_uc_app_choices
115: WHERE app_no = cp_appno
116: AND choice_no = cp_choice_no
117: AND ucas_cycle = cp_ucas_cycle

Line 114: SELECT 'X' FROM igs_uc_app_choices

110: CURSOR cur_rec_found(cp_appno igs_uc_app_choices.app_no%TYPE,
111: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
112: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE,
113: cp_system_code igs_uc_app_choices.system_code%TYPE) IS
114: SELECT 'X' FROM igs_uc_app_choices
115: WHERE app_no = cp_appno
116: AND choice_no = cp_choice_no
117: AND ucas_cycle = cp_ucas_cycle
118: AND system_code = cp_system_code;

Line 127: l_decision igs_uc_app_choices.decision%TYPE;

123: WHERE uc_tran_id = cp_uc_tran_id;
124:
125: l_transactions c_transactions%ROWTYPE;
126:
127: l_decision igs_uc_app_choices.decision%TYPE;
128: l_reply igs_uc_app_choices.reply%TYPE;
129: l_cnt NUMBER;
130: l_cnt1 NUMBER;
131: l_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

Line 128: l_reply igs_uc_app_choices.reply%TYPE;

124:
125: l_transactions c_transactions%ROWTYPE;
126:
127: l_decision igs_uc_app_choices.decision%TYPE;
128: l_reply igs_uc_app_choices.reply%TYPE;
129: l_cnt NUMBER;
130: l_cnt1 NUMBER;
131: l_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
132: l_return1 igs_uc_transactions.return1%TYPE;

Line 2041: CURSOR c_decision_cd(cp_system_code igs_uc_app_choices.system_code%TYPE,

2037: l_sys_cd igs_uc_applicants.system_code%TYPE;
2038:
2039: --Cursor to get the decision code associated with the current outcome status and the new outcome status
2040:
2041: CURSOR c_decision_cd(cp_system_code igs_uc_app_choices.system_code%TYPE,
2042: cp_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE) IS
2043: SELECT decision_code
2044: FROM igs_uc_map_out_stat
2045: WHERE system_code = cp_system_code

Line 2053: CURSOR c_curr_off_resp_status (cp_system_code igs_uc_app_choices.system_code%TYPE,

2049: l_decision_code igs_uc_map_out_stat.decision_code%TYPE;
2050:
2051: -- Cursor to find out if the reply code of Firm Acceptance is mapped to the decision code returned from the cursor (c_decision_cd) with the old outcome status
2052:
2053: CURSOR c_curr_off_resp_status (cp_system_code igs_uc_app_choices.system_code%TYPE,
2054: cp_decision_code igs_uc_map_out_stat.decision_code%TYPE,
2055: cp_adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE) IS
2056: SELECT 'X'
2057: FROM igs_uc_map_off_resp

Line 2073: CURSOR c_new_off_resp_status(cp_system_code igs_uc_app_choices.system_code%TYPE,

2069:
2070: -- Cursor to get the admission offer response mapped out to the reply code of Firm Acceptance and decision code returned from the cursor (c_decision_cd) with the new
2071: -- outcome status
2072:
2073: CURSOR c_new_off_resp_status(cp_system_code igs_uc_app_choices.system_code%TYPE,
2074: cp_decision_code igs_uc_map_out_stat.decision_code%TYPE) IS
2075: SELECT adm_offer_resp_status
2076: FROM igs_uc_map_off_resp
2077: WHERE system_code = cp_system_code