APPS.IGS_PS_GEN_002 dependencies on IGS_PS_COURSE

Line 23: p_course_cd IN igs_ps_course.course_cd%TYPE )

19:
20: */
21:
22: FUNCTION crsp_get_course_ttl(
23: p_course_cd IN igs_ps_course.course_cd%TYPE )
24: RETURN VARCHAR2 AS
25: BEGIN -- crsp_get_course_ttl
26: -- This module returns the IGS_PS_COURSE version IGS_PE_TITLE for a IGS_PS_COURSE code.
27: -- If no IGS_PS_COURSE version is found then NULL is returned.

Line 26: -- This module returns the IGS_PS_COURSE version IGS_PE_TITLE for a IGS_PS_COURSE code.

22: FUNCTION crsp_get_course_ttl(
23: p_course_cd IN igs_ps_course.course_cd%TYPE )
24: RETURN VARCHAR2 AS
25: BEGIN -- crsp_get_course_ttl
26: -- This module returns the IGS_PS_COURSE version IGS_PE_TITLE for a IGS_PS_COURSE code.
27: -- If no IGS_PS_COURSE version is found then NULL is returned.
28: DECLARE
29:
30: cst_active CONSTANT igs_ps_stat.s_course_status%TYPE := 'ACTIVE';

Line 27: -- If no IGS_PS_COURSE version is found then NULL is returned.

23: p_course_cd IN igs_ps_course.course_cd%TYPE )
24: RETURN VARCHAR2 AS
25: BEGIN -- crsp_get_course_ttl
26: -- This module returns the IGS_PS_COURSE version IGS_PE_TITLE for a IGS_PS_COURSE code.
27: -- If no IGS_PS_COURSE version is found then NULL is returned.
28: DECLARE
29:
30: cst_active CONSTANT igs_ps_stat.s_course_status%TYPE := 'ACTIVE';
31: cst_planned CONSTANT igs_ps_stat.s_course_status%TYPE := 'PLANNED';

Line 239: -- Get the IGS_PS_UNIT level of a IGS_PS_UNIT attempt within a nominated IGS_PS_COURSE.

235: FROM igs_ps_unit_ver uv
236: WHERE uv.unit_cd = p_unit_cd AND
237: uv.version_number = p_unit_version_number;
238: BEGIN
239: -- Get the IGS_PS_UNIT level of a IGS_PS_UNIT attempt within a nominated IGS_PS_COURSE.
240: -- Searches for the existence of a IGS_PS_UNIT_LVL record using the
241: -- IGS_PS_UNIT.level
242: -- 1. Search for a IGS_PS_UNIT_LVL record matching the IGS_PS_UNIT version and the
243: -- IGS_PS_COURSE type of the nominated IGS_PS_COURSE.

Line 243: -- IGS_PS_COURSE type of the nominated IGS_PS_COURSE.

239: -- Get the IGS_PS_UNIT level of a IGS_PS_UNIT attempt within a nominated IGS_PS_COURSE.
240: -- Searches for the existence of a IGS_PS_UNIT_LVL record using the
241: -- IGS_PS_UNIT.level
242: -- 1. Search for a IGS_PS_UNIT_LVL record matching the IGS_PS_UNIT version and the
243: -- IGS_PS_COURSE type of the nominated IGS_PS_COURSE.
244: OPEN c_cul_crv;
245: FETCH c_cul_crv INTO v_unit_level;
246: IF (c_cul_crv%FOUND) THEN
247: CLOSE c_cul_crv;