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_AS_VAL_UAI dependencies on IGS_CA_INST

Line 219: cp_cal_type IGS_CA_INST.cal_type%TYPE,

215: RETURN BOOLEAN IS
216: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
217: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
218: CURSOR c_cal_status(
219: cp_cal_type IGS_CA_INST.cal_type%TYPE,
220: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
221: SELECT IGS_CA_STAT.s_cal_status
222: FROM IGS_CA_INST, IGS_CA_STAT
223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND

Line 220: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

216: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
217: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
218: CURSOR c_cal_status(
219: cp_cal_type IGS_CA_INST.cal_type%TYPE,
220: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
221: SELECT IGS_CA_STAT.s_cal_status
222: FROM IGS_CA_INST, IGS_CA_STAT
223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
224: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND

Line 222: FROM IGS_CA_INST, IGS_CA_STAT

218: CURSOR c_cal_status(
219: cp_cal_type IGS_CA_INST.cal_type%TYPE,
220: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
221: SELECT IGS_CA_STAT.s_cal_status
222: FROM IGS_CA_INST, IGS_CA_STAT
223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
224: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
225: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
226: v_other_detail VARCHAR2(255);

Line 223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND

219: cp_cal_type IGS_CA_INST.cal_type%TYPE,
220: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
221: SELECT IGS_CA_STAT.s_cal_status
222: FROM IGS_CA_INST, IGS_CA_STAT
223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
224: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
225: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
226: v_other_detail VARCHAR2(255);
227: BEGIN

Line 224: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND

220: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
221: SELECT IGS_CA_STAT.s_cal_status
222: FROM IGS_CA_INST, IGS_CA_STAT
223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
224: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
225: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
226: v_other_detail VARCHAR2(255);
227: BEGIN
228: P_MESSAGE_NAME := null;

Line 225: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;

221: SELECT IGS_CA_STAT.s_cal_status
222: FROM IGS_CA_INST, IGS_CA_STAT
223: WHERE IGS_CA_INST.cal_type = cp_cal_type AND
224: IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
225: IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;
226: v_other_detail VARCHAR2(255);
227: BEGIN
228: P_MESSAGE_NAME := null;
229: OPEN c_cal_status(