APPS.IGS_PS_VAL_CTY dependencies on IGS_PS_TYPE

Line 10: v_closed_ind IGS_PS_TYPE.closed_ind%TYPE;

6: FUNCTION crsp_val_cty_govt(
7: p_govt_course_type IN NUMBER ,
8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN AS
10: v_closed_ind IGS_PS_TYPE.closed_ind%TYPE;
11: CURSOR c_govt_course_type IS
12: SELECT closed_ind
13: FROM IGS_PS_GOVT_TYPE
14: WHERE govt_course_type = p_govt_course_type;

Line 44: v_closed_ind IGS_PS_TYPE_GRP.closed_ind%TYPE;

40: FUNCTION crsp_val_cty_group(
41: p_course_type_group_cd IN VARCHAR2 ,
42: p_message_name OUT NOCOPY VARCHAR2 )
43: RETURN BOOLEAN AS
44: v_closed_ind IGS_PS_TYPE_GRP.closed_ind%TYPE;
45: CURSOR c_course_type_group IS
46: SELECT closed_ind
47: FROM IGS_PS_TYPE_GRP
48: WHERE course_type_group_cd = p_course_type_group_cd;

Line 47: FROM IGS_PS_TYPE_GRP

43: RETURN BOOLEAN AS
44: v_closed_ind IGS_PS_TYPE_GRP.closed_ind%TYPE;
45: CURSOR c_course_type_group IS
46: SELECT closed_ind
47: FROM IGS_PS_TYPE_GRP
48: WHERE course_type_group_cd = p_course_type_group_cd;
49: BEGIN
50: OPEN c_course_type_group;
51: FETCH c_course_type_group INTO v_closed_ind;

Line 103: -- IGS_PS_VER that have current IGS_PS_TYPE

99: IF (p_award_course_ind = 'N') THEN
100: OPEN c_sel_course_award;
101: FETCH c_sel_course_award INTO v_check;
102: -- no IGS_PS_AWARD record should exist for
103: -- IGS_PS_VER that have current IGS_PS_TYPE
104: IF c_sel_course_award%FOUND THEN
105: CLOSE c_sel_course_award;
106: p_message_name := 'IGS_PS_AWARD_PRG_NOTSET_N';
107: RETURN FALSE;