APPS.IGS_EN_GEN_013 dependencies on IGS_CA_DA_INST_V

Line 142: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

138: v_variation_cutoff_dt_alias IGS_EN_CAL_CONF.variation_cutoff_dt_alias%TYPE;
139: v_after_cutoff_warning BOOLEAN;
140: v_dummy_date DATE;
141: v_admin_unit_status_str VARCHAR2(2000);
142: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
143: v_max_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
144:
145: CURSOR c_s_enr_cal_conf IS
146: SELECT variation_cutoff_dt_alias

Line 143: v_max_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

139: v_after_cutoff_warning BOOLEAN;
140: v_dummy_date DATE;
141: v_admin_unit_status_str VARCHAR2(2000);
142: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
143: v_max_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
144:
145: CURSOR c_s_enr_cal_conf IS
146: SELECT variation_cutoff_dt_alias
147: FROM IGS_EN_CAL_CONF

Line 151: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

147: FROM IGS_EN_CAL_CONF
148: WHERE s_control_num = 1;
149:
150: CURSOR c_get_max_alias_val (
151: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
152: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
153: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
154: SELECT
155: MAX(alias_val)

Line 152: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

148: WHERE s_control_num = 1;
149:
150: CURSOR c_get_max_alias_val (
151: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
152: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
153: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
154: SELECT
155: MAX(alias_val)
156: FROM

Line 153: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

149:
150: CURSOR c_get_max_alias_val (
151: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
152: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
153: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
154: SELECT
155: MAX(alias_val)
156: FROM
157: IGS_CA_DA_INST_V

Line 157: IGS_CA_DA_INST_V

153: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
154: SELECT
155: MAX(alias_val)
156: FROM
157: IGS_CA_DA_INST_V
158: WHERE cal_type = cp_cal_type AND
159: ci_sequence_number = cp_ci_sequence_number AND
160: dt_alias = cp_dt_alias AND
161: alias_val IS NOT NULL;

Line 205: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

201: cal_type = cp_cal_type AND
202: ci_sequence_number = cp_ci_sequence_number AND
203: unit_attempt_status = 'ENROLLED';
204:
205: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
206: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
207: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
208: SELECT alias_val
209: FROM IGS_CA_DA_INST_V

Line 206: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

202: ci_sequence_number = cp_ci_sequence_number AND
203: unit_attempt_status = 'ENROLLED';
204:
205: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
206: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
207: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
208: SELECT alias_val
209: FROM IGS_CA_DA_INST_V
210: WHERE

Line 207: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

203: unit_attempt_status = 'ENROLLED';
204:
205: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
206: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
207: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
208: SELECT alias_val
209: FROM IGS_CA_DA_INST_V
210: WHERE
211: cal_type = cp_cal_type AND

Line 209: FROM IGS_CA_DA_INST_V

205: CURSOR c_dai_v(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
206: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
207: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
208: SELECT alias_val
209: FROM IGS_CA_DA_INST_V
210: WHERE
211: cal_type = cp_cal_type AND
212: ci_sequence_number = cp_ci_sequence_number AND
213: dt_alias = cp_dt_alias AND