APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_AWARD

Line 64: v_course_award_rec IGS_PS_AWARD%ROWTYPE;

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
68: FROM IGS_PS_TYPE

Line 72: FROM IGS_PS_AWARD

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
73: WHERE course_cd = p_course_cd AND
74: version_number = p_version_number AND
75: CLOSED_IND = 'N';
76: BEGIN

Line 332: v_award_cd IGS_PS_AWARD.award_cd%TYPE;

328: skpandey 10-Jul-2006 Bug#5343912,removed the validation of 100% Field of study as this was used as check for updating status to active.
329: ***************************************************************/
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;

Line 352: FROM IGS_PS_AWARD

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
353: WHERE course_cd = p_course_cd AND
354: version_number = p_version_number AND
355: CLOSED_IND = 'N';
356: CURSOR c_get_funding_source IS

Line 500: -- IGS_PS_AWARD table for p_course_cd and p_version_number

496: CLOSE c_get_award_cd;
497: RETURN FALSE;
498: END IF;
499: -- IGS_PS_VER is an IGS_PS_AWD IGS_PS_COURSE and no record exist in the
500: -- IGS_PS_AWARD table for p_course_cd and p_version_number
501: IF (c_get_award_cd%ROWCOUNT = 0) THEN
502: CLOSE c_get_award_cd;
503: p_message_name := 'IGS_PS_PRGVER_AWARDPRG';
504: RETURN FALSE;