APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_TYPE

Line 62: v_closed_ind IGS_PS_TYPE.closed_ind%TYPE;

58: Who When What
59: smvk 03-Jun-2003 Bug # 2858436. Modified the cursor c_course_award_rec to select open program awards only.
60: ***************************************************************/
61:
62: v_closed_ind IGS_PS_TYPE.closed_ind%TYPE;
63: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
64: v_course_award_rec IGS_PS_AWARD%ROWTYPE;
65: CURSOR c_course_type IS
66: SELECT closed_ind,

Line 63: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;

59: smvk 03-Jun-2003 Bug # 2858436. Modified the cursor c_course_award_rec to select open program awards only.
60: ***************************************************************/
61:
62: v_closed_ind IGS_PS_TYPE.closed_ind%TYPE;
63: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
64: v_course_award_rec IGS_PS_AWARD%ROWTYPE;
65: CURSOR c_course_type IS
66: SELECT closed_ind,
67: award_course_ind

Line 68: FROM IGS_PS_TYPE

64: v_course_award_rec IGS_PS_AWARD%ROWTYPE;
65: CURSOR c_course_type IS
66: SELECT closed_ind,
67: award_course_ind
68: FROM IGS_PS_TYPE
69: WHERE course_type = p_course_type;
70: CURSOR c_course_award_rec IS
71: SELECT *
72: FROM IGS_PS_AWARD

Line 77: -- validating the IGS_PS_VER.IGS_PS_TYPE

73: WHERE course_cd = p_course_cd AND
74: version_number = p_version_number AND
75: CLOSED_IND = 'N';
76: BEGIN
77: -- validating the IGS_PS_VER.IGS_PS_TYPE
78: OPEN c_course_type;
79: FETCH c_course_type INTO v_closed_ind, v_award_course_ind;
80: IF c_course_type%NOTFOUND THEN
81: p_message_name := NULL;

Line 334: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;

330:
331: v_cv_rec IGS_PS_VER%ROWTYPE;
332: v_award_cd IGS_PS_AWARD.award_cd%TYPE;
333: v_funding_source IGS_FI_FND_SRC_RSTN.funding_source%TYPE;
334: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
335: v_field_of_study IGS_PS_FIELD_STUDY.field_of_study%TYPE;
336: v_course_cat IGS_PS_CATEGORISE.course_cat%TYPE;
337: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
338: v_terminate BOOLEAN := FALSE;

Line 348: FROM IGS_PS_TYPE

344: version_number = p_version_number;
345: CURSOR c_get_award_course_ind (
346: cp_course_type IGS_PS_VER.course_type%TYPE) IS
347: SELECT award_course_ind
348: FROM IGS_PS_TYPE
349: WHERE course_type = cp_course_type;
350: CURSOR c_get_award_cd IS
351: SELECT award_cd
352: FROM IGS_PS_AWARD

Line 445: -- Validate the IGS_PS_TYPE is not closed

441: v_cv_rec.govt_special_course_type,
442: p_message_name) = FALSE) THEN
443: RETURN FALSE;
444: END IF;
445: -- Validate the IGS_PS_TYPE is not closed
446: IF (IGS_PS_VAL_CRV.crsp_val_crv_type(
447: p_course_cd,
448: p_version_number,
449: v_cv_rec.course_type,