APPS.IGS_PS_VAL_CO dependencies on IGS_CA_TYPE

Line 11: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;

7: p_cal_type IN VARCHAR2 ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN AS
10: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
11: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
12: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
13: CURSOR c_cal_type(
14: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)IS
15: SELECT closed_ind,s_cal_cat

Line 12: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN AS
10: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
11: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
12: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
13: CURSOR c_cal_type(
14: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)IS
15: SELECT closed_ind,s_cal_cat
16: FROM IGS_CA_TYPE

Line 14: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)IS

10: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
11: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
12: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
13: CURSOR c_cal_type(
14: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)IS
15: SELECT closed_ind,s_cal_cat
16: FROM IGS_CA_TYPE
17: WHERE cal_type = cp_cal_type;
18: BEGIN

Line 16: FROM IGS_CA_TYPE

12: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
13: CURSOR c_cal_type(
14: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)IS
15: SELECT closed_ind,s_cal_cat
16: FROM IGS_CA_TYPE
17: WHERE cal_type = cp_cal_type;
18: BEGIN
19: p_message_name := NULL;
20: OPEN c_cal_type(