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.

[Home] [Help]

APPS.IGS_RU_GEN_001 dependencies on IGS_PS_UNIT_VER

Line 677: FROM IGS_PS_UNIT_VER_RU

673: v_rule_number NUMBER;
674: BEGIN
675: SELECT rul_sequence_number
676: INTO v_rule_number
677: FROM IGS_PS_UNIT_VER_RU
678: WHERE unit_cd = p_unit_cd
679: AND version_number = p_version
680: AND s_rule_call_cd = p_rule_call_name;
681: RETURN v_rule_number;

Line 894: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;

890: FUNCTION uv_attribute (
891: p_attribute VARCHAR2,
892: p_tds r_tds )
893: RETURN VARCHAR2 IS
894: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
895: BEGIN
896: SELECT repeatable_ind
897: INTO v_repeatable_ind
898: FROM IGS_PS_UNIT_VER

Line 898: FROM IGS_PS_UNIT_VER

894: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
895: BEGIN
896: SELECT repeatable_ind
897: INTO v_repeatable_ind
898: FROM IGS_PS_UNIT_VER
899: WHERE unit_cd = p_tds.unit_cd
900: AND version_number = p_tds.unit_version;
901: IF p_attribute = 'rep_ind'
902: THEN

Line 945: p_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

941: /*
942: unit version credit points
943: */
944: FUNCTION uv_credit_points (
945: p_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
946: p_unit_version IGS_PS_UNIT_VER.version_number%TYPE )
947: RETURN NUMBER IS
948: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
949: BEGIN

Line 946: p_unit_version IGS_PS_UNIT_VER.version_number%TYPE )

942: unit version credit points
943: */
944: FUNCTION uv_credit_points (
945: p_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
946: p_unit_version IGS_PS_UNIT_VER.version_number%TYPE )
947: RETURN NUMBER IS
948: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
949: BEGIN
950: SELECT NVL(achievable_credit_points,enrolled_credit_points)

Line 948: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;

944: FUNCTION uv_credit_points (
945: p_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
946: p_unit_version IGS_PS_UNIT_VER.version_number%TYPE )
947: RETURN NUMBER IS
948: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
949: BEGIN
950: SELECT NVL(achievable_credit_points,enrolled_credit_points)
951: INTO v_achievable_credit_points
952: FROM IGS_PS_UNIT_VER

Line 952: FROM IGS_PS_UNIT_VER

948: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
949: BEGIN
950: SELECT NVL(achievable_credit_points,enrolled_credit_points)
951: INTO v_achievable_credit_points
952: FROM IGS_PS_UNIT_VER
953: WHERE unit_cd = p_unit_cd
954: AND version_number = p_unit_version;
955: RETURN v_achievable_credit_points;
956: END uv_credit_points;

Line 960: l_n_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;

956: END uv_credit_points;
957:
958: FUNCTION us_uv_credit_points( p_uoo_id IN NUMBER)
959: RETURN NUMBER IS
960: l_n_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
961: BEGIN
962: SELECT NVL(cps.achievable_credit_points,NVL(uv.achievable_credit_points,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)))
963: INTO l_n_credit_points
964: FROM IGS_PS_UNIT_VER uv,

Line 964: FROM IGS_PS_UNIT_VER uv,

960: l_n_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
961: BEGIN
962: SELECT NVL(cps.achievable_credit_points,NVL(uv.achievable_credit_points,NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)))
963: INTO l_n_credit_points
964: FROM IGS_PS_UNIT_VER uv,
965: IGS_PS_UNIT_OFR_OPT uoo,
966: IGS_PS_USEC_CPS cps
967: WHERE uoo.uoo_id=cps.uoo_id(+) AND
968: uoo.uoo_id=p_uoo_id AND

Line 3085: PROCEDURE val_placement (pp_unit_cd IN IGS_PS_UNIT_VER.UNIT_CD%TYPE,

3081: igs_ad_up_header h
3082: WHERE atr.person_id = p_person_id
3083: AND atr.admission_test_type = h.admission_test_type
3084: AND h.up_header_id = d.up_header_id);
3085: PROCEDURE val_placement (pp_unit_cd IN IGS_PS_UNIT_VER.UNIT_CD%TYPE,
3086: pp_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
3087: pp_found OUT NOCOPY BOOLEAN)IS
3088:
3089: l_dummy VARCHAR2(1);

Line 3092: CURSOR cur_st_test(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE) IS

3088:
3089: l_dummy VARCHAR2(1);
3090:
3091: --Gets the unit placement details
3092: CURSOR cur_st_test(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE) IS
3093: SELECT admission_test_type,
3094: test_segment_id,
3095: definition_level,
3096: min_score,

Line 3315: FROM IGS_PS_UNIT_VER

3311: */
3312: FOR uv IN (
3313: SELECT unit_cd,
3314: version_number
3315: FROM IGS_PS_UNIT_VER
3316: WHERE unit_cd LIKE (p_unit_cd)
3317: ORDER BY unit_cd,IGS_GE_NUMBER.TO_CANN(version_number) )
3318: LOOP
3319: IF in_versions(uv.version_number,

Line 3378: FROM IGS_PS_UNIT_VER_RU uvr,

3374: SELECT rsm.unit_cd rms_unit_cd,
3375: rsm.versions rms_versions,
3376: uvr.unit_cd uvr_unit_cd,
3377: uvr.version_number uvr_version_number
3378: FROM IGS_PS_UNIT_VER_RU uvr,
3379: igs_ru_item rui,
3380: igs_ru_set_member rsm
3381: WHERE rsm.unit_cd = p_unit_cd
3382: AND uvr.s_rule_call_cd = 'TRANS'

Line 4725: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;

4721:
4722: l_return_status VARCHAR2(1);
4723: l_msg_count NUMBER;
4724: l_msg_data VARCHAR2(2000);
4725: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4726: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4727: l_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
4728:
4729: --OUT varibales to be passed to igs_as_gen_003.assp_get_sua_outcomes Function

Line 4726: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;

4722: l_return_status VARCHAR2(1);
4723: l_msg_count NUMBER;
4724: l_msg_data VARCHAR2(2000);
4725: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4726: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4727: l_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
4728:
4729: --OUT varibales to be passed to igs_as_gen_003.assp_get_sua_outcomes Function
4730: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;

Line 4950: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;

4946: smvk 02-Sep-2002 Default keyword is replaced by assignment operator (:=), to overcome File.Pkg.22 warning
4947: As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390).
4948: *************************************************************************************************/
4949:
4950: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4951: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4952: l_total_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=
4953: l_total_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=
4954: l_return_status VARCHAR2(1);

Line 4951: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;

4947: As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390).
4948: *************************************************************************************************/
4949:
4950: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4951: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4952: l_total_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=
4953: l_total_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=
4954: l_return_status VARCHAR2(1);
4955: l_msg_count NUMBER;

Line 4952: l_total_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=

4948: *************************************************************************************************/
4949:
4950: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4951: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4952: l_total_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=
4953: l_total_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=
4954: l_return_status VARCHAR2(1);
4955: l_msg_count NUMBER;
4956: l_msg_data VARCHAR2(2000);

Line 4953: l_total_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=

4949:
4950: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4951: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
4952: l_total_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=
4953: l_total_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE := 0 ; -- Replaced Default by :=
4954: l_return_status VARCHAR2(1);
4955: l_msg_count NUMBER;
4956: l_msg_data VARCHAR2(2000);
4957: