1 PACKAGE OTA_BOOKING_STATUS_TYPE_API AUTHID CURRENT_USER as
2 /* $Header: otbstapi.pkh 120.2 2006/08/30 06:58:23 niarora noship $ */
3 /*#
4 * This package contains Enrollment status APIs.
5 * @rep:scope public
6 * @rep:product OTA
7 * @rep:displayname Enrollment Status
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< create_booking_status_type >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates an Enrollment status.
17 *
18 *
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with Learning Management.
21 *
22 * <p><b>Prerequisites</b><br>
23 * Business Group record must exist.
24 *
25 * <p><b>Post Success</b><br>
26 * The Enrollment status section was created successfully.
27 *
28 * <p><b>Post Failure</b><br>
29 * The API did not create an Enrollment status record and raised an error.
30 *
31 * @param p_validate If true, then validation alone will be performed and the
32 * database will remain unchanged. If false and all validation checks pass,
33 * then the database will be modified.
34 * @param p_effective_date Reference date for validating that lookup values are
35 * applicable during the start-to-end active date range. This date does
36 * not determine when the changes take effect.
37 * @param p_business_group_id The business group owning the Enrollment status.
38 * @param p_active_flag The flag indicating whether the booking status type
39 * is active or not; permissible values Y and N.
40 * @param p_default_flag The default flag for the Enrollment status.
41 * Permissible values Y and N.
42 * @param p_name The name of the Enrollment status.
43 * @param p_type Enrollment type. Valid values are defined by the
44 * 'DELEGATE_BOOKING_STATUS' lookup type.
45 * @param p_place_used_flag An indication of whether the status implies that
46 * a place on an event has been allocated.
47 * @param p_comments Comment text.
48 * @param p_description The description of the Enrollment status.
49 * @param p_bst_information_category This context value determines which flexfield structure to
50 * use with the descriptive flexfield segments.
51 * @param p_bst_information1 Descriptive flexfield segment.
52 * @param p_bst_information2 Descriptive flexfield segment.
53 * @param p_bst_information3 Descriptive flexfield segment.
54 * @param p_bst_information4 Descriptive flexfield segment.
55 * @param p_bst_information5 Descriptive flexfield segment.
56 * @param p_bst_information6 Descriptive flexfield segment.
57 * @param p_bst_information7 Descriptive flexfield segment.
58 * @param p_bst_information8 Descriptive flexfield segment.
59 * @param p_bst_information9 Descriptive flexfield segment.
60 * @param p_bst_information10 Descriptive flexfield segment.
61 * @param p_bst_information11 Descriptive flexfield segment.
62 * @param p_bst_information12 Descriptive flexfield segment.
63 * @param p_bst_information13 Descriptive flexfield segment.
64 * @param p_bst_information14 Descriptive flexfield segment.
65 * @param p_bst_information15 Descriptive flexfield segment.
66 * @param p_bst_information16 Descriptive flexfield segment.
67 * @param p_bst_information17 Descriptive flexfield segment.
68 * @param p_bst_information18 Descriptive flexfield segment.
69 * @param p_bst_information19 Descriptive flexfield segment.
70 * @param p_bst_information20 Descriptive flexfield segment.
71 * @param p_object_version_number If p_validate is false, then set to the
72 * version number of the created Enrollment status. If p_validate is true,
73 * then the value will be null.
74 * @param p_booking_status_type_id The unique identifier for this Enrollment status.
75 * @rep:displayname Create Enrollment Status
76 * @rep:category BUSINESS_ENTITY OTA_ENROLLMENT_STATUS_TYPE
77 * @rep:lifecycle active
78 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
79 * @rep:scope public
80 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
81 */
82 --
83 -- {End Of Comments}
84 --
85 procedure CREATE_BOOKING_STATUS_TYPE
86 (p_validate in boolean default false
87 ,p_effective_date in date
88 ,p_business_group_id in number
89 ,p_active_flag in varchar2 default null
90 ,p_default_flag in varchar2 default null
91 ,p_name in varchar2 default null
92 ,p_type in varchar2 default null
93 ,p_place_used_flag in varchar2 default null
94 ,p_comments in varchar2 default null
95 ,p_description in varchar2 default null
96 ,p_bst_information_category in varchar2 default null
97 ,p_bst_information1 in varchar2 default null
98 ,p_bst_information2 in varchar2 default null
99 ,p_bst_information3 in varchar2 default null
100 ,p_bst_information4 in varchar2 default null
101 ,p_bst_information5 in varchar2 default null
102 ,p_bst_information6 in varchar2 default null
103 ,p_bst_information7 in varchar2 default null
104 ,p_bst_information8 in varchar2 default null
105 ,p_bst_information9 in varchar2 default null
106 ,p_bst_information10 in varchar2 default null
107 ,p_bst_information11 in varchar2 default null
108 ,p_bst_information12 in varchar2 default null
109 ,p_bst_information13 in varchar2 default null
110 ,p_bst_information14 in varchar2 default null
111 ,p_bst_information15 in varchar2 default null
112 ,p_bst_information16 in varchar2 default null
113 ,p_bst_information17 in varchar2 default null
114 ,p_bst_information18 in varchar2 default null
115 ,p_bst_information19 in varchar2 default null
116 ,p_bst_information20 in varchar2 default null
117 ,p_object_version_number out nocopy number
118 ,p_booking_status_type_id out nocopy number
119 -- ,p_data_source in varchar2 default null
120 );
121 --
122 -- ----------------------------------------------------------------------------
123 -- |------------------------< update_booking_status_type >--------------------|
124 -- ----------------------------------------------------------------------------
125 --
126 -- {Start Of Comments}
127 /*#
128 * This API updates the Enrollment status.
129 *
130 *
131 * <p><b>Licensing</b><br>
132 * This API is licensed for use with Learning Management.
133 *
134 * <p><b>Prerequisites</b><br>
135 * Enrollment status record with the given object version number should exist.
136 *
137 * <p><b>Post Success</b><br>
138 * The Enrollment status section was updated successfully.
139 *
140 * <p><b>Post Failure</b><br>
141 * The API did not update the Enrollment status record and raised an error.
142 *
143 * @param p_validate If true, then validation alone will be performed and the
144 * database will remain unchanged. If false and all validation checks pass,
145 * then the database will be modified.
146 * @param p_effective_date Reference date for validating that lookup values are applicable
147 * during the start-to-end active date range. This date does not determine when
148 * the changes take effect.
149 * @param p_business_group_id The business group owning the Enrollment status.
150 * @param p_active_flag The flag indicating whether the booking status type is active or not.
151 * Permissible values Y and N.
152 * @param p_default_flag The default flag for the Enrollment status. Permissible values Y and N.
153 * @param p_name The name of the Enrollment status.
154 * @param p_type Enrollment type. Valid values are defined by the 'DELEGATE_BOOKING_STATUS' lookup type.
155 * @param p_place_used_flag Indicates whether the status implies that a place on an event has been allocated.
156 * @param p_comments Comment text.
157 * @param p_description The description of the Enrollment status.
158 * @param p_bst_information_category This context value determines which flexfield structure
159 * to use with the descriptive flexfield segments.
160 * @param p_bst_information1 Descriptive flexfield segment.
161 * @param p_bst_information2 Descriptive flexfield segment.
162 * @param p_bst_information3 Descriptive flexfield segment.
163 * @param p_bst_information4 Descriptive flexfield segment.
164 * @param p_bst_information5 Descriptive flexfield segment.
165 * @param p_bst_information6 Descriptive flexfield segment.
166 * @param p_bst_information7 Descriptive flexfield segment.
167 * @param p_bst_information8 Descriptive flexfield segment.
168 * @param p_bst_information9 Descriptive flexfield segment.
169 * @param p_bst_information10 Descriptive flexfield segment.
170 * @param p_bst_information11 Descriptive flexfield segment.
171 * @param p_bst_information12 Descriptive flexfield segment.
172 * @param p_bst_information13 Descriptive flexfield segment.
173 * @param p_bst_information14 Descriptive flexfield segment.
174 * @param p_bst_information15 Descriptive flexfield segment.
175 * @param p_bst_information16 Descriptive flexfield segment.
176 * @param p_bst_information17 Descriptive flexfield segment.
177 * @param p_bst_information18 Descriptive flexfield segment.
178 * @param p_bst_information19 Descriptive flexfield segment.
179 * @param p_bst_information20 Descriptive flexfield segment.
180 * @param p_booking_status_type_id The unique identifier for this Enrollment status.
181 * @param p_object_version_number If p_validate is false, then set to the version number of the created
182 * Enrollment status. If p_validate is true, then the value will be null.
183 * @rep:displayname Update Enrollment Status
184 * @rep:category BUSINESS_ENTITY OTA_ENROLLMENT_STATUS_TYPE
185 * @rep:lifecycle active
186 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
187 * @rep:scope public
188 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
189 */
190 --
191 -- {End Of Comments}
192 --
193 procedure UPDATE_BOOKING_STATUS_TYPE
194 (p_validate in boolean default false
195 ,p_effective_date in date
196 ,p_business_group_id in number
197 ,p_active_flag in varchar2 default hr_api.g_varchar2
198 ,p_default_flag in varchar2 default hr_api.g_varchar2
199 ,p_name in varchar2 default hr_api.g_varchar2
200 ,p_type in varchar2 default hr_api.g_varchar2
201 ,p_place_used_flag in varchar2 default hr_api.g_varchar2
202 ,p_comments in varchar2 default hr_api.g_varchar2
203 ,p_description in varchar2 default hr_api.g_varchar2
204 ,p_bst_information_category in varchar2 default hr_api.g_varchar2
205 ,p_bst_information1 in varchar2 default hr_api.g_varchar2
206 ,p_bst_information2 in varchar2 default hr_api.g_varchar2
207 ,p_bst_information3 in varchar2 default hr_api.g_varchar2
208 ,p_bst_information4 in varchar2 default hr_api.g_varchar2
209 ,p_bst_information5 in varchar2 default hr_api.g_varchar2
210 ,p_bst_information6 in varchar2 default hr_api.g_varchar2
211 ,p_bst_information7 in varchar2 default hr_api.g_varchar2
212 ,p_bst_information8 in varchar2 default hr_api.g_varchar2
213 ,p_bst_information9 in varchar2 default hr_api.g_varchar2
217 ,p_bst_information13 in varchar2 default hr_api.g_varchar2
214 ,p_bst_information10 in varchar2 default hr_api.g_varchar2
215 ,p_bst_information11 in varchar2 default hr_api.g_varchar2
216 ,p_bst_information12 in varchar2 default hr_api.g_varchar2
218 ,p_bst_information14 in varchar2 default hr_api.g_varchar2
219 ,p_bst_information15 in varchar2 default hr_api.g_varchar2
220 ,p_bst_information16 in varchar2 default hr_api.g_varchar2
221 ,p_bst_information17 in varchar2 default hr_api.g_varchar2
222 ,p_bst_information18 in varchar2 default hr_api.g_varchar2
223 ,p_bst_information19 in varchar2 default hr_api.g_varchar2
224 ,p_bst_information20 in varchar2 default hr_api.g_varchar2
225 ,p_booking_status_type_id in number default hr_api.g_number
226 ,p_object_version_number in out nocopy number
227 -- ,p_data_source in varchar2 default hr_api.g_varchar2
228 );
229 --
230 -- ----------------------------------------------------------------------------
231 -- |------------------------< delete_booking_status_type >--------------------|
232 -- ----------------------------------------------------------------------------
233 --
234 -- {Start Of Comments}
235 /*#
236 * This API deletes the Enrollment status.
237 *
238 *
239 * <p><b>Licensing</b><br>
240 * This API is licensed for use with Learning Management.
241 *
242 * <p><b>Prerequisites</b><br>
243 * Enrollment status record with the given object version number should exist.
244 *
245 * <p><b>Post Success</b><br>
246 * The Enrollment status section is deleted successfully.
247 *
248 * <p><b>Post Failure</b><br>
249 * The API does not delete a Enrollment status record and raises an error.
250 *
251 * @param p_validate If true, then validation alone will be performed and the
252 * database will remain unchanged. If false and all validation checks pass,
253 * then the database will be modified.
254 * @param p_booking_status_type_id The unique identifier for this Enrollment status.
255 * @param p_object_version_number If p_validate is false, then set to the version
256 * number of the created Enrollment status. If p_validate is true, then the value will be null.
257 * @rep:displayname Delete Enrollment Status
258 * @rep:category BUSINESS_ENTITY OTA_ENROLLMENT_STATUS_TYPE
259 * @rep:lifecycle active
260 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
261 * @rep:scope public
262 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
263 */
264 --
265 -- {End Of Comments}
266 --
267
268 procedure DELETE_BOOKING_STATUS_TYPE
269 (p_validate in boolean default false
270 ,p_booking_status_type_id in number
271 ,p_object_version_number in number
272 );
273
274 end ota_BOOKING_STATUS_TYPE_api;