[Home] [Help]
PACKAGE: APPS.IGS_PR_CP_GPA
Source
1 PACKAGE igs_pr_cp_gpa AS
2 /* $Header: IGSPR32S.pls 120.1 2005/09/15 03:19:53 appldev noship $ */
3 /*
4 || Created By : prchandr
5 || Created On : 24-NOV-2001
6 || Purpose : Package Specification For Academic Statistics and GPA
7 || Known limitations, enhancements or remarks :
8 || (reverse chronological order - newest change first)
9 || Change History :
10 || Who When What
11 || nalkumar 22-Apr-2004 Modified get_cp_stats, get_gpa_stats, get_sua_gpa, get_sua_cp and get_sua_all
12 || procedures and added p_use_released_grade parameter.
13 || This is to fix Bug# 3547126
14 || jhanda 28-May-2003 Changed gpa , gpa_quality points ,
15 || gpa_credit_points procedure parameter types.
16 || swaghmar 15-Sep-2005 Bug# 4491456 - Modified the signatures of get_all_stats_new(),
17 || get_gpa_stats(), get_all_stats(), get_sua_gpa(),
18 || get_sua_all()
19 */
20
21 --
22 -- kdande; 23-Apr-2003; Bug# 2829262
23 -- Added p_uoo_id parameter to the PROCEDURE get_sua_all
24 --
25 PROCEDURE get_sua_all(
26 p_person_id IN igs_en_su_attempt.person_id%TYPE,
27 p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
28 p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
29 p_unit_version_number IN igs_en_su_attempt.version_number%TYPE,
30 p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
31 p_teach_ci_sequence_number IN igs_en_su_attempt.ci_sequence_number%TYPE,
32 p_stat_type IN igs_pr_org_stat.stat_type%TYPE,
33 p_system_stat IN VARCHAR2,
34 p_earned_cp OUT NOCOPY NUMBER,
35 p_attempted_cp OUT NOCOPY NUMBER,
36 p_gpa_value OUT NOCOPY NUMBER,
37 p_gpa_cp OUT NOCOPY NUMBER,
38 p_gpa_quality_points OUT NOCOPY NUMBER,
39 p_init_msg_list IN VARCHAR2,
40 p_return_status OUT NOCOPY VARCHAR2,
41 p_msg_count OUT NOCOPY NUMBER,
42 p_msg_data OUT NOCOPY VARCHAR2,
43 p_uoo_id IN NUMBER DEFAULT NULL,
44 p_use_released_grade IN VARCHAR2 DEFAULT NULL);
45
46 --
47 -- kdande; 23-Apr-2003; Bug# 2829262
48 -- Added p_uoo_id parameter to the FUNCTION get_sua_cp
49 --
50 PROCEDURE get_sua_cp(
51 p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
52 p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
53 p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
54 p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
55 p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
56 p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
57 p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
58 p_system_stat IN VARCHAR2,
59 p_earned_cp OUT NOCOPY NUMBER,
60 p_attempted_cp OUT NOCOPY NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_TRUE,
62 p_return_status OUT NOCOPY VARCHAR2,
63 p_msg_count OUT NOCOPY NUMBER,
64 p_msg_data OUT NOCOPY VARCHAR2,
65 p_uoo_id IN NUMBER DEFAULT NULL,
66 p_use_released_grade IN VARCHAR2 DEFAULT NULL);
67
68 --
69 -- kdande; 23-Apr-2003; Bug# 2829262
70 -- Added p_uoo_id parameter to the FUNCTION get_sua_gpa
71 --
72 PROCEDURE get_sua_gpa (
73 p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
74 p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
75 p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
76 p_unit_version_number IN igs_ps_unit_ver.version_number%TYPE,
77 p_teach_cal_type IN igs_ca_inst.cal_type%TYPE,
78 p_teach_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
79 p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
80 p_system_stat IN VARCHAR2,
81 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
82 p_gpa_value OUT NOCOPY NUMBER,
83 p_gpa_cp OUT NOCOPY NUMBER,
84 p_gpa_quality_points OUT NOCOPY NUMBER,
85 p_return_status OUT NOCOPY VARCHAR2,
86 p_msg_count OUT NOCOPY NUMBER,
87 p_msg_data OUT NOCOPY VARCHAR2,
88 p_uoo_id IN NUMBER DEFAULT NULL,
89 p_use_released_grade IN VARCHAR2 DEFAULT NULL);
90
91
92 PROCEDURE get_all_stats(
93 p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
94 p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
95 p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
96 p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
97 p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
98 p_system_stat IN VARCHAR2,
99 p_cumulative_ind IN VARCHAR2,
100 p_earned_cp OUT NOCOPY NUMBER,
101 p_attempted_cp OUT NOCOPY NUMBER,
102 p_gpa_value OUT NOCOPY NUMBER,
103 p_gpa_cp OUT NOCOPY NUMBER,
104 p_gpa_quality_points OUT NOCOPY NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
106 p_return_status OUT NOCOPY VARCHAR2,
107 p_msg_count OUT NOCOPY NUMBER,
108 p_msg_data OUT NOCOPY VARCHAR2,
109 p_use_released_grade IN VARCHAR2 DEFAULT NULL);
110
111
112 PROCEDURE get_cp_stats(
113 p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
114 p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
115 p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
116 p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
117 p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
118 p_system_stat IN VARCHAR2,
119 p_cumulative_ind IN VARCHAR2,
120 p_earned_cp OUT NOCOPY NUMBER,
121 p_attempted_cp OUT NOCOPY NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
123 p_return_status OUT NOCOPY VARCHAR2,
124 p_msg_count OUT NOCOPY NUMBER,
125 p_msg_data OUT NOCOPY VARCHAR2,
126 p_use_released_grade IN VARCHAR2 DEFAULT NULL);
127
128
129 PROCEDURE get_gpa_stats(
130 p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
131 p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
132 p_stat_type IN igs_pr_stat_type.stat_type%TYPE,
133 p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
134 p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
135 p_system_stat IN VARCHAR2,
136 p_cumulative_ind IN VARCHAR2,
137 p_gpa_value OUT NOCOPY NUMBER,
138 p_gpa_cp OUT NOCOPY NUMBER,
139 p_gpa_quality_points OUT NOCOPY NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
141 p_return_status OUT NOCOPY VARCHAR2,
142 p_msg_count OUT NOCOPY NUMBER,
143 p_msg_data OUT NOCOPY VARCHAR2,
144 p_use_released_grade IN VARCHAR2 DEFAULT NULL);
145
146 --
147 -- jhanda; 1-Mar-2005; Bug# 3843525
148 -- Added get_all_stats_new procedure which stubs procedure get_all_stats
149 --
150
151 PROCEDURE get_all_stats_new(
152 p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
153 p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ,
154 p_stat_type IN igs_pr_stat_type.stat_type%TYPE ,
155 p_load_cal_type IN igs_ca_inst.cal_type%TYPE ,
156 p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
157 p_system_stat IN VARCHAR2,
158 p_cumulative_ind IN VARCHAR2,
159 p_earned_cp OUT NOCOPY NUMBER,
160 p_attempted_cp OUT NOCOPY NUMBER,
161 p_gpa_value OUT NOCOPY NUMBER,
162 p_gpa_cp OUT NOCOPY NUMBER,
163 p_gpa_quality_points OUT NOCOPY NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
165 p_return_status OUT NOCOPY VARCHAR2,
166 p_msg_count OUT NOCOPY NUMBER,
167 p_msg_data OUT NOCOPY VARCHAR2,
168 p_use_released_grade IN VARCHAR2 DEFAULT NULL,
169 p_enrolled_cp OUT NOCOPY igs_pr_stu_acad_stat.gpa_quality_points%TYPE);
170
171 END igs_pr_cp_gpa;