APPS.IGS_PS_GEN_002 dependencies on IGS_PS_VER

Line 33: v_title igs_ps_ver.title%TYPE;

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
36: SELECT crv.title
37: FROM igs_ps_ver crv,

Line 37: FROM igs_ps_ver crv,

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

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 285: WHERE igs_ps_ver.course_cd = p_course_cd AND

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
289: OPEN c_get_course_status;

Line 286: igs_ps_ver.version_number = p_version_number AND

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
289: OPEN c_get_course_status;
290: FETCH c_get_course_status INTO v_s_course_status;

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;

Line 417: igs_ps_ver_hist_pkg.insert_row(

413: CLOSE c_find_gsct_desc;
414: END IF;
415: l_org_id := igs_ge_gen_003.get_org_id;
416:
417: igs_ps_ver_hist_pkg.insert_row(
418: x_rowid => x_rowid,
419: x_course_cd => p_course_cd,
420: x_version_number => p_version_number,
421: x_hist_start_dt => p_last_update_on,