APPS.IGS_AV_VAL_ASU dependencies on IGS_AV_STND_UNIT_LVL

Line 59: -- Validate that exemption_institution_cd (IGS_AV_STND_UNIT or IGS_AV_STND_UNIT_LVL

55: WHERE lk.lookup_type = 'OR_INSTITUTION_ADVSTEX'
56: AND lk.enabled_flag = 'Y'
57: AND lk.lookup_code = cp_exempt_inst;
58: BEGIN
59: -- Validate that exemption_institution_cd (IGS_AV_STND_UNIT or IGS_AV_STND_UNIT_LVL
60: -- ) is valid.
61: -- The status is not considered, as it is allowable to select an inactive
62: -- IGS_OR_INSTITUTION for advanced standing basis details.
63:

Line 347: -- Validate that approved_dt(adv-stnd_unit OR IGS_AV_STND_UNIT_LVL) is not

343: )
344: RETURN BOOLEAN IS
345: gv_other_detail VARCHAR2 (255);
346: BEGIN -- advp_val_as_aprvd_dt
347: -- Validate that approved_dt(adv-stnd_unit OR IGS_AV_STND_UNIT_LVL) is not
348: -- less than the granted_dt, cancelled_dt OR revoked_dt for the same record
349: DECLARE
350: v_ret_val BOOLEAN := TRUE;
351: BEGIN

Line 566: cp_person_id igs_av_stnd_unit_lvl.person_id%TYPE,

562: AND asu.s_adv_stnd_recognition_type = cst_credit;
563:
564:
565: CURSOR c_adv_stnd_unit_level (
566: cp_person_id igs_av_stnd_unit_lvl.person_id%TYPE,
567: cp_course_cd igs_av_stnd_unit_lvl.as_course_cd%TYPE,
568: cp_version_num igs_av_stnd_unit_lvl.as_version_number%TYPE
569: ) IS
570: SELECT NVL (asul.credit_points, 0) credit_points,

Line 567: cp_course_cd igs_av_stnd_unit_lvl.as_course_cd%TYPE,

563:
564:
565: CURSOR c_adv_stnd_unit_level (
566: cp_person_id igs_av_stnd_unit_lvl.person_id%TYPE,
567: cp_course_cd igs_av_stnd_unit_lvl.as_course_cd%TYPE,
568: cp_version_num igs_av_stnd_unit_lvl.as_version_number%TYPE
569: ) IS
570: SELECT NVL (asul.credit_points, 0) credit_points,
571: asul.exemption_institution_cd,

Line 568: cp_version_num igs_av_stnd_unit_lvl.as_version_number%TYPE

564:
565: CURSOR c_adv_stnd_unit_level (
566: cp_person_id igs_av_stnd_unit_lvl.person_id%TYPE,
567: cp_course_cd igs_av_stnd_unit_lvl.as_course_cd%TYPE,
568: cp_version_num igs_av_stnd_unit_lvl.as_version_number%TYPE
569: ) IS
570: SELECT NVL (asul.credit_points, 0) credit_points,
571: asul.exemption_institution_cd,
572: asul.unit_level,

Line 574: FROM igs_av_stnd_unit_lvl asul

570: SELECT NVL (asul.credit_points, 0) credit_points,
571: asul.exemption_institution_cd,
572: asul.unit_level,
573: asul.s_adv_stnd_granting_status
574: FROM igs_av_stnd_unit_lvl asul
575: WHERE asul.person_id = cp_person_id
576: AND asul.as_course_cd = cp_course_cd
577: AND asul.as_version_number = cp_version_num
578: AND asul.s_adv_stnd_granting_status IN (cst_approved, cst_granted);

Line 784: -- select IGS_AV_STND_UNIT_LVL for parameters

780: END LOOP;
781:
782:
783: --CLOSE v_av_cp_cur;
784: -- select IGS_AV_STND_UNIT_LVL for parameters
785: -- to add to existing totals
786:
787: FOR v_unit_level IN c_adv_stnd_unit_level (
788: p_person_id,