APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_OFR

Line 389: FROM IGS_PS_OFR

385: WHERE course_cd = p_course_cd AND
386: crv_version_number =p_version_number;
387: CURSOR c_get_cal_type IS
388: SELECT cal_type
389: FROM IGS_PS_OFR
390: WHERE course_cd = p_course_cd AND
391: version_number = p_version_number;
392: CURSOR c_course_offering_option IS
393: SELECT location_cd,

Line 396: FROM IGS_PS_OFR_OPT

392: CURSOR c_course_offering_option IS
393: SELECT location_cd,
394: attendance_type,
395: attendance_mode
396: FROM IGS_PS_OFR_OPT
397: WHERE course_cd = p_course_cd AND
398: version_number = p_version_number AND
399: delete_flag = 'N';
400: CURSOR c_get_dist_reference_cd_type IS

Line 411: FROM IGS_PS_OFR_INST

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
412: WHERE course_cd = p_course_cd AND
413: version_number = p_version_number;
414: BEGIN
415: OPEN c_course_version;

Line 597: -- Validate that if IGS_PS_OFR records exist,

593: RETURN FALSE;
594: END IF;
595: CLOSE c_get_s_course_status;
596: IF (v_s_course_status = 'PLANNED') THEN
597: -- Validate that if IGS_PS_OFR records exist,
598: -- check that the IGS_CA_TYPE is not closed
599: FOR co_rec IN c_get_cal_type LOOP
600: IF (IGS_PS_VAL_CO.crsp_val_co_cal_type(
601: co_rec.cal_type,

Line 610: -- Validate IGS_PS_OFR_OPT record(s) if it exists and

606: END LOOP;
607: IF (v_terminate = TRUE) THEN
608: RETURN FALSE;
609: END IF;
610: -- Validate IGS_PS_OFR_OPT record(s) if it exists and
611: -- the closed indicators associated with the fields of the record
612: FOR coo_rec IN c_course_offering_option LOOP
613: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_COO.crsp_val_loc_cd
614: IF (IGS_PS_VAL_UOO.crsp_val_loc_cd(

Line 638: -- Validate IGS_PS_OFR_INST record(s) if

634: RETURN FALSE;
635: END IF;
636: -- Validate IGS_PS_ENT_PT_REF_CD record(s) if
637: -- it exists and that IGS_GE_REF_CD_TYPE is not closed.
638: -- Validate IGS_PS_OFR_INST record(s) if
639: -- it exists and the IGS_CA_INST.IGS_CA_STAT is ACTIVE.
640: -- Only perform these if course_offering_records exist.
641: IF (v_coo_exist = TRUE) THEN
642: FOR ceprc_rec IN c_get_dist_reference_cd_type LOOP