APPS.IGS_PS_GEN_007 dependencies on IGS_PS_STAT

Line 60: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;

56: p_percentage IN NUMBER )
57: --who when what
58: --sarakshi 12-Apr-2006 Bug#3655441, modified procedure crsp_ins_cow_hist to include PLANNED status also
59: AS
60: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
61: CURSOR c_get_course_status IS
62: SELECT s_course_status
63: FROM IGS_PS_STAT, IGS_PS_VER
64: WHERE IGS_PS_VER.course_cd = p_course_cd AND

Line 63: FROM IGS_PS_STAT, IGS_PS_VER

59: AS
60: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
61: CURSOR c_get_course_status IS
62: SELECT s_course_status
63: FROM IGS_PS_STAT, IGS_PS_VER
64: WHERE IGS_PS_VER.course_cd = p_course_cd AND
65: IGS_PS_VER.version_number = p_version_number AND
66: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;
67:

Line 66: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;

62: SELECT s_course_status
63: FROM IGS_PS_STAT, IGS_PS_VER
64: WHERE IGS_PS_VER.course_cd = p_course_cd AND
65: IGS_PS_VER.version_number = p_version_number AND
66: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;
67:
68: x_rowid Varchar2(25);
69: l_org_id NUMBER(15);
70: BEGIN

Line 114: SELECT IGS_PS_STAT.s_course_status

110: AS
111: CURSOR c_course_status(
112: cp_course_cd IGS_PS_VER.course_cd%TYPE,
113: cp_version_number IGS_PS_VER.version_number%TYPE) IS
114: SELECT IGS_PS_STAT.s_course_status
115: FROM IGS_PS_STAT,IGS_PS_VER
116: WHERE IGS_PS_VER.course_cd = cp_course_cd AND
117: IGS_PS_VER.version_number = cp_version_number AND
118: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;

Line 115: FROM IGS_PS_STAT,IGS_PS_VER

111: CURSOR c_course_status(
112: cp_course_cd IGS_PS_VER.course_cd%TYPE,
113: cp_version_number IGS_PS_VER.version_number%TYPE) IS
114: SELECT IGS_PS_STAT.s_course_status
115: FROM IGS_PS_STAT,IGS_PS_VER
116: WHERE IGS_PS_VER.course_cd = cp_course_cd AND
117: IGS_PS_VER.version_number = cp_version_number AND
118: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;
119: v_course_status IGS_PS_STAT.s_course_status%TYPE;

Line 118: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;

114: SELECT IGS_PS_STAT.s_course_status
115: FROM IGS_PS_STAT,IGS_PS_VER
116: WHERE IGS_PS_VER.course_cd = cp_course_cd AND
117: IGS_PS_VER.version_number = cp_version_number AND
118: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;
119: v_course_status IGS_PS_STAT.s_course_status%TYPE;
120: x_rowid VARCHAR2(25);
121: l_org_id NUMBER(15);
122: BEGIN

Line 119: v_course_status IGS_PS_STAT.s_course_status%TYPE;

115: FROM IGS_PS_STAT,IGS_PS_VER
116: WHERE IGS_PS_VER.course_cd = cp_course_cd AND
117: IGS_PS_VER.version_number = cp_version_number AND
118: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;
119: v_course_status IGS_PS_STAT.s_course_status%TYPE;
120: x_rowid VARCHAR2(25);
121: l_org_id NUMBER(15);
122: BEGIN
123: OPEN c_course_status(