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

Line 70: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

66: p_msg_count OUT NOCOPY NUMBER,
67: p_msg_data OUT NOCOPY VARCHAR2);
68:
69: FUNCTION chk_unit_ref_cd(
70: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
71: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
72: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
73: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
74: p_init_msg_list IN VARCHAR2,

Line 71: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,

67: p_msg_data OUT NOCOPY VARCHAR2);
68:
69: FUNCTION chk_unit_ref_cd(
70: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
71: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
72: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
73: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
74: p_init_msg_list IN VARCHAR2,
75: p_return_status OUT NOCOPY VARCHAR2,

Line 602: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

598: p_data => p_msg_data);
599: END get_stat_dtls;
600:
601: FUNCTION chk_unit_ref_cd(
602: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
603: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
604: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
605: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
606: p_init_msg_list IN VARCHAR2,

Line 603: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,

599: END get_stat_dtls;
600:
601: FUNCTION chk_unit_ref_cd(
602: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
603: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
604: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
605: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
606: p_init_msg_list IN VARCHAR2,
607: p_return_status OUT NOCOPY VARCHAR2,

Line 1109: igs_ps_unit_ver uv,

1105: NVL(uv.achievable_credit_points, uv.enrolled_credit_points) uv_credit_points
1106: FROM igs_en_stdnt_ps_att spa,
1107: igs_ps_ver pv,
1108: igs_en_su_attempt_ALL sua,
1109: igs_ps_unit_ver uv,
1110: igs_ps_usec_cps uc
1111: WHERE spa.person_id = p_person_id
1112: AND spa.course_cd = p_course_cd
1113: AND spa.course_cd = pv.course_cd

Line 1157: l_sua_override_cp igs_ps_unit_ver.achievable_credit_points%TYPE;

1153: l_return_status VARCHAR2(30);
1154: l_msg_count NUMBER(2);
1155: l_msg_data VARCHAR2(30);
1156: l_unit_attempt_status igs_en_su_attempt_ALL.unit_attempt_status%TYPE;
1157: l_sua_override_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
1158: l_uc_credit_points igs_ps_unit_ver.achievable_credit_points%TYPE;
1159: l_uv_credit_points igs_ps_unit_ver.achievable_credit_points%TYPE;
1160: l_unit_cp NUMBER := 0;
1161: l_result_type VARCHAR2(20);

Line 1158: l_uc_credit_points igs_ps_unit_ver.achievable_credit_points%TYPE;

1154: l_msg_count NUMBER(2);
1155: l_msg_data VARCHAR2(30);
1156: l_unit_attempt_status igs_en_su_attempt_ALL.unit_attempt_status%TYPE;
1157: l_sua_override_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
1158: l_uc_credit_points igs_ps_unit_ver.achievable_credit_points%TYPE;
1159: l_uv_credit_points igs_ps_unit_ver.achievable_credit_points%TYPE;
1160: l_unit_cp NUMBER := 0;
1161: l_result_type VARCHAR2(20);
1162: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;

Line 1159: l_uv_credit_points igs_ps_unit_ver.achievable_credit_points%TYPE;

1155: l_msg_data VARCHAR2(30);
1156: l_unit_attempt_status igs_en_su_attempt_ALL.unit_attempt_status%TYPE;
1157: l_sua_override_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
1158: l_uc_credit_points igs_ps_unit_ver.achievable_credit_points%TYPE;
1159: l_uv_credit_points igs_ps_unit_ver.achievable_credit_points%TYPE;
1160: l_unit_cp NUMBER := 0;
1161: l_result_type VARCHAR2(20);
1162: l_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
1163: l_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE;

Line 1355: p_enrolled_cp igs_ps_unit_ver.achievable_credit_points%TYPE :=0;

1351: l_return_status VARCHAR2(30);
1352: l_msg_count NUMBER(2);
1353: l_msg_data VARCHAR2(30);
1354: l_org_id NUMBER(4);
1355: p_enrolled_cp igs_ps_unit_ver.achievable_credit_points%TYPE :=0;
1356:
1357: -- Added as part of fix for Bug# 5260180
1358: v_inc_exc_ul VARCHAR2(1) := 'Y';
1359: v_inc_exc_sua VARCHAR2(1) := 'Y';

Line 1571: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

1567: --
1568: PROCEDURE get_sua_cp(
1569: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1570: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1571: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1572: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
1573: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
1574: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1575: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

Line 1572: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,

1568: PROCEDURE get_sua_cp(
1569: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1570: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1571: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1572: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
1573: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
1574: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1575: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
1576: p_system_stat IN VARCHAR2,

Line 1713: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

1709: --
1710: PROCEDURE get_sua_gpa(
1711: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1712: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1713: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1714: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
1715: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
1716: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1717: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

Line 1714: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,

1710: PROCEDURE get_sua_gpa(
1711: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1712: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1713: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1714: p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
1715: p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
1716: p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1717: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
1718: p_system_stat IN VARCHAR2,

Line 1744: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;

1740: -- at the Student Unit Attempt Level
1741: -- (reverse chronological order - newest change first)
1742: --------------------------------------------------------------------------
1743:
1744: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
1745: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
1746: l_gpa_cp NUMBER;
1747: l_gpa_quality_points NUMBER;
1748: l_gpa_value NUMBER;

Line 1745: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;

1741: -- (reverse chronological order - newest change first)
1742: --------------------------------------------------------------------------
1743:
1744: l_earned_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
1745: l_attempted_cp igs_ps_unit_ver.achievable_credit_points%TYPE;
1746: l_gpa_cp NUMBER;
1747: l_gpa_quality_points NUMBER;
1748: l_gpa_value NUMBER;
1749: l_return_status VARCHAR2(30);

Line 2014: l_enrolled_cp_total igs_ps_unit_ver.achievable_credit_points%TYPE := 0;

2010: l_msg_count NUMBER(2);
2011: l_msg_data VARCHAR2(30);
2012: l_org_id NUMBER(4);
2013: l_enrolled_cp igs_pr_stu_acad_stat.gpa_credit_points%TYPE := 0;
2014: l_enrolled_cp_total igs_ps_unit_ver.achievable_credit_points%TYPE := 0;
2015:
2016: -- Added as part of fix for Bug# 5260180
2017: v_inc_exc_ul VARCHAR2(1) := 'Y';
2018: v_inc_exc_sua VARCHAR2(1) := 'Y';