[Home] [Help]
PACKAGE: APPS.IGS_GR_VAL_GR
Source
1 PACKAGE IGS_GR_VAL_GR AUTHID CURRENT_USER AS
2 /* $Header: IGSGR10S.pls 115.9 2003/10/07 08:36:13 ijeddy ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 27-AUG-2001 Bug No. 1956374 .The function declaration of GRDP_VAL_AWARD_TYPE
7 -- removed .
8 --avenkatr 29-AUG-2001 Bug Id : 1956374. Removed procedure "crsp_val_aw_closed"
9 --ijeddy 06-Oct-2003 Build 3129913, Program completion Validation.
10 -------------------------------------------------------------------------------------------
11 -- Check if a specifc encumbrance effect applies to a person encumbrance
12 FUNCTION enrp_val_encmb_efct(
13 p_person_id HZ_PARTIES.party_id%TYPE,
14 p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
15 p_effective_dt DATE ,
16 p_encmb_effect_type IGS_EN_ENCMB_EFCTTYP.s_encmb_effect_type%TYPE ,
17 p_message_name OUT NOCOPY VARCHAR2 )
18 RETURN BOOLEAN;
19 --
20 -- Validate graduand student course attempt is a graduating course.
21 FUNCTION grdp_val_gr_sca(
22 p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
23 p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
24 p_message_name OUT NOCOPY VARCHAR2 )
25 RETURN BOOLEAN;
26 --
27 -- Validate Graduand Ceremony Round calendar instance.
28 FUNCTION grdp_val_gr_crd_ci(
29 p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
30 p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
31 p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN;
33 --
34 -- Validate GRADUAND required details.
35 FUNCTION grdp_val_gr_rqrd(
36 p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
37 p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
38 p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
39 p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
40 p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
41 p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
42 p_honours_level VARCHAR2 DEFAULT NULL,
43 p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
44 p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
45 p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
46 p_conferral_dt IGS_GR_GRADUAND_V.conferral_dt%TYPE DEFAULT NULL,
47 p_message_name OUT NOCOPY VARCHAR2 )
48 RETURN BOOLEAN;
49 --
50 -- Validate graduand status.
51 FUNCTION grdp_val_gr_gst(
52 p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
53 p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
54 p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
55 p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
56 p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
57 p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
58 p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
59 p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
60 p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
61 p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
62 p_message_name OUT NOCOPY VARCHAR2 )
63 RETURN BOOLEAN;
64 --
65 -- Validate graduand approval status.
66 FUNCTION grdp_val_gr_gas(
67 p_person_id IN HZ_PARTIES.party_id%TYPE,
68 p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
69 p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
70 p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
71 p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
72 p_message_name OUT NOCOPY VARCHAR2 )
73 RETURN BOOLEAN;
74 --
75 -- Validate system graduand type.
76 FUNCTION GRDP_VAL_GR_TYPE(
77 p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
78 p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
79 p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
80 p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
81 p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
82 p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
83 p_message_name OUT NOCOPY VARCHAR2 )
84 RETURN BOOLEAN;
85 --
86 -- Validate proxy details.
87 FUNCTION grdp_val_gr_proxy(
88 p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
89 p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
90 p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
91 p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
92 p_message_name OUT NOCOPY VARCHAR2 )
93 RETURN BOOLEAN;
94 --
95 -- Check for multiple instances of the same award for the person.
96 FUNCTION grdp_val_gr_unique(
97 p_person_id IN IGS_GR_GRADUAND_ALL.person_id%TYPE ,
98 p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
99 p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
100 p_grd_ci_sequence_num IN NUMBER ,
101 p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
102 p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
103 p_award_cd IN IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
104 p_message_name OUT NOCOPY VARCHAR2 )
105 RETURN BOOLEAN;
106 --
107 -- Validate the update of a graduand with graduand awards ceremonies.
108 FUNCTION grdp_val_gr_upd(
109 p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
110 p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
111 p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
112 p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
113 p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
114 p_message_name OUT NOCOPY VARCHAR2 )
115 RETURN BOOLEAN;
116 --
117 -- Validate inserting or updating a graduand.
118 FUNCTION grdp_val_gr_iu(
119 p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
120 p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
121 p_message_name OUT NOCOPY VARCHAR2 )
122 RETURN BOOLEAN;
123 --
124 -- Validate the graduand has satisfied academic requirements for an award
125 FUNCTION grdp_val_aw_eligible(
126 p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
127 p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
128 p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
129 p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
130 p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
131 p_message_name OUT NOCOPY VARCHAR2 )
132 RETURN BOOLEAN;
133 --
134 -- Validate graduand course award.
135 FUNCTION grdp_val_gr_caw(
136 p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
137 p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
138 p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
139 p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
140 p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
141 p_message_name OUT NOCOPY VARCHAR2 )
142 RETURN BOOLEAN;
143 --
144 -- Validate if graduand approval status is closed.
145 FUNCTION grdp_val_gas_closed(
146 p_graduand_appr_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE ,
147 p_message_name OUT NOCOPY VARCHAR2 )
148 RETURN BOOLEAN;
149 --
150 -- Validate if graduand status is closed.
151 FUNCTION grdp_val_gst_closed(
152 p_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
153 p_message_name OUT NOCOPY VARCHAR2 )
154 RETURN BOOLEAN;
155 --
156 -- Validate if honours level is closed.
157 FUNCTION grdp_val_hl_closed(
158 p_honours_level IN VARCHAR2 DEFAULT NULL,
159 p_message_name OUT NOCOPY VARCHAR2 )
160 RETURN BOOLEAN;
161 --
162 -- Validate graduand surrender for award.
163 FUNCTION GRDP_VAL_GR_SUR_CAW(
164 p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
165 p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
166 p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
167 p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
168 p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
169 p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
170 p_message_name OUT NOCOPY VARCHAR2 )
171 RETURN BOOLEAN;
172 END IGS_GR_VAL_GR;