[Home] [Help]
PACKAGE: APPS.IGS_GE_VAL_PARAM
Source
1 Package IGS_GE_VAL_PARAM AS
2 /* $Header: IGSGE08S.pls 120.1 2005/09/30 04:12:32 appldev ship $ */
3
4 -- Module: repp_val_unit_cd
5 -- Purpose: validation for IGS_PS_UNIT code
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- --------- -------- ------------------------------------------
10 -- MSONTER 21/08/98 Initial creation of function
11 FUNCTION repp_val_unit_cd(p_unit_cd IN OUT NOCOPY IGS_PS_UNIT_VER_ALL.unit_cd%TYPE,
12 p_msg_name OUT NOCOPY VARCHAR2)
13 RETURN BOOLEAN;
14
15 -- Module: repp_val_location
16 -- Purpose: validation for IGS_AD_LOCATION codes
17 --
18 -- MODIFICATION HISTORY
19 -- PERSON Date Comments
20 -- --------- -------- ------------------------------------------
21 -- MSONTER 21/08/98 Initial creation of function
22 FUNCTION repp_val_location(p_location_cd IN OUT NOCOPY IGS_AD_LOCATION_ALL.location_cd%TYPE,
23 p_msg_name OUT NOCOPY VARCHAR2)
24 RETURN BOOLEAN;
25
26 -- Module: repp_val_att_mode
27 -- Purpose: validation for attendance mode
28 --
29 -- MODIFICATION HISTORY
30 -- PERSON Date Comments
31 -- --------- -------- ------------------------------------------
32 -- MSONTER 21/08/98 Initial creation of function
33 FUNCTION repp_val_att_mode(p_att_mode IN OUT NOCOPY IGS_EN_ATD_MODE_ALL.attendance_mode%TYPE,
34 p_msg_name OUT NOCOPY VARCHAR2)
35 RETURN BOOLEAN;
36
37 -- Module: repp_val_att_type
38 -- Purpose: validation for attendance type
39 --
40 -- MODIFICATION HISTORY
41 -- PERSON Date Comments
42 -- --------- -------- ------------------------------------------
43 -- MSONTER 21/08/98 Initial creation of function
44 FUNCTION repp_val_att_type(p_att_type IN OUT NOCOPY IGS_EN_ATD_TYPE_ALL.attendance_type%TYPE,
45 p_msg_name OUT NOCOPY VARCHAR2)
46 RETURN BOOLEAN;
47
48 -- Module: repp_val_unit_class
49 -- -- Purpose: validation for location codes
50 --
51 -- MODIFICATION HISTORY
52 -- PERSON Date Comments
53 -- --------- -------- ------------------------------------------
54 -- MSONTER 21/08/98 Initial creation of function
55 FUNCTION repp_val_unit_class(p_unit_class IN OUT NOCOPY IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,
56 p_msg_name OUT NOCOPY VARCHAR2)
57 RETURN BOOLEAN;
58
59 -- Module: repp_val_unit_mode
60 -- Purpose: validation for IGS_PS_UNIT mode
61 --
62 -- MODIFICATION HISTORY
63 -- PERSON Date Comments
64 -- --------- -------- ------------------------------------------
65 -- MSONTER 21/08/98 Initial creation of function
66 FUNCTION repp_val_unit_mode(p_unit_mode IN OUT NOCOPY IGS_AS_UNIT_MODE.unit_mode%TYPE,
67 p_msg_name OUT NOCOPY VARCHAR2)
68 RETURN BOOLEAN;
69
70 -- Module: repp_val_crs_type
71 -- Purpose: validation for IGS_PS_COURSE types
72 --
73 -- MODIFICATION HISTORY
74 -- PERSON Date Comments
75 -- --------- -------- ------------------------------------------
76 -- MSONTER 21/08/98 Initial creation of function
77 FUNCTION repp_val_crs_type(p_crs_type IN OUT NOCOPY IGS_PS_TYPE_ALL.course_type%TYPE,
78 p_msg_name OUT NOCOPY VARCHAR2)
79 RETURN BOOLEAN;
80
81 -- Module: repp_val_enr_cat
82 -- Purpose: validation for enrolment category
83 --
84 -- MODIFICATION HISTORY
85 -- PERSON Date Comments
86 -- --------- -------- ------------------------------------------
87 -- MSONTER 21/08/98 Initial creation of function
88 FUNCTION repp_val_enr_cat(p_enr_cat IN OUT NOCOPY IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE,
89 p_msg_name OUT NOCOPY VARCHAR2)
90 RETURN BOOLEAN;
91
92 -- Module: repp_val_adm_cat
93 -- Purpose: validation for admission categories
94 --
95 -- MODIFICATION HISTORY
96 -- PERSON Date Comments
97 -- --------- -------- ------------------------------------------
98 -- MSONTER 21/08/98 Initial creation of function
99 FUNCTION repp_val_adm_cat(p_adm_cat IN OUT NOCOPY IGS_AD_CAT.admission_cat%TYPE,
100 p_msg_name OUT NOCOPY VARCHAR2)
101 RETURN BOOLEAN;
102
103 -- Module: repp_val_fee_cat
104 -- Purpose: validation for fee categories
105 --
106 -- MODIFICATION HISTORY
107 -- PERSON Date Comments
108 -- --------- -------- ------------------------------------------
109 -- MSONTER 21/08/98 Initial creation of function
110 FUNCTION repp_val_fee_cat(p_fee_cat IN OUT NOCOPY IGS_FI_FEE_CAT_ALL.fee_cat%TYPE,
111 p_msg_name OUT NOCOPY VARCHAR2)
112 RETURN BOOLEAN;
113
114 -- Module: repp_val_unit_cal
115 -- -- Purpose: validation for unit class
116 -- teaching calendars
117 --
118 -- MODIFICATION HISTORY
119 -- PERSON Date Comments
120 -- --------- -------- ------------------------------------------
121 -- MSONTER 21/08/98 Initial creation of function
122 FUNCTION repp_val_unit_cal( p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE,
123 p_ass_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE,
124 p_ass_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
125 p_teach_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE,
126 p_teach_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
127 p_msg_name OUT NOCOPY VARCHAR2)
128 RETURN BOOLEAN;
129
130 -- Module: repp_val_unit_mode_class
131 -- Purpose: validation for UNIT mode and class parameters
132 --
133 -- MODIFICATION HISTORY
134 -- PERSON Date Comments
135 -- --------- -------- ------------------------------------------
136 -- MSONTER 21/08/98 Initial creation of function
137 FUNCTION repp_val_unit_mode_class( p_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE,
138 p_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,
139 p_msg_name OUT NOCOPY VARCHAR2)
140 RETURN BOOLEAN;
141
142 -- Module: repp_val_course
143 -- Purpose: validation for course types
144 --
145 -- MODIFICATION HISTORY
146 -- PERSON Date Comments
147 -- --------- -------- ------------------------------------------
148 -- MSONTER 21/08/98 Initial creation of function
149 FUNCTION repp_val_course( p_course_cd IN OUT NOCOPY IGS_PS_VER_ALL.course_cd%TYPE,
150 p_msg_name OUT NOCOPY VARCHAR2)
151 RETURN BOOLEAN;
152
153 -- Module: repp_val_ass
154 -- Purpose: validation for assessment item
155 --
156 -- MODIFICATION HISTORY
157 -- PERSON Date Comments
158 -- --------- -------- ------------------------------------------
159 -- MSONTER 21/08/98 Initial creation of function
160 FUNCTION repp_val_ass( p_ass_id IN VARCHAR2,
161 p_ass_desc OUT NOCOPY VARCHAR2,
162 p_msg_name OUT NOCOPY VARCHAR2)
163 RETURN BOOLEAN;
164
165 -- Module: repp_get_curr_cal
166 -- Purpose: return of current calendar for given SI_CA_S_CA_CAT
167 --
168 -- MODIFICATION HISTORY
169 -- PERSON Date Comments
170 -- --------- -------- ------------------------------------------
171 -- MSONTER 27/08/98 Initial creation of function
172 FUNCTION repp_get_curr_cal( p_s_cal_cat IN IGS_CA_TYPE.s_cal_cat%TYPE,
173 p_cal OUT NOCOPY VARCHAR2)
174 RETURN BOOLEAN;
175
176 -- Module: repp_get_nomin_cal
177 -- Purpose: return of nominated calendar for given IGS_CA_TYPE/sequence_number
178 --
179 -- MODIFICATION HISTORY
180 -- PERSON Date Comments
181 -- --------- -------- ------------------------------------------
182 -- MSONTER 27/08/98 Initial creation of function
183 FUNCTION repp_get_nomin_cal( p_cal_type IN IGS_CA_TYPE.cal_type%TYPE,
184 p_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE,
185 p_cal OUT NOCOPY VARCHAR2)
186 RETURN BOOLEAN;
187 --pragma RESTRICT_REFERENCES (repp_get_nomin_cal,WNDS);
188
189 -- Module: repp_get_cal_str
190 -- Purpose: return of nominated calendar for given IGS_CA_TYPE/sequence_number
191 --
192 -- MODIFICATION HISTORY
193 -- PERSON Date Comments
194 -- --------- -------- ------------------------------------------
195 -- MSONTER 28/08/98 Initial creation of function
196 FUNCTION repp_get_cal_str(p_cal_type IN IGS_CA_TYPE.cal_type%TYPE,
197 p_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE)
198 RETURN VARCHAR2;
199
200 -- Module: repp_val_org_cd
201 -- Purpose: validation of org IGS_PS_UNITs
202 --
203 -- MODIFICATION HISTORY
204 -- PERSON Date Comments
205 -- --------- -------- ------------------------------------------
206 -- MSONTER 28/08/98 Initial creation of function
207 FUNCTION repp_val_org_cd(p_org_cd IN OUT NOCOPY HZ_PARTIES.party_number%TYPE,
208 p_msg_name OUT NOCOPY VARCHAR2)
209 RETURN BOOLEAN;
210
211 --
212 -- Pragma Declarations
213 --pragma RESTRICT_REFERENCES (repp_get_cal_str, WNDS);
214 END IGS_GE_VAL_PARAM;