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_EN_PRC_LOAD dependencies on IGS_PS_UNIT_VER

Line 284: IGS_PS_UNIT_VER uv

280: sua.uoo_id,
281: sua.no_assessment_ind
282: FROM IGS_EN_SU_ATTEMPT sua,
283: IGS_CA_INST_REL cir,
284: IGS_PS_UNIT_VER uv
285: WHERE sua.person_id = p_person_id AND
286: sua.course_cd = p_course_cd AND
287: sua.unit_attempt_status IN (cst_enrolled,
288: cst_discontin,

Line 494: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

490: --dummy variable to pick up audit, billing, enrolled credit points
491: --due to signature change by EN308 Billing credit hours
492: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
493: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
494: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
495:
496: CURSOR c_uooid IS
497: SELECT sua.uoo_id,
498: NVL(sua.no_assessment_ind,'N')

Line 506: FROM IGS_PS_UNIT_VER uv

502: sua.uoo_id = p_uoo_id;
503:
504: CURSOR c_uv IS
505: SELECT uv.research_unit_ind
506: FROM IGS_PS_UNIT_VER uv
507: WHERE uv.unit_cd = p_unit_cd AND
508: uv.version_number = p_unit_version_number;
509:
510: BEGIN

Line 688: v_unit_level IGS_PS_UNIT_VER.unit_level%TYPE;

684: DECLARE
685: v_funding_index_1 IGS_PS_DSCP.funding_index_1%TYPE;
686: v_funding_index_2 IGS_PS_DSCP.funding_index_2%TYPE;
687: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE;
688: v_unit_level IGS_PS_UNIT_VER.unit_level%TYPE;
689: v_unit_int_course_level_cd IGS_PS_UNIT_VER.unit_int_course_level_cd%TYPE;
690: v_count NUMBER;
691: v_sua_weftsu NUMBER;
692: v_local_ins_deakin_ind VARCHAR2(1);

Line 689: v_unit_int_course_level_cd IGS_PS_UNIT_VER.unit_int_course_level_cd%TYPE;

685: v_funding_index_1 IGS_PS_DSCP.funding_index_1%TYPE;
686: v_funding_index_2 IGS_PS_DSCP.funding_index_2%TYPE;
687: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE;
688: v_unit_level IGS_PS_UNIT_VER.unit_level%TYPE;
689: v_unit_int_course_level_cd IGS_PS_UNIT_VER.unit_int_course_level_cd%TYPE;
690: v_count NUMBER;
691: v_sua_weftsu NUMBER;
692: v_local_ins_deakin_ind VARCHAR2(1);
693: CURSOR c_di IS

Line 702: FROM IGS_PS_UNIT_VER uv,

698: CURSOR c_uv_uicl IS
699: SELECT uicl.weftsu_factor,
700: uv.unit_level,
701: uv.unit_int_course_level_cd
702: FROM IGS_PS_UNIT_VER uv,
703: IGS_PS_UNIT_INT_LVL uicl
704: WHERE uv.unit_cd = p_unit_cd AND
705: uv.version_number = p_version_number AND
706: uicl.unit_int_course_level_cd = uv.unit_int_course_level_cd;

Line 1069: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

1065: --dummy variable to pick up audit, billing, enrolled credit points
1066: --due to signature change by EN308 Billing credit hours
1067: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
1068: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1069: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1070: CURSOR c_cal_type_instance( cp_cal_type IGS_CA_INST.cal_type%TYPE,
1071: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1072: SELECT CI.cal_type,
1073: CI.sequence_number

Line 1205: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

1201: */
1202: BEGIN
1203: BEGIN
1204: DECLARE
1205: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1206: v_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1207: v_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1208: v_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
1209: v_second_percentage IGS_ST_DFT_LOAD_APPO.second_percentage%TYPE;

Line 1206: v_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

1202: BEGIN
1203: BEGIN
1204: DECLARE
1205: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1206: v_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
1207: v_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
1208: v_percentage IGS_ST_DFT_LOAD_APPO.percentage%TYPE;
1209: v_second_percentage IGS_ST_DFT_LOAD_APPO.second_percentage%TYPE;
1210: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;

Line 1463: igs_ps_unit_ver uv

1459: WHERE cal_type = p_load_cal_type AND
1460: closed_flag = 'N' AND
1461: org_unit_cd = (SELECT NVL(uoo.owner_org_unit_cd, uv.owner_org_unit_cd)
1462: FROM igs_ps_unit_ofr_opt uoo,
1463: igs_ps_unit_ver uv
1464: WHERE uoo.uoo_id = p_uoo_id AND
1465: uv.unit_cd = uoo.unit_cd AND
1466: uv.version_number = uoo.version_number);
1467: CURSOR incl_inst_wlst_cp is

Line 2176: IGS_PS_UNIT_VER uv

2172: sua.uoo_id,
2173: sua.no_assessment_ind
2174: FROM IGS_EN_SU_ATTEMPT sua,
2175: IGS_EN_STDNT_PS_ATT sca,
2176: IGS_PS_UNIT_VER uv
2177: WHERE
2178: sca.person_id = p_person_id AND
2179: sca.person_id = sua.person_id AND
2180: sca.course_cd = sua.course_cd AND

Line 2211: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

2207: lv_sua_cp NUMBER(10) := 0;
2208: lv_return_eftsu NUMBER(10);
2209: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;
2210: l_billing_cp IGS_PS_USEC_CPS.billing_hrs%TYPE;
2211: l_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
2212: BEGIN
2213: lv_sua_cp := 0;
2214: FOR l_get_teach_cal_dtls IN c_get_teach_cal_dtls(p_load_cal_type,p_load_sequence_number,p_tp_sd_cut_off_date) LOOP
2215: