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_POS dependencies on IGS_PS_PAT_OF_STUDY

Line 250: p_course_cd IN IGS_PS_PAT_OF_STUDY.course_cd%TYPE ,

246: END crsp_val_pos_cous;
247: --
248: -- Validate pattern of study record is not ambiguous.
249: FUNCTION crsp_val_pos_iu(
250: p_course_cd IN IGS_PS_PAT_OF_STUDY.course_cd%TYPE ,
251: p_version_number IN IGS_PS_PAT_OF_STUDY.version_number%TYPE ,
252: p_cal_type IN IGS_PS_PAT_OF_STUDY.cal_type%TYPE ,
253: p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,
254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,

Line 251: p_version_number IN IGS_PS_PAT_OF_STUDY.version_number%TYPE ,

247: --
248: -- Validate pattern of study record is not ambiguous.
249: FUNCTION crsp_val_pos_iu(
250: p_course_cd IN IGS_PS_PAT_OF_STUDY.course_cd%TYPE ,
251: p_version_number IN IGS_PS_PAT_OF_STUDY.version_number%TYPE ,
252: p_cal_type IN IGS_PS_PAT_OF_STUDY.cal_type%TYPE ,
253: p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,
254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,
255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,

Line 252: p_cal_type IN IGS_PS_PAT_OF_STUDY.cal_type%TYPE ,

248: -- Validate pattern of study record is not ambiguous.
249: FUNCTION crsp_val_pos_iu(
250: p_course_cd IN IGS_PS_PAT_OF_STUDY.course_cd%TYPE ,
251: p_version_number IN IGS_PS_PAT_OF_STUDY.version_number%TYPE ,
252: p_cal_type IN IGS_PS_PAT_OF_STUDY.cal_type%TYPE ,
253: p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,
254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,
255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,
256: p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,

Line 253: p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,

249: FUNCTION crsp_val_pos_iu(
250: p_course_cd IN IGS_PS_PAT_OF_STUDY.course_cd%TYPE ,
251: p_version_number IN IGS_PS_PAT_OF_STUDY.version_number%TYPE ,
252: p_cal_type IN IGS_PS_PAT_OF_STUDY.cal_type%TYPE ,
253: p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,
254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,
255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,
256: p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,
257: p_unit_set_cd IN IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE ,

Line 254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,

250: p_course_cd IN IGS_PS_PAT_OF_STUDY.course_cd%TYPE ,
251: p_version_number IN IGS_PS_PAT_OF_STUDY.version_number%TYPE ,
252: p_cal_type IN IGS_PS_PAT_OF_STUDY.cal_type%TYPE ,
253: p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,
254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,
255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,
256: p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,
257: p_unit_set_cd IN IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE ,
258: p_admission_cal_type IN IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE ,

Line 255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,

251: p_version_number IN IGS_PS_PAT_OF_STUDY.version_number%TYPE ,
252: p_cal_type IN IGS_PS_PAT_OF_STUDY.cal_type%TYPE ,
253: p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,
254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,
255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,
256: p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,
257: p_unit_set_cd IN IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE ,
258: p_admission_cal_type IN IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE ,
259: p_admission_cat IN IGS_PS_PAT_OF_STUDY.admission_cat%TYPE ,

Line 256: p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,

252: p_cal_type IN IGS_PS_PAT_OF_STUDY.cal_type%TYPE ,
253: p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,
254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,
255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,
256: p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,
257: p_unit_set_cd IN IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE ,
258: p_admission_cal_type IN IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE ,
259: p_admission_cat IN IGS_PS_PAT_OF_STUDY.admission_cat%TYPE ,
260: p_message_name OUT NOCOPY VARCHAR2 )

Line 257: p_unit_set_cd IN IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE ,

253: p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,
254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,
255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,
256: p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,
257: p_unit_set_cd IN IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE ,
258: p_admission_cal_type IN IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE ,
259: p_admission_cat IN IGS_PS_PAT_OF_STUDY.admission_cat%TYPE ,
260: p_message_name OUT NOCOPY VARCHAR2 )
261: RETURN BOOLEAN AS

Line 258: p_admission_cal_type IN IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE ,

254: p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,
255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,
256: p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,
257: p_unit_set_cd IN IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE ,
258: p_admission_cal_type IN IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE ,
259: p_admission_cat IN IGS_PS_PAT_OF_STUDY.admission_cat%TYPE ,
260: p_message_name OUT NOCOPY VARCHAR2 )
261: RETURN BOOLEAN AS
262: BEGIN -- crsp_val_pos_iu

Line 259: p_admission_cat IN IGS_PS_PAT_OF_STUDY.admission_cat%TYPE ,

255: p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,
256: p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,
257: p_unit_set_cd IN IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE ,
258: p_admission_cal_type IN IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE ,
259: p_admission_cat IN IGS_PS_PAT_OF_STUDY.admission_cat%TYPE ,
260: p_message_name OUT NOCOPY VARCHAR2 )
261: RETURN BOOLEAN AS
262: BEGIN -- crsp_val_pos_iu
263: -- Validate IGS_PS_PAT_OF_STUDY records are unique for the IGS_PS_OFR

Line 263: -- Validate IGS_PS_PAT_OF_STUDY records are unique for the IGS_PS_OFR

259: p_admission_cat IN IGS_PS_PAT_OF_STUDY.admission_cat%TYPE ,
260: p_message_name OUT NOCOPY VARCHAR2 )
261: RETURN BOOLEAN AS
262: BEGIN -- crsp_val_pos_iu
263: -- Validate IGS_PS_PAT_OF_STUDY records are unique for the IGS_PS_OFR
264: -- specified. Once a IGS_AD_LOCATION code, attendance mode, attendance type,
265: -- IGS_PS_UNIT set code, admission calendar type or admission category is set
266: -- for one IGS_PS_PAT_OF_STUDY record for a IGS_PS_OFR it must be set
267: -- for all records. This excludes the single default IGS_PS_PAT_OF_STUDY

Line 266: -- for one IGS_PS_PAT_OF_STUDY record for a IGS_PS_OFR it must be set

262: BEGIN -- crsp_val_pos_iu
263: -- Validate IGS_PS_PAT_OF_STUDY records are unique for the IGS_PS_OFR
264: -- specified. Once a IGS_AD_LOCATION code, attendance mode, attendance type,
265: -- IGS_PS_UNIT set code, admission calendar type or admission category is set
266: -- for one IGS_PS_PAT_OF_STUDY record for a IGS_PS_OFR it must be set
267: -- for all records. This excludes the single default IGS_PS_PAT_OF_STUDY
268: -- record which is allowed to exist for each IGS_PS_OFR where IGS_AD_LOCATION
269: -- code, attendance mode, attendance type, IGS_PS_UNIT set code, admission calendar
270: -- type and admission category are all not set.

Line 267: -- for all records. This excludes the single default IGS_PS_PAT_OF_STUDY

263: -- Validate IGS_PS_PAT_OF_STUDY records are unique for the IGS_PS_OFR
264: -- specified. Once a IGS_AD_LOCATION code, attendance mode, attendance type,
265: -- IGS_PS_UNIT set code, admission calendar type or admission category is set
266: -- for one IGS_PS_PAT_OF_STUDY record for a IGS_PS_OFR it must be set
267: -- for all records. This excludes the single default IGS_PS_PAT_OF_STUDY
268: -- record which is allowed to exist for each IGS_PS_OFR where IGS_AD_LOCATION
269: -- code, attendance mode, attendance type, IGS_PS_UNIT set code, admission calendar
270: -- type and admission category are all not set.
271: DECLARE

Line 274: v_location_cd IGS_PS_PAT_OF_STUDY.location_cd%TYPE;

270: -- type and admission category are all not set.
271: DECLARE
272: v_dummy VARCHAR2(255);
273: v_ret_false_flg BOOLEAN;
274: v_location_cd IGS_PS_PAT_OF_STUDY.location_cd%TYPE;
275: v_attendance_mode IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE;
276: v_attendance_type IGS_PS_PAT_OF_STUDY.attendance_type%TYPE;
277: v_unit_set_cd IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE;
278: v_admission_cal_type IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE;

Line 275: v_attendance_mode IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE;

271: DECLARE
272: v_dummy VARCHAR2(255);
273: v_ret_false_flg BOOLEAN;
274: v_location_cd IGS_PS_PAT_OF_STUDY.location_cd%TYPE;
275: v_attendance_mode IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE;
276: v_attendance_type IGS_PS_PAT_OF_STUDY.attendance_type%TYPE;
277: v_unit_set_cd IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE;
278: v_admission_cal_type IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE;
279: v_admission_cat IGS_PS_PAT_OF_STUDY.admission_cat%TYPE;

Line 276: v_attendance_type IGS_PS_PAT_OF_STUDY.attendance_type%TYPE;

272: v_dummy VARCHAR2(255);
273: v_ret_false_flg BOOLEAN;
274: v_location_cd IGS_PS_PAT_OF_STUDY.location_cd%TYPE;
275: v_attendance_mode IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE;
276: v_attendance_type IGS_PS_PAT_OF_STUDY.attendance_type%TYPE;
277: v_unit_set_cd IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE;
278: v_admission_cal_type IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE;
279: v_admission_cat IGS_PS_PAT_OF_STUDY.admission_cat%TYPE;
280: CURSOR c_pos IS

Line 277: v_unit_set_cd IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE;

273: v_ret_false_flg BOOLEAN;
274: v_location_cd IGS_PS_PAT_OF_STUDY.location_cd%TYPE;
275: v_attendance_mode IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE;
276: v_attendance_type IGS_PS_PAT_OF_STUDY.attendance_type%TYPE;
277: v_unit_set_cd IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE;
278: v_admission_cal_type IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE;
279: v_admission_cat IGS_PS_PAT_OF_STUDY.admission_cat%TYPE;
280: CURSOR c_pos IS
281: SELECT 'X'

Line 278: v_admission_cal_type IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE;

274: v_location_cd IGS_PS_PAT_OF_STUDY.location_cd%TYPE;
275: v_attendance_mode IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE;
276: v_attendance_type IGS_PS_PAT_OF_STUDY.attendance_type%TYPE;
277: v_unit_set_cd IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE;
278: v_admission_cal_type IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE;
279: v_admission_cat IGS_PS_PAT_OF_STUDY.admission_cat%TYPE;
280: CURSOR c_pos IS
281: SELECT 'X'
282: FROM IGS_PS_PAT_OF_STUDY pos

Line 279: v_admission_cat IGS_PS_PAT_OF_STUDY.admission_cat%TYPE;

275: v_attendance_mode IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE;
276: v_attendance_type IGS_PS_PAT_OF_STUDY.attendance_type%TYPE;
277: v_unit_set_cd IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE;
278: v_admission_cal_type IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE;
279: v_admission_cat IGS_PS_PAT_OF_STUDY.admission_cat%TYPE;
280: CURSOR c_pos IS
281: SELECT 'X'
282: FROM IGS_PS_PAT_OF_STUDY pos
283: WHERE pos.course_cd = p_course_cd AND

Line 282: FROM IGS_PS_PAT_OF_STUDY pos

278: v_admission_cal_type IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE;
279: v_admission_cat IGS_PS_PAT_OF_STUDY.admission_cat%TYPE;
280: CURSOR c_pos IS
281: SELECT 'X'
282: FROM IGS_PS_PAT_OF_STUDY pos
283: WHERE pos.course_cd = p_course_cd AND
284: pos.version_number = p_version_number AND
285: pos.cal_type = p_cal_type AND
286: pos.sequence_number <> p_sequence_number AND

Line 296: FROM IGS_PS_PAT_OF_STUDY pos

292: pos.admission_cat IS NULL;
293:
294: CURSOR c_pos2 IS
295: SELECT 'X'
296: FROM IGS_PS_PAT_OF_STUDY pos
297: WHERE pos.course_cd = p_course_cd AND
298: pos.version_number = p_version_number AND
299: pos.cal_type = p_cal_type AND
300: pos.sequence_number <> p_sequence_number AND

Line 328: FROM IGS_PS_PAT_OF_STUDY pos

324: pos.attendance_type,
325: pos.unit_set_cd,
326: pos.admission_cal_type,
327: pos.admission_cat
328: FROM IGS_PS_PAT_OF_STUDY pos
329: WHERE pos.course_cd = p_course_cd AND
330: pos.version_number = p_version_number AND
331: pos.cal_type = p_cal_type AND
332: pos.sequence_number <> p_sequence_number AND