APPS.IGS_AV_VAL_ASU dependencies on IGS_PS_VER

Line 528: cp_course_cd igs_ps_ver.course_cd%TYPE,

524: -- Cursor to get the Advanced Standing Limits from the Course Version setup
525: -- kdande; 07-Oct-2003; Bug# 3154803; Changed the select to handle NULL values
526: --
527: CURSOR c_course_version_details (
528: cp_course_cd igs_ps_ver.course_cd%TYPE,
529: cp_version_number igs_ps_ver.version_number%TYPE
530: ) IS
531: SELECT NVL (cv.external_adv_stnd_limit, 0) external_adv_stnd_limit,
532: NVL (cv.internal_adv_stnd_limit, 0) internal_adv_stnd_limit,

Line 529: cp_version_number igs_ps_ver.version_number%TYPE

525: -- kdande; 07-Oct-2003; Bug# 3154803; Changed the select to handle NULL values
526: --
527: CURSOR c_course_version_details (
528: cp_course_cd igs_ps_ver.course_cd%TYPE,
529: cp_version_number igs_ps_ver.version_number%TYPE
530: ) IS
531: SELECT NVL (cv.external_adv_stnd_limit, 0) external_adv_stnd_limit,
532: NVL (cv.internal_adv_stnd_limit, 0) internal_adv_stnd_limit,
533: NVL (cv.credit_points_required, 0) credit_points_required

Line 534: FROM igs_ps_ver cv

530: ) IS
531: SELECT NVL (cv.external_adv_stnd_limit, 0) external_adv_stnd_limit,
532: NVL (cv.internal_adv_stnd_limit, 0) internal_adv_stnd_limit,
533: NVL (cv.credit_points_required, 0) credit_points_required
534: FROM igs_ps_ver cv
535: WHERE cv.course_cd = cp_course_cd
536: AND cv.version_number = cp_version_number;
537:
538: CURSOR c_local_inst_ind (cp_ins_cd igs_or_institution.institution_cd%TYPE) IS

Line 582: v_ext_adv_stnd_limit igs_ps_ver.external_adv_stnd_limit%TYPE;

578: AND asul.s_adv_stnd_granting_status IN (cst_approved, cst_granted);
579:
580: v_other_detail VARCHAR2 (255);
581: v_adv_stnd_granting_status igs_av_stnd_unit.s_adv_stnd_granting_status%TYPE;
582: v_ext_adv_stnd_limit igs_ps_ver.external_adv_stnd_limit%TYPE;
583: v_int_adv_stnd_limit igs_ps_ver.internal_adv_stnd_limit%TYPE;
584: v_credit_points_reqd igs_ps_ver.credit_points_required%TYPE;
585: v_local_inst_ind igs_or_institution.institution_cd%TYPE;
586: v_external_adv_stnd_total NUMBER;

Line 583: v_int_adv_stnd_limit igs_ps_ver.internal_adv_stnd_limit%TYPE;

579:
580: v_other_detail VARCHAR2 (255);
581: v_adv_stnd_granting_status igs_av_stnd_unit.s_adv_stnd_granting_status%TYPE;
582: v_ext_adv_stnd_limit igs_ps_ver.external_adv_stnd_limit%TYPE;
583: v_int_adv_stnd_limit igs_ps_ver.internal_adv_stnd_limit%TYPE;
584: v_credit_points_reqd igs_ps_ver.credit_points_required%TYPE;
585: v_local_inst_ind igs_or_institution.institution_cd%TYPE;
586: v_external_adv_stnd_total NUMBER;
587: v_internal_adv_stnd_total NUMBER;

Line 584: v_credit_points_reqd igs_ps_ver.credit_points_required%TYPE;

580: v_other_detail VARCHAR2 (255);
581: v_adv_stnd_granting_status igs_av_stnd_unit.s_adv_stnd_granting_status%TYPE;
582: v_ext_adv_stnd_limit igs_ps_ver.external_adv_stnd_limit%TYPE;
583: v_int_adv_stnd_limit igs_ps_ver.internal_adv_stnd_limit%TYPE;
584: v_credit_points_reqd igs_ps_ver.credit_points_required%TYPE;
585: v_local_inst_ind igs_or_institution.institution_cd%TYPE;
586: v_external_adv_stnd_total NUMBER;
587: v_internal_adv_stnd_total NUMBER;
588: -- 16-Oct-2002; kdande; Bug# 2627933

Line 669: -- get the IGS_PS_VER advanced

665: RETURN FALSE;
666: END IF;
667: END IF;
668:
669: -- get the IGS_PS_VER advanced
670: -- standing limits
671: OPEN c_course_version_details (p_course_cd, p_version_number);
672: FETCH c_course_version_details INTO v_ext_adv_stnd_limit,
673: v_int_adv_stnd_limit,