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.

APPS.IGS_PR_CP_GPA dependencies on IGS_EN_SU_ATTEMPT

Line 81: P_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,

77: p_msg_data OUT NOCOPY VARCHAR2)
78: RETURN VARCHAR2;
79:
80: FUNCTION chk_sua_ref_cd(
81: P_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
82: P_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
83: P_uoo_id IN NUMBER,
84: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
85: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

Line 82: P_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,

78: RETURN VARCHAR2;
79:
80: FUNCTION chk_sua_ref_cd(
81: P_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
82: P_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
83: P_uoo_id IN NUMBER,
84: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
85: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
86: p_init_msg_list IN VARCHAR2,

Line 121: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,

117: -- swaghmar; 15-Sep-2005; Bug 4491456
118: -- Modified the signature
119: --
120: PROCEDURE get_sua_stats(
121: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
122: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
123: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
124: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
125: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,

Line 122: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,

118: -- Modified the signature
119: --
120: PROCEDURE get_sua_stats(
121: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
122: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
123: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
124: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
125: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
126: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,

Line 123: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,

119: --
120: PROCEDURE get_sua_stats(
121: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
122: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
123: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
124: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
125: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
126: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,
127: p_earned_cp OUT NOCOPY NUMBER,

Line 124: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,

120: PROCEDURE get_sua_stats(
121: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
122: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
123: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
124: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
125: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
126: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,
127: p_earned_cp OUT NOCOPY NUMBER,
128: p_attempted_cp OUT NOCOPY NUMBER,

Line 125: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,

121: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
122: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
123: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
124: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
125: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
126: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,
127: p_earned_cp OUT NOCOPY NUMBER,
128: p_attempted_cp OUT NOCOPY NUMBER,
129: p_gpa_value OUT NOCOPY NUMBER,

Line 126: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,

122: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
123: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
124: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
125: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
126: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,
127: p_earned_cp OUT NOCOPY NUMBER,
128: p_attempted_cp OUT NOCOPY NUMBER,
129: p_gpa_value OUT NOCOPY NUMBER,
130: p_gpa_cp OUT NOCOPY NUMBER,

Line 1066: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,

1062: -- swaghmar; 15-Sep-2005; Bug 4491456
1063: -- Modified the signature
1064: --
1065: PROCEDURE get_sua_stats (
1066: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
1067: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
1068: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
1069: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
1070: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,

Line 1067: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,

1063: -- Modified the signature
1064: --
1065: PROCEDURE get_sua_stats (
1066: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
1067: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
1068: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
1069: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
1070: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
1071: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,

Line 1068: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,

1064: --
1065: PROCEDURE get_sua_stats (
1066: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
1067: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
1068: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
1069: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
1070: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
1071: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,
1072: p_earned_cp OUT NOCOPY NUMBER,

Line 1069: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,

1065: PROCEDURE get_sua_stats (
1066: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
1067: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
1068: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
1069: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
1070: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
1071: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,
1072: p_earned_cp OUT NOCOPY NUMBER,
1073: p_attempted_cp OUT NOCOPY NUMBER,

Line 1070: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,

1066: p_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
1067: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
1068: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
1069: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
1070: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
1071: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,
1072: p_earned_cp OUT NOCOPY NUMBER,
1073: p_attempted_cp OUT NOCOPY NUMBER,
1074: p_gpa_value OUT NOCOPY NUMBER,

Line 1071: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,

1067: p_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
1068: p_unit_cd IN igs_en_su_attempt_ALL.unit_cd%TYPE,
1069: p_unit_version_number IN igs_en_su_attempt_ALL.version_number%TYPE,
1070: p_teach_cal_type IN igs_en_su_attempt_ALL.cal_type%TYPE,
1071: p_teach_ci_sequence_number IN igs_en_su_attempt_ALL.ci_sequence_number%TYPE,
1072: p_earned_cp OUT NOCOPY NUMBER,
1073: p_attempted_cp OUT NOCOPY NUMBER,
1074: p_gpa_value OUT NOCOPY NUMBER,
1075: p_gpa_cp OUT NOCOPY NUMBER,

Line 1108: igs_en_su_attempt_ALL sua,

1104: NVL(uc.achievable_credit_points, uc.enrolled_credit_points) uc_credit_points,
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

Line 1156: l_unit_attempt_status igs_en_su_attempt_ALL.unit_attempt_status%TYPE;

1152: l_init_msg_list VARCHAR2(20);
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;

Line 1305: p_person_id IN igs_en_su_attempt.person_id%TYPE,

1301: -- Added p_uoo_id parameter to the PROCEDURE get_sua_all
1302: --
1303:
1304: PROCEDURE get_sua_all (
1305: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1306: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1307: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1308: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
1309: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

Line 1306: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

1302: --
1303:
1304: PROCEDURE get_sua_all (
1305: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1306: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1307: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1308: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
1309: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1310: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

Line 1307: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,

1303:
1304: PROCEDURE get_sua_all (
1305: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1306: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1307: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1308: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
1309: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1310: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
1311: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,

Line 1308: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,

1304: PROCEDURE get_sua_all (
1305: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1306: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1307: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1308: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
1309: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1310: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
1311: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
1312: p_system_stat IN VARCHAR2,

Line 1309: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,

1305: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1306: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1307: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1308: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
1309: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1310: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
1311: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
1312: p_system_stat IN VARCHAR2,
1313: p_earned_cp OUT NOCOPY NUMBER,

Line 1310: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,

1306: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1307: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
1308: p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
1309: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
1310: p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
1311: p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
1312: p_system_stat IN VARCHAR2,
1313: p_earned_cp OUT NOCOPY NUMBER,
1314: p_attempted_cp OUT NOCOPY NUMBER,

Line 1944: FROM igs_en_su_attempt_ALL sua, igs_ca_inst ci1

1940: --
1941: CURSOR c_sua_uv IS
1942: SELECT sua.person_id,sua.course_cd, sua.unit_cd, sua.version_number, sua.cal_type, sua.ci_sequence_number,
1943: sua.uoo_id ,sua.unit_attempt_status
1944: FROM igs_en_su_attempt_ALL sua, igs_ca_inst ci1
1945: WHERE sua.person_id = p_person_id
1946: AND sua.course_cd = p_course_cd
1947: AND sua.unit_attempt_status IN
1948: ('COMPLETED', 'DUPLICATE', 'ENROLLED', 'DISCONTIN')

Line 2584: P_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,

2580: -- Added chk_sua_ref_cd function
2581: --
2582:
2583: FUNCTION chk_sua_ref_cd(
2584: P_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
2585: P_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
2586: P_uoo_id IN NUMBER,
2587: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
2588: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,

Line 2585: P_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,

2581: --
2582:
2583: FUNCTION chk_sua_ref_cd(
2584: P_person_id IN igs_en_su_attempt_ALL.person_id%TYPE,
2585: P_course_cd IN igs_en_su_attempt_ALL.course_cd%TYPE,
2586: P_uoo_id IN NUMBER,
2587: p_org_unit_cd IN igs_pr_org_stat.org_unit_cd%TYPE,
2588: p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
2589: p_init_msg_list IN VARCHAR2,