DBA Data[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;