APPS.IGS_CA_VAL_CAT dependencies on IGS_CA_INST

Line 15: FROM IGS_CA_INST ci,

11: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
12: CURSOR c_cal_instance_rec (
13: cp_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE) IS
14: SELECT DISTINCT 'x'
15: FROM IGS_CA_INST ci,
16: IGS_CA_STAT cs
17: WHERE ci.CAL_TYPE = cp_cal_type AND
18: cs.CAL_STATUS = ci.CAL_STATUS AND
19: cs.s_cal_status IN (cst_active, cst_inactive);

Line 21: v_cal_instance_rec IGS_CA_INST%ROWTYPE;

17: WHERE ci.CAL_TYPE = cp_cal_type AND
18: cs.CAL_STATUS = ci.CAL_STATUS AND
19: cs.s_cal_status IN (cst_active, cst_inactive);
20: v_other_detail VARCHAR2(255);
21: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
22: v_check CHAR;
23: BEGIN
24: -- This module validates that IGS_CA_TYPE.S_CAL_CAT
25: -- cannot be changed if ACTIVE calendar instances

Line 32: -- check for the existance of IGS_CA_INST

28: IF (p_cal_type IS NULL) THEN
29: p_message_name := 'IGS_GE_MANDATORY_FLD';
30: RETURN FALSE;
31: END IF;
32: -- check for the existance of IGS_CA_INST
33: -- other than planned
34: OPEN c_cal_instance_rec(p_cal_type);
35: FETCH c_cal_instance_rec INTO v_check;
36: IF (c_cal_instance_rec%NOTFOUND) THEN