APPS.IGS_PS_GEN_002 dependencies on IGS_PS_STAT

Line 30: cst_active CONSTANT igs_ps_stat.s_course_status%TYPE := 'ACTIVE';

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';
32:
33: v_title igs_ps_ver.title%TYPE;
34:

Line 31: cst_planned CONSTANT igs_ps_stat.s_course_status%TYPE := 'PLANNED';

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';
32:
33: v_title igs_ps_ver.title%TYPE;
34:
35: CURSOR c_crv_crst IS

Line 38: igs_ps_stat crst

34:
35: CURSOR c_crv_crst IS
36: SELECT crv.title
37: FROM igs_ps_ver crv,
38: igs_ps_stat crst
39: WHERE crv.course_cd = p_course_cd AND
40: crst.course_status = crv.course_status
41: ORDER BY decode( crst.s_course_status,
42: cst_active, 1,

Line 278: v_s_course_status igs_ps_stat.s_course_status%TYPE;

274: p_last_update_who IN VARCHAR2 ,
275: p_percentage IN NUMBER ,
276: p_major_field_ind IN VARCHAR2)
277: AS
278: v_s_course_status igs_ps_stat.s_course_status%TYPE;
279: x_rowid VARCHAR2(25);
280: l_org_id NUMBER(15);
281:
282: CURSOR c_get_course_status IS

Line 284: FROM igs_ps_stat, igs_ps_ver

280: l_org_id NUMBER(15);
281:
282: CURSOR c_get_course_status IS
283: SELECT s_course_status
284: FROM igs_ps_stat, igs_ps_ver
285: WHERE igs_ps_ver.course_cd = p_course_cd AND
286: igs_ps_ver.version_number = p_version_number AND
287: igs_ps_stat.course_status = igs_ps_ver.course_status;
288: BEGIN

Line 287: igs_ps_stat.course_status = igs_ps_ver.course_status;

283: SELECT s_course_status
284: FROM igs_ps_stat, igs_ps_ver
285: WHERE igs_ps_ver.course_cd = p_course_cd AND
286: igs_ps_ver.version_number = p_version_number AND
287: igs_ps_stat.course_status = igs_ps_ver.course_status;
288: BEGIN
289: OPEN c_get_course_status;
290: FETCH c_get_course_status INTO v_s_course_status;
291: CLOSE c_get_course_status;