1 Package ota_resource_booking_swi As
2 /* $Header: ottrbswi.pkh 120.3 2006/03/06 02:30 rdola noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_resource_booking >-----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ota_resource_booking_api.create_resource_booking
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_resource_booking
27 (p_effective_date in date
28 ,p_supplied_resource_id in number
29 ,p_date_booking_placed in date
30 ,p_status in varchar2
31 ,p_event_id in number default null
32 ,p_absolute_price in number default null
33 ,p_booking_person_id in number default null
34 ,p_comments in varchar2 default null
35 ,p_contact_name in varchar2 default null
36 ,p_contact_phone_number in varchar2 default null
37 ,p_delegates_per_unit in number default null
38 ,p_quantity in number default null
39 ,p_required_date_from in date default null
40 ,p_required_date_to in date default null
41 ,p_required_end_time in varchar2 default null
42 ,p_required_start_time in varchar2 default null
43 ,p_deliver_to in varchar2 default null
44 ,p_primary_venue_flag in varchar2 default null
45 ,p_role_to_play in varchar2 default null
46 ,p_trb_information_category in varchar2 default null
47 ,p_trb_information1 in varchar2 default null
48 ,p_trb_information2 in varchar2 default null
49 ,p_trb_information3 in varchar2 default null
50 ,p_trb_information4 in varchar2 default null
51 ,p_trb_information5 in varchar2 default null
52 ,p_trb_information6 in varchar2 default null
53 ,p_trb_information7 in varchar2 default null
54 ,p_trb_information8 in varchar2 default null
55 ,p_trb_information9 in varchar2 default null
56 ,p_trb_information10 in varchar2 default null
57 ,p_trb_information11 in varchar2 default null
58 ,p_trb_information12 in varchar2 default null
59 ,p_trb_information13 in varchar2 default null
60 ,p_trb_information14 in varchar2 default null
61 ,p_trb_information15 in varchar2 default null
62 ,p_trb_information16 in varchar2 default null
63 ,p_trb_information17 in varchar2 default null
64 ,p_trb_information18 in varchar2 default null
65 ,p_trb_information19 in varchar2 default null
66 ,p_trb_information20 in varchar2 default null
67 ,p_display_to_learner_flag in varchar2 default null
68 ,p_book_entire_period_flag in varchar2 default null
69 -- ,p_unbook_request_flag in varchar2 default null
70 ,p_chat_id in number
71 ,p_forum_id in number
72 ,p_validate in number
73 ,p_resource_booking_id in number
74 ,p_object_version_number out nocopy number
75 ,p_return_status out nocopy varchar2
76 ,p_finance_header_id in number default null
77 ,p_currency_code in varchar2 default null
78 ,p_money_amount in number default null
79 ,p_finance_line_id out nocopy number
80 ,p_finance_line_ovn out nocopy NUMBER
81 ,p_timezone_code IN VARCHAR2 DEFAULT NULL
82 );
83 -- ----------------------------------------------------------------------------
84 -- |------------------------< delete_resource_booking >-----------------------|
85 -- ----------------------------------------------------------------------------
86 -- {Start of comments}
87 --
88 -- Description:
89 -- This procedure is the self-service wrapper procedure to the following
90 -- API: ota_resource_booking_api.delete_resource_booking
91 --
92 -- Pre-requisites
93 -- All 'IN' parameters to this procedure have been appropriately derived.
94 --
95 -- Post Success:
96 -- p_return_status will return value indicating success.
97 --
98 -- Post Failure:
99 -- p_return_status will return value indication failure.
100 --
101 -- Access Status:
102 -- Internal Development use only.
103 --
104 -- {End of comments}
105 -- ----------------------------------------------------------------------------
106 PROCEDURE delete_resource_booking
107 (p_resource_booking_id in number
108 ,p_object_version_number in number
109 ,p_validate in number
110 ,p_return_status out nocopy varchar2
111 );
112 -- ----------------------------------------------------------------------------
113 -- |------------------------< update_resource_booking >-----------------------|
114 -- ----------------------------------------------------------------------------
115 -- {Start of comments}
116 --
117 -- Description:
118 -- This procedure is the self-service wrapper procedure to the following
119 -- API: ota_resource_booking_api.update_resource_booking
120 --
121 -- Pre-requisites
122 -- All 'IN' parameters to this procedure have been appropriately derived.
123 --
124 -- Post Success:
125 -- p_return_status will return value indicating success.
126 --
127 -- Post Failure:
128 -- p_return_status will return value indication failure.
129 --
130 -- Access Status:
131 -- Internal Development use only.
132 --
133 -- {End of comments}
134 -- ----------------------------------------------------------------------------
135 PROCEDURE update_resource_booking
136 (p_effective_date in date
137 ,p_supplied_resource_id in number
138 ,p_date_booking_placed in date
139 ,p_status in varchar2
140 ,p_event_id in number default hr_api.g_number
141 ,p_absolute_price in number default hr_api.g_number
142 ,p_booking_person_id in number default hr_api.g_number
143 ,p_comments in varchar2 default hr_api.g_varchar2
144 ,p_contact_name in varchar2 default hr_api.g_varchar2
145 ,p_contact_phone_number in varchar2 default hr_api.g_varchar2
146 ,p_delegates_per_unit in number default hr_api.g_number
147 ,p_quantity in number default hr_api.g_number
148 ,p_required_date_from in date default hr_api.g_date
149 ,p_required_date_to in date default hr_api.g_date
150 ,p_required_end_time in varchar2 default hr_api.g_varchar2
151 ,p_required_start_time in varchar2 default hr_api.g_varchar2
152 ,p_deliver_to in varchar2 default hr_api.g_varchar2
153 ,p_primary_venue_flag in varchar2 default hr_api.g_varchar2
154 ,p_role_to_play in varchar2 default hr_api.g_varchar2
155 ,p_trb_information_category in varchar2 default hr_api.g_varchar2
156 ,p_trb_information1 in varchar2 default hr_api.g_varchar2
157 ,p_trb_information2 in varchar2 default hr_api.g_varchar2
158 ,p_trb_information3 in varchar2 default hr_api.g_varchar2
159 ,p_trb_information4 in varchar2 default hr_api.g_varchar2
160 ,p_trb_information5 in varchar2 default hr_api.g_varchar2
161 ,p_trb_information6 in varchar2 default hr_api.g_varchar2
162 ,p_trb_information7 in varchar2 default hr_api.g_varchar2
163 ,p_trb_information8 in varchar2 default hr_api.g_varchar2
164 ,p_trb_information9 in varchar2 default hr_api.g_varchar2
165 ,p_trb_information10 in varchar2 default hr_api.g_varchar2
166 ,p_trb_information11 in varchar2 default hr_api.g_varchar2
167 ,p_trb_information12 in varchar2 default hr_api.g_varchar2
168 ,p_trb_information13 in varchar2 default hr_api.g_varchar2
169 ,p_trb_information14 in varchar2 default hr_api.g_varchar2
170 ,p_trb_information15 in varchar2 default hr_api.g_varchar2
171 ,p_trb_information16 in varchar2 default hr_api.g_varchar2
172 ,p_trb_information17 in varchar2 default hr_api.g_varchar2
173 ,p_trb_information18 in varchar2 default hr_api.g_varchar2
174 ,p_trb_information19 in varchar2 default hr_api.g_varchar2
175 ,p_trb_information20 in varchar2 default hr_api.g_varchar2
176 ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
177 ,p_book_entire_period_flag in varchar2 default hr_api.g_varchar2
178 -- ,p_unbook_request_flag in varchar2 default hr_api.g_varchar2
179 ,p_chat_id in number
180 ,p_forum_id in number
181 ,p_validate in number
182 ,p_resource_booking_id in number
183 ,p_object_version_number in out nocopy number
184 ,p_return_status out nocopy varchar2
185 ,p_finance_header_id in number default null
186 ,p_currency_code in varchar2 default null
187 ,p_money_amount in number default null
188 ,p_finance_line_id in out nocopy number
189 ,p_finance_line_transfer in varchar2 default null
190 ,p_finance_line_ovn in out nocopy number
191 ,p_cancel_finance_line in varchar2 default null
192 ,p_finance_change_flag in varchar2 default 'N'
193 ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
194 );
195 --
196 -- ----------------------------------------------------------------------------
197 -- |-----------------------< check_trainer_competence >-----------------------|
198 -- ----------------------------------------------------------------------------
199 -- {Start of comments}
200 --
201 -- Description:
202 -- This procedure is the self-service wrapper procedure to the following
203 -- API: ota_resource_booking_api_procedures.check_trainer_competence
204 --
205 -- Pre-requisites
206 --
207 -- Post Success:
208 --
209 -- Post Failure:
210 --
211 -- Access Status:
212 --
213 -- {End of comments}
214 -- ----------------------------------------------------------------------------
215 procedure check_trainer_competence
216 (p_event_id in number
217 ,p_supplied_resource_id in number
218 ,p_required_date_from in date
219 ,p_required_date_to in date
220 ,p_warning out nocopy varchar2
221 );
222 --
223 -- ----------------------------------------------------------------------------
224 -- |-------------------------< check_double_booking >-------------------------|
225 -- ----------------------------------------------------------------------------
226 -- {Start of comments}
227 --
228 -- Description:
229 -- This procedure is the self-service wrapper procedure to the following
230 -- API: ota_resource_booking_api_procedures.check_double_booking
231 --
232 -- Pre-requisites
233 --
234 -- Post Success:
235 --
236 -- Post Failure:
237 --
238 -- Access Status:
239 --
240 -- {End of comments}
241 -- ----------------------------------------------------------------------------
242 procedure check_double_booking
243 (p_supplied_resource_id in number
244 ,p_required_date_from in date
245 ,p_required_start_time in varchar2
246 ,p_required_date_to in date
247 ,p_required_end_time in varchar2
248 ,p_resource_booking_id in number
249 ,p_book_entire_period_flag in varchar2
250 ,p_warning out nocopy VARCHAR2
251 ,p_timezone_code IN VARCHAR2
252 );
253 --
254 end ota_resource_booking_swi;