eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CA_VAL_QLITY dependencies on IGS_RE_S_RES_CAL_CON

Line 194: v_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;

190: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
191: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
192: cst_teaching CONSTANT VARCHAR2(10) := 'TEACHING';
193: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
194: v_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;
195: v_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE;
196: v_last_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
197: v_last_alias_type IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;
198: v_last_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;

Line 195: v_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE;

191: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
192: cst_teaching CONSTANT VARCHAR2(10) := 'TEACHING';
193: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
194: v_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;
195: v_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE;
196: v_last_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
197: v_last_alias_type IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;
198: v_last_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
199: v_last_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;

Line 197: v_last_alias_type IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;

193: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
194: v_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;
195: v_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE;
196: v_last_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
197: v_last_alias_type IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE;
198: v_last_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
199: v_last_ci_sequence_number IGS_CA_DA_INST.ci_sequence_number%TYPE;
200: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE;
201: v_out_of_order BOOLEAN;

Line 210: FROM IGS_RE_S_RES_CAL_CON srcc

206: v_dummy VARCHAR2(1);
207: CURSOR c_srcc IS
208: SELECT srcc.effective_strt_dt_alias,
209: srcc.effective_end_dt_alias
210: FROM IGS_RE_S_RES_CAL_CON srcc
211: WHERE s_control_num = 1;
212: CURSOR c_dai_cat (
213: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,
214: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS

Line 213: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,

209: srcc.effective_end_dt_alias
210: FROM IGS_RE_S_RES_CAL_CON srcc
211: WHERE s_control_num = 1;
212: CURSOR c_dai_cat (
213: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,
214: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS
215: SELECT dai.CAL_TYPE,
216: cat.S_CAL_CAT
217: FROM IGS_CA_DA_INST dai,

Line 214: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS

210: FROM IGS_RE_S_RES_CAL_CON srcc
211: WHERE s_control_num = 1;
212: CURSOR c_dai_cat (
213: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,
214: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS
215: SELECT dai.CAL_TYPE,
216: cat.S_CAL_CAT
217: FROM IGS_CA_DA_INST dai,
218: IGS_CA_TYPE cat

Line 247: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,

243: cat.S_CAL_CAT = cst_teaching;
244: CURSOR c_dai (
245: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
246: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
247: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,
248: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS
249: SELECT NVL (
250: dai.absolute_val,
251: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL (

Line 248: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS

244: CURSOR c_dai (
245: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
246: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
247: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,
248: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS
249: SELECT NVL (
250: dai.absolute_val,
251: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL (
252: dai.DT_ALIAS,

Line 287: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,

283: uv.version_number = uop.version_number AND
284: uv.research_unit_ind = 'Y' AND
285: uop.delete_flag = 'N';
286: CURSOR c_dai_ci_cs_cat (
287: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,
288: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS
289: SELECT NVL (
290: dai.absolute_val,
291: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(

Line 288: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS

284: uv.research_unit_ind = 'Y' AND
285: uop.delete_flag = 'N';
286: CURSOR c_dai_ci_cs_cat (
287: cp_effective_strt_dt_alias IGS_RE_S_RES_CAL_CON.effective_strt_dt_alias%TYPE,
288: cp_effective_end_dt_alias IGS_RE_S_RES_CAL_CON.effective_end_dt_alias%TYPE) IS
289: SELECT NVL (
290: dai.absolute_val,
291: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
292: dai.DT_ALIAS,

Line 351: FROM IGS_RE_S_RES_CAL_CON srcc,

347: cs.CAL_STATUS = ci.CAL_STATUS AND
348: cs.s_cal_status IN (cst_active,cst_planned) AND
349: EXISTS (
350: SELECT 'X'
351: FROM IGS_RE_S_RES_CAL_CON srcc,
352: IGS_CA_DA_INST dai
353: WHERE srcc.s_control_num = 1 AND
354: dai.CAL_TYPE = ci.CAL_TYPE AND
355: dai.ci_sequence_number = ci.sequence_number AND