DBA Data[Home] [Help]

APPS.IGS_EN_GEN_011 dependencies on IGS_PS_VER

Line 364: FROM IGS_PS_VER cv,

360: v_coo_rec c_coo%ROWTYPE;
361: CURSOR c_cv IS
362: SELECT cs.s_course_status,
363: cv.expiry_dt
364: FROM IGS_PS_VER cv,
365: IGS_PS_STAT cs
366: WHERE cv.course_cd = p_course_cd AND
367: cv.version_number = p_to_crs_version_number AND
368: cs.COURSE_STATUS = cv.COURSE_STATUS;

Line 2925: p_course_cd IGS_PS_VER.course_cd%TYPE,

2921: l_dummy VARCHAR2(200);
2922:
2923: PROCEDURE enrpl_upd_sua_uoo(
2924: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2925: p_course_cd IGS_PS_VER.course_cd%TYPE,
2926: p_version_number IGS_PS_UNIT_VER.version_number%TYPE, --program version
2927: p_u_version_number IGS_PS_UNIT_VER.version_number%TYPE, --unit version
2928: p_from_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
2929: p_teach_end_dt IGS_CA_INST.end_dt%TYPE,