eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_STAT

Line 163: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;

159: p_end_dt IN DATE ,
160: p_course_status IN VARCHAR2 ,
161: p_message_name OUT NOCOPY VARCHAR2 )
162: RETURN BOOLEAN AS
163: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
164: CURSOR c_get_s_course_status IS
165: SELECT s_course_status
166: FROM IGS_PS_STAT
167: WHERE course_status = p_course_status;

Line 166: FROM IGS_PS_STAT

162: RETURN BOOLEAN AS
163: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
164: CURSOR c_get_s_course_status IS
165: SELECT s_course_status
166: FROM IGS_PS_STAT
167: WHERE course_status = p_course_status;
168: BEGIN
169: p_message_name := NULL;
170: OPEN c_get_s_course_status;

Line 209: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;

205: p_expiry_dt IN DATE ,
206: p_course_status IN VARCHAR2 ,
207: p_message_name OUT NOCOPY VARCHAR2 )
208: RETURN BOOLEAN AS
209: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
210: v_check CHAR;
211: CURSOR c_get_s_course_status IS
212: SELECT s_course_status
213: FROM IGS_PS_STAT

Line 213: FROM IGS_PS_STAT

209: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
210: v_check CHAR;
211: CURSOR c_get_s_course_status IS
212: SELECT s_course_status
213: FROM IGS_PS_STAT
214: WHERE course_status = p_course_status;
215: CURSOR c_check_cv_cs IS
216: SELECT 'x'
217: FROM IGS_PS_VER cv,

Line 218: IGS_PS_STAT cs

214: WHERE course_status = p_course_status;
215: CURSOR c_check_cv_cs IS
216: SELECT 'x'
217: FROM IGS_PS_VER cv,
218: IGS_PS_STAT cs
219: WHERE
220: course_cd = p_course_cd AND
221: version_number <> p_version_number AND
222: expiry_dt IS NULL AND

Line 260: v_s_course_status_new IGS_PS_STAT.s_course_status%TYPE;

256: p_new_course_status IN VARCHAR2 ,
257: p_old_course_status IN VARCHAR2 ,
258: p_message_name OUT NOCOPY VARCHAR2 )
259: RETURN BOOLEAN AS
260: v_s_course_status_new IGS_PS_STAT.s_course_status%TYPE;
261: v_s_course_status_old IGS_PS_STAT.s_course_status%TYPE;
262: v_closed_ind IGS_PS_STAT.closed_ind%TYPE;
263: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
264: CURSOR c_course_status (cp_course_status IGS_PS_STAT.course_status%TYPE) IS

Line 261: v_s_course_status_old IGS_PS_STAT.s_course_status%TYPE;

257: p_old_course_status IN VARCHAR2 ,
258: p_message_name OUT NOCOPY VARCHAR2 )
259: RETURN BOOLEAN AS
260: v_s_course_status_new IGS_PS_STAT.s_course_status%TYPE;
261: v_s_course_status_old IGS_PS_STAT.s_course_status%TYPE;
262: v_closed_ind IGS_PS_STAT.closed_ind%TYPE;
263: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
264: CURSOR c_course_status (cp_course_status IGS_PS_STAT.course_status%TYPE) IS
265: SELECT closed_ind,

Line 262: v_closed_ind IGS_PS_STAT.closed_ind%TYPE;

258: p_message_name OUT NOCOPY VARCHAR2 )
259: RETURN BOOLEAN AS
260: v_s_course_status_new IGS_PS_STAT.s_course_status%TYPE;
261: v_s_course_status_old IGS_PS_STAT.s_course_status%TYPE;
262: v_closed_ind IGS_PS_STAT.closed_ind%TYPE;
263: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
264: CURSOR c_course_status (cp_course_status IGS_PS_STAT.course_status%TYPE) IS
265: SELECT closed_ind,
266: s_course_status

Line 264: CURSOR c_course_status (cp_course_status IGS_PS_STAT.course_status%TYPE) IS

260: v_s_course_status_new IGS_PS_STAT.s_course_status%TYPE;
261: v_s_course_status_old IGS_PS_STAT.s_course_status%TYPE;
262: v_closed_ind IGS_PS_STAT.closed_ind%TYPE;
263: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
264: CURSOR c_course_status (cp_course_status IGS_PS_STAT.course_status%TYPE) IS
265: SELECT closed_ind,
266: s_course_status
267: FROM IGS_PS_STAT
268: WHERE course_status = cp_course_status;

Line 267: FROM IGS_PS_STAT

263: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
264: CURSOR c_course_status (cp_course_status IGS_PS_STAT.course_status%TYPE) IS
265: SELECT closed_ind,
266: s_course_status
267: FROM IGS_PS_STAT
268: WHERE course_status = cp_course_status;
269: BEGIN
270: -- Validating the closed indicator
271: OPEN c_course_status(p_new_course_status);

Line 279: -- Validating whether IGS_PS_VER.IGS_PS_STAT isn't being changed

275: CLOSE c_course_status;
276: RETURN FALSE;
277: END IF;
278: CLOSE c_course_status;
279: -- Validating whether IGS_PS_VER.IGS_PS_STAT isn't being changed
280: -- from 'ACTIVE' or 'INACTIVE' to 'PLANNED'. This is only checked when
281: -- IGS_PS_VER.IGS_PS_STAT
282: -- is being updated.
283: IF (p_old_course_status IS NOT NULL) AND

Line 281: -- IGS_PS_VER.IGS_PS_STAT

277: END IF;
278: CLOSE c_course_status;
279: -- Validating whether IGS_PS_VER.IGS_PS_STAT isn't being changed
280: -- from 'ACTIVE' or 'INACTIVE' to 'PLANNED'. This is only checked when
281: -- IGS_PS_VER.IGS_PS_STAT
282: -- is being updated.
283: IF (p_old_course_status IS NOT NULL) AND
284: (p_new_course_status <> p_old_course_status) THEN
285: OPEN c_course_status(p_old_course_status);

Line 337: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;

333: v_funding_source IGS_FI_FND_SRC_RSTN.funding_source%TYPE;
334: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
335: v_field_of_study IGS_PS_FIELD_STUDY.field_of_study%TYPE;
336: v_course_cat IGS_PS_CATEGORISE.course_cat%TYPE;
337: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
338: v_terminate BOOLEAN := FALSE;
339: v_coo_exist BOOLEAN := FALSE;
340: CURSOR c_course_version IS
341: SELECT *

Line 407: FROM IGS_PS_STAT

403: WHERE course_cd = p_course_cd AND
404: version_number = p_version_number;
405: CURSOR c_get_s_course_status IS
406: SELECT s_course_status
407: FROM IGS_PS_STAT
408: WHERE course_status = p_old_course_status;
409: CURSOR c_course_offering_instance IS
410: SELECT cal_type, ci_sequence_number
411: FROM IGS_PS_OFR_INST

Line 589: -- no IGS_PS_STAT found

585: RETURN FALSE;
586: END IF;
587: OPEN c_get_s_course_status;
588: FETCH c_get_s_course_status INTO v_s_course_status;
589: -- no IGS_PS_STAT found
590: IF (c_get_s_course_status%NOTFOUND) THEN
591: CLOSE c_get_s_course_status;
592: p_message_name := 'IGS_GE_VAL_DOES_NOT_XS';
593: RETURN FALSE;