APPS.IGS_CA_GEN_001 dependencies on IGS_CA_TYPE

Line 86: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;

82: FUNCTION calp_get_cat_closed(
83: p_cal_type IN VARCHAR2 ,
84: p_message_name OUT NOCOPY VARCHAR2 )
85: RETURN boolean AS
86: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
87: CURSOR c_cal_type IS
88: SELECT closed_ind
89: FROM IGS_CA_TYPE
90: WHERE CAL_TYPE = p_cal_type;

Line 89: FROM IGS_CA_TYPE

85: RETURN boolean AS
86: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
87: CURSOR c_cal_type IS
88: SELECT closed_ind
89: FROM IGS_CA_TYPE
90: WHERE CAL_TYPE = p_cal_type;
91: v_other_detail VARCHAR2(255);
92: BEGIN
93: p_message_name := null;

Line 351: v_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;

347: p_message_name OUT NOCOPY varchar2 )
348: RETURN VARCHAR2 AS
349: cst_teaching_period CONSTANT VARCHAR2(15) := 'TEACHING';
350: cst_academic_period CONSTANT VARCHAR2(15) := 'ACADEMIC';
351: v_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;
352: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
353: v_other_detail VARCHAR2(255);
354: CURSOR c_cal_type IS
355: SELECT S_CAL_CAT

Line 356: FROM IGS_CA_TYPE

352: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
353: v_other_detail VARCHAR2(255);
354: CURSOR c_cal_type IS
355: SELECT S_CAL_CAT
356: FROM IGS_CA_TYPE
357: WHERE CAL_TYPE = p_cal_type;
358: BEGIN
359: OPEN c_cal_type;
360: LOOP