APPS.IGS_AS_VAL_ACOT dependencies on IGS_PS_TYPE

Line 6: p_course_type IN IGS_PS_TYPE_ALL.course_type%TYPE ,

2: /* $Header: IGSAS10B.pls 115.4 2002/11/28 22:41:43 nsidana ship $ */
3: -----
4: -- Validate COURSE type closed indicator.
5: FUNCTION crsp_val_cty_closed(
6: p_course_type IN IGS_PS_TYPE_ALL.course_type%TYPE ,
7: P_MESSAGE_NAME OUT NOCOPY varchar2 )
8: RETURN BOOLEAN AS
9: V_MESSAGE_NAME VARCHAR2(30);
10: BEGIN -- crsp_val_cty_closed

Line 15: cp_course_type IGS_PS_TYPE.course_type%TYPE) IS

11: -- Validate the COURSE type closed indicator
12: DECLARE
13:
14: CURSOR c_cty(
15: cp_course_type IGS_PS_TYPE.course_type%TYPE) IS
16: SELECT closed_ind
17: FROM IGS_PS_TYPE
18: WHERE course_type = cp_course_type;
19: v_cty_rec c_cty%ROWTYPE;

Line 17: FROM IGS_PS_TYPE

13:
14: CURSOR c_cty(
15: cp_course_type IGS_PS_TYPE.course_type%TYPE) IS
16: SELECT closed_ind
17: FROM IGS_PS_TYPE
18: WHERE course_type = cp_course_type;
19: v_cty_rec c_cty%ROWTYPE;
20: cst_yes CONSTANT CHAR := 'Y';
21: BEGIN