APPS.OTA_BOOKING_STATUS_TYPE_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |----------------------< create_booking_status_type >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_booking_status_type
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_business_group_id in number
15: ,p_active_flag in varchar2 default null
16: ,p_default_flag in varchar2 default null

Line 74: hr_api.constant_to_boolean

70: --
71: -- Convert constant values to their corresponding boolean value
72: --
73: l_validate :=
74: hr_api.constant_to_boolean
75: (p_constant_value => p_validate);
76: --
77: -- Register Surrogate ID or user key values
78: --

Line 174: (p_validate in number default hr_api.g_false_num

170: -- ----------------------------------------------------------------------------
171: -- |----------------------< update_booking_status_type >----------------------|
172: -- ----------------------------------------------------------------------------
173: PROCEDURE update_booking_status_type
174: (p_validate in number default hr_api.g_false_num
175: ,p_effective_date in date
176: ,p_business_group_id in number
177: ,p_active_flag in varchar2 default hr_api.g_varchar2
178: ,p_default_flag in varchar2 default hr_api.g_varchar2

Line 177: ,p_active_flag in varchar2 default hr_api.g_varchar2

173: PROCEDURE update_booking_status_type
174: (p_validate in number default hr_api.g_false_num
175: ,p_effective_date in date
176: ,p_business_group_id in number
177: ,p_active_flag in varchar2 default hr_api.g_varchar2
178: ,p_default_flag in varchar2 default hr_api.g_varchar2
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2

Line 178: ,p_default_flag in varchar2 default hr_api.g_varchar2

174: (p_validate in number default hr_api.g_false_num
175: ,p_effective_date in date
176: ,p_business_group_id in number
177: ,p_active_flag in varchar2 default hr_api.g_varchar2
178: ,p_default_flag in varchar2 default hr_api.g_varchar2
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
182: ,p_comments in varchar2 default hr_api.g_varchar2

Line 179: ,p_name in varchar2 default hr_api.g_varchar2

175: ,p_effective_date in date
176: ,p_business_group_id in number
177: ,p_active_flag in varchar2 default hr_api.g_varchar2
178: ,p_default_flag in varchar2 default hr_api.g_varchar2
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
182: ,p_comments in varchar2 default hr_api.g_varchar2
183: ,p_description in varchar2 default hr_api.g_varchar2

Line 180: ,p_type in varchar2 default hr_api.g_varchar2

176: ,p_business_group_id in number
177: ,p_active_flag in varchar2 default hr_api.g_varchar2
178: ,p_default_flag in varchar2 default hr_api.g_varchar2
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
182: ,p_comments in varchar2 default hr_api.g_varchar2
183: ,p_description in varchar2 default hr_api.g_varchar2
184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2

Line 181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2

177: ,p_active_flag in varchar2 default hr_api.g_varchar2
178: ,p_default_flag in varchar2 default hr_api.g_varchar2
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
182: ,p_comments in varchar2 default hr_api.g_varchar2
183: ,p_description in varchar2 default hr_api.g_varchar2
184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2

Line 182: ,p_comments in varchar2 default hr_api.g_varchar2

178: ,p_default_flag in varchar2 default hr_api.g_varchar2
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
182: ,p_comments in varchar2 default hr_api.g_varchar2
183: ,p_description in varchar2 default hr_api.g_varchar2
184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2

Line 183: ,p_description in varchar2 default hr_api.g_varchar2

179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
182: ,p_comments in varchar2 default hr_api.g_varchar2
183: ,p_description in varchar2 default hr_api.g_varchar2
184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2

Line 184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2

180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
182: ,p_comments in varchar2 default hr_api.g_varchar2
183: ,p_description in varchar2 default hr_api.g_varchar2
184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2

Line 185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2

181: ,p_place_used_flag in varchar2 default hr_api.g_varchar2
182: ,p_comments in varchar2 default hr_api.g_varchar2
183: ,p_description in varchar2 default hr_api.g_varchar2
184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2

Line 186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2

182: ,p_comments in varchar2 default hr_api.g_varchar2
183: ,p_description in varchar2 default hr_api.g_varchar2
184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2

Line 187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2

183: ,p_description in varchar2 default hr_api.g_varchar2
184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2

Line 188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2

184: ,p_bst_information_category in varchar2 default hr_api.g_varchar2
185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2

Line 189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2

185: ,p_bst_information1 in varchar2 default hr_api.g_varchar2
186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2

Line 190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2

186: ,p_bst_information2 in varchar2 default hr_api.g_varchar2
187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2

Line 191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2

187: ,p_bst_information3 in varchar2 default hr_api.g_varchar2
188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2

Line 192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2

188: ,p_bst_information4 in varchar2 default hr_api.g_varchar2
189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2

Line 193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2

189: ,p_bst_information5 in varchar2 default hr_api.g_varchar2
190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2

Line 194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2

190: ,p_bst_information6 in varchar2 default hr_api.g_varchar2
191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2

Line 195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2

191: ,p_bst_information7 in varchar2 default hr_api.g_varchar2
192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2

Line 196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2

192: ,p_bst_information8 in varchar2 default hr_api.g_varchar2
193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2

Line 197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2

193: ,p_bst_information9 in varchar2 default hr_api.g_varchar2
194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2

Line 198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2

194: ,p_bst_information10 in varchar2 default hr_api.g_varchar2
195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
202: ,p_bst_information18 in varchar2 default hr_api.g_varchar2

Line 199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2

195: ,p_bst_information11 in varchar2 default hr_api.g_varchar2
196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
202: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
203: ,p_bst_information19 in varchar2 default hr_api.g_varchar2

Line 200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2

196: ,p_bst_information12 in varchar2 default hr_api.g_varchar2
197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
202: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
203: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
204: ,p_bst_information20 in varchar2 default hr_api.g_varchar2

Line 201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2

197: ,p_bst_information13 in varchar2 default hr_api.g_varchar2
198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
202: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
203: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
204: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
205: ,p_booking_status_type_id in number default hr_api.g_number

Line 202: ,p_bst_information18 in varchar2 default hr_api.g_varchar2

198: ,p_bst_information14 in varchar2 default hr_api.g_varchar2
199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
202: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
203: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
204: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
205: ,p_booking_status_type_id in number default hr_api.g_number
206: ,p_object_version_number in out nocopy number

Line 203: ,p_bst_information19 in varchar2 default hr_api.g_varchar2

199: ,p_bst_information15 in varchar2 default hr_api.g_varchar2
200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
202: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
203: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
204: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
205: ,p_booking_status_type_id in number default hr_api.g_number
206: ,p_object_version_number in out nocopy number
207: -- ,p_data_source in varchar2 default hr_api.g_varchar2

Line 204: ,p_bst_information20 in varchar2 default hr_api.g_varchar2

200: ,p_bst_information16 in varchar2 default hr_api.g_varchar2
201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
202: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
203: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
204: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
205: ,p_booking_status_type_id in number default hr_api.g_number
206: ,p_object_version_number in out nocopy number
207: -- ,p_data_source in varchar2 default hr_api.g_varchar2
208: ,p_return_status out nocopy varchar2

Line 205: ,p_booking_status_type_id in number default hr_api.g_number

201: ,p_bst_information17 in varchar2 default hr_api.g_varchar2
202: ,p_bst_information18 in varchar2 default hr_api.g_varchar2
203: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
204: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
205: ,p_booking_status_type_id in number default hr_api.g_number
206: ,p_object_version_number in out nocopy number
207: -- ,p_data_source in varchar2 default hr_api.g_varchar2
208: ,p_return_status out nocopy varchar2
209: ) is

Line 207: -- ,p_data_source in varchar2 default hr_api.g_varchar2

203: ,p_bst_information19 in varchar2 default hr_api.g_varchar2
204: ,p_bst_information20 in varchar2 default hr_api.g_varchar2
205: ,p_booking_status_type_id in number default hr_api.g_number
206: ,p_object_version_number in out nocopy number
207: -- ,p_data_source in varchar2 default hr_api.g_varchar2
208: ,p_return_status out nocopy varchar2
209: ) is
210: --
211: -- Variables for API Boolean parameters

Line 237: hr_api.constant_to_boolean

233: --
234: -- Convert constant values to their corresponding boolean value
235: --
236: l_validate :=
237: hr_api.constant_to_boolean
238: (p_constant_value => p_validate);
239: --
240: -- Register Surrogate ID or user key values
241: --

Line 334: (p_validate in number default hr_api.g_false_num

330: -- ----------------------------------------------------------------------------
331: -- |----------------------< delete_booking_status_type >----------------------|
332: -- ----------------------------------------------------------------------------
333: PROCEDURE delete_booking_status_type
334: (p_validate in number default hr_api.g_false_num
335: ,p_booking_status_type_id in number
336: ,p_object_version_number in number
337: ,p_return_status out nocopy varchar2
338: ) is

Line 364: hr_api.constant_to_boolean

360: --
361: -- Convert constant values to their corresponding boolean value
362: --
363: l_validate :=
364: hr_api.constant_to_boolean
365: (p_constant_value => p_validate);
366: --
367: -- Register Surrogate ID or user key values
368: --