APPS.IGS_PR_VAL_PRA dependencies on IGS_PS_VER

Line 217: p_course_cd IN IGS_PS_VER_ALL.course_cd%TYPE ,

213: END prgp_val_prr_closed;
214: --
215: -- Validate the IGS_PS_COURSE version is active.
216: FUNCTION crsp_val_crv_active(
217: p_course_cd IN IGS_PS_VER_ALL.course_cd%TYPE ,
218: p_version_number IN IGS_PS_VER_ALL.version_number%TYPE ,
219: p_message_name OUT NOCOPY VARCHAR2)
220: RETURN BOOLEAN AS
221: gv_other_detail VARCHAR2(255);

Line 218: p_version_number IN IGS_PS_VER_ALL.version_number%TYPE ,

214: --
215: -- Validate the IGS_PS_COURSE version is active.
216: FUNCTION crsp_val_crv_active(
217: p_course_cd IN IGS_PS_VER_ALL.course_cd%TYPE ,
218: p_version_number IN IGS_PS_VER_ALL.version_number%TYPE ,
219: p_message_name OUT NOCOPY VARCHAR2)
220: RETURN BOOLEAN AS
221: gv_other_detail VARCHAR2(255);
222: BEGIN -- crsp_val_crv_active

Line 223: -- Validate the IGS_PS_VER is ACTIVE

219: p_message_name OUT NOCOPY VARCHAR2)
220: RETURN BOOLEAN AS
221: gv_other_detail VARCHAR2(255);
222: BEGIN -- crsp_val_crv_active
223: -- Validate the IGS_PS_VER is ACTIVE
224: DECLARE
225: cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE := 'ACTIVE';
226: v_dummy VARCHAR2(1);
227: CURSOR c_crv_crst IS

Line 229: FROM IGS_PS_VER cst,

225: cst_active CONSTANT IGS_PS_STAT.s_course_status%TYPE := 'ACTIVE';
226: v_dummy VARCHAR2(1);
227: CURSOR c_crv_crst IS
228: SELECT 'X'
229: FROM IGS_PS_VER cst,
230: IGS_PS_STAT crst
231: WHERE cst.course_cd = p_course_cd AND
232: cst.version_number = p_version_number AND
233: cst.course_status = crst.course_status AND