APPS.IGS_EN_GEN_LEGACY dependencies on IGS_PS_VER

Line 850: p_course_cd IN igs_ps_ver.course_cd%TYPE,

846: END get_sca_dropped_by;
847:
848:
849: FUNCTION get_sca_prog_type(
850: p_course_cd IN igs_ps_ver.course_cd%TYPE,
851: p_version_number IN igs_ps_ver.version_number%TYPE)
852: RETURN igs_ps_ver.course_type%TYPE AS
853: /*----------------------------------------------------------------------------
854: || Created By : kkillams

Line 851: p_version_number IN igs_ps_ver.version_number%TYPE)

847:
848:
849: FUNCTION get_sca_prog_type(
850: p_course_cd IN igs_ps_ver.course_cd%TYPE,
851: p_version_number IN igs_ps_ver.version_number%TYPE)
852: RETURN igs_ps_ver.course_type%TYPE AS
853: /*----------------------------------------------------------------------------
854: || Created By : kkillams
855: || Created On : 08-11-2002

Line 852: RETURN igs_ps_ver.course_type%TYPE AS

848:
849: FUNCTION get_sca_prog_type(
850: p_course_cd IN igs_ps_ver.course_cd%TYPE,
851: p_version_number IN igs_ps_ver.version_number%TYPE)
852: RETURN igs_ps_ver.course_type%TYPE AS
853: /*----------------------------------------------------------------------------
854: || Created By : kkillams
855: || Created On : 08-11-2002
856: || Purpose : Derives the program type for the given program code and version number.

Line 861: CURSOR cur_cour_typ IS SELECT course_type FROM IGS_PS_VER

857: || Known limitations, enhancements or remarks :
858: || Change History :
859: || Who When What
860: ------------------------------------------------------------------------------*/
861: CURSOR cur_cour_typ IS SELECT course_type FROM IGS_PS_VER
862: WHERE course_cd = p_course_cd
863: AND version_number = p_version_number;
864: l_course_type igs_ps_ver.course_type%TYPE;
865: BEGIN

Line 864: l_course_type igs_ps_ver.course_type%TYPE;

860: ------------------------------------------------------------------------------*/
861: CURSOR cur_cour_typ IS SELECT course_type FROM IGS_PS_VER
862: WHERE course_cd = p_course_cd
863: AND version_number = p_version_number;
864: l_course_type igs_ps_ver.course_type%TYPE;
865: BEGIN
866: --Return null if any of input parameters is null.
867: IF p_course_cd IS NULL OR
868: p_version_number IS NULL THEN

Line 1063: igs_ps_ver crv

1059: || Change History :
1060: || Who When What
1061: ------------------------------------------------------------------------------*/
1062: CURSOR cur_count IS SELECT count(primary_program_type) FROM igs_en_stdnt_ps_att sca,
1063: igs_ps_ver crv
1064: WHERE crv.course_type = p_course_type
1065: AND sca.course_cd = crv.course_cd
1066: AND sca.version_number = crv.version_number
1067: AND sca.person_id = p_person_id