eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_RESOURCE_USAGE_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< create_resource >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_resource
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_activity_version_id in number default null
15: ,p_required_flag in varchar2
16: ,p_start_date in date

Line 76: hr_api.constant_to_boolean

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

Line 178: (p_validate in number default hr_api.g_false_num

174: -- ----------------------------------------------------------------------------
175: -- |----------------------------< delete_resource >---------------------------|
176: -- ----------------------------------------------------------------------------
177: PROCEDURE delete_resource
178: (p_validate in number default hr_api.g_false_num
179: ,p_resource_usage_id in number
180: ,p_object_version_number in number
181: ,p_return_status out nocopy varchar2
182: ) is

Line 208: hr_api.constant_to_boolean

204: --
205: -- Convert constant values to their corresponding boolean value
206: --
207: l_validate :=
208: hr_api.constant_to_boolean
209: (p_constant_value => p_validate);
210: --
211: -- Register Surrogate ID or user key values
212: --

Line 272: (p_validate in number default hr_api.g_false_num

268: -- ----------------------------------------------------------------------------
269: -- |----------------------------< update_resource >---------------------------|
270: -- ----------------------------------------------------------------------------
271: PROCEDURE update_resource
272: (p_validate in number default hr_api.g_false_num
273: ,p_effective_date in date
274: ,p_resource_usage_id in number
275: ,p_object_version_number in out nocopy number
276: ,p_activity_version_id in number default hr_api.g_number

Line 276: ,p_activity_version_id in number default hr_api.g_number

272: (p_validate in number default hr_api.g_false_num
273: ,p_effective_date in date
274: ,p_resource_usage_id in number
275: ,p_object_version_number in out nocopy number
276: ,p_activity_version_id in number default hr_api.g_number
277: ,p_required_flag in varchar2 default hr_api.g_varchar2
278: ,p_start_date in date default hr_api.g_date
279: ,p_supplied_resource_id in number default hr_api.g_number
280: ,p_comments in varchar2 default hr_api.g_varchar2

Line 277: ,p_required_flag in varchar2 default hr_api.g_varchar2

273: ,p_effective_date in date
274: ,p_resource_usage_id in number
275: ,p_object_version_number in out nocopy number
276: ,p_activity_version_id in number default hr_api.g_number
277: ,p_required_flag in varchar2 default hr_api.g_varchar2
278: ,p_start_date in date default hr_api.g_date
279: ,p_supplied_resource_id in number default hr_api.g_number
280: ,p_comments in varchar2 default hr_api.g_varchar2
281: ,p_end_date in date default hr_api.g_date

Line 278: ,p_start_date in date default hr_api.g_date

274: ,p_resource_usage_id in number
275: ,p_object_version_number in out nocopy number
276: ,p_activity_version_id in number default hr_api.g_number
277: ,p_required_flag in varchar2 default hr_api.g_varchar2
278: ,p_start_date in date default hr_api.g_date
279: ,p_supplied_resource_id in number default hr_api.g_number
280: ,p_comments in varchar2 default hr_api.g_varchar2
281: ,p_end_date in date default hr_api.g_date
282: ,p_quantity in number default hr_api.g_number

Line 279: ,p_supplied_resource_id in number default hr_api.g_number

275: ,p_object_version_number in out nocopy number
276: ,p_activity_version_id in number default hr_api.g_number
277: ,p_required_flag in varchar2 default hr_api.g_varchar2
278: ,p_start_date in date default hr_api.g_date
279: ,p_supplied_resource_id in number default hr_api.g_number
280: ,p_comments in varchar2 default hr_api.g_varchar2
281: ,p_end_date in date default hr_api.g_date
282: ,p_quantity in number default hr_api.g_number
283: ,p_resource_type in varchar2 default hr_api.g_varchar2

Line 280: ,p_comments in varchar2 default hr_api.g_varchar2

276: ,p_activity_version_id in number default hr_api.g_number
277: ,p_required_flag in varchar2 default hr_api.g_varchar2
278: ,p_start_date in date default hr_api.g_date
279: ,p_supplied_resource_id in number default hr_api.g_number
280: ,p_comments in varchar2 default hr_api.g_varchar2
281: ,p_end_date in date default hr_api.g_date
282: ,p_quantity in number default hr_api.g_number
283: ,p_resource_type in varchar2 default hr_api.g_varchar2
284: ,p_role_to_play in varchar2 default hr_api.g_varchar2

Line 281: ,p_end_date in date default hr_api.g_date

277: ,p_required_flag in varchar2 default hr_api.g_varchar2
278: ,p_start_date in date default hr_api.g_date
279: ,p_supplied_resource_id in number default hr_api.g_number
280: ,p_comments in varchar2 default hr_api.g_varchar2
281: ,p_end_date in date default hr_api.g_date
282: ,p_quantity in number default hr_api.g_number
283: ,p_resource_type in varchar2 default hr_api.g_varchar2
284: ,p_role_to_play in varchar2 default hr_api.g_varchar2
285: ,p_usage_reason in varchar2 default hr_api.g_varchar2

Line 282: ,p_quantity in number default hr_api.g_number

278: ,p_start_date in date default hr_api.g_date
279: ,p_supplied_resource_id in number default hr_api.g_number
280: ,p_comments in varchar2 default hr_api.g_varchar2
281: ,p_end_date in date default hr_api.g_date
282: ,p_quantity in number default hr_api.g_number
283: ,p_resource_type in varchar2 default hr_api.g_varchar2
284: ,p_role_to_play in varchar2 default hr_api.g_varchar2
285: ,p_usage_reason in varchar2 default hr_api.g_varchar2
286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2

Line 283: ,p_resource_type in varchar2 default hr_api.g_varchar2

279: ,p_supplied_resource_id in number default hr_api.g_number
280: ,p_comments in varchar2 default hr_api.g_varchar2
281: ,p_end_date in date default hr_api.g_date
282: ,p_quantity in number default hr_api.g_number
283: ,p_resource_type in varchar2 default hr_api.g_varchar2
284: ,p_role_to_play in varchar2 default hr_api.g_varchar2
285: ,p_usage_reason in varchar2 default hr_api.g_varchar2
286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2

Line 284: ,p_role_to_play in varchar2 default hr_api.g_varchar2

280: ,p_comments in varchar2 default hr_api.g_varchar2
281: ,p_end_date in date default hr_api.g_date
282: ,p_quantity in number default hr_api.g_number
283: ,p_resource_type in varchar2 default hr_api.g_varchar2
284: ,p_role_to_play in varchar2 default hr_api.g_varchar2
285: ,p_usage_reason in varchar2 default hr_api.g_varchar2
286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2

Line 285: ,p_usage_reason in varchar2 default hr_api.g_varchar2

281: ,p_end_date in date default hr_api.g_date
282: ,p_quantity in number default hr_api.g_number
283: ,p_resource_type in varchar2 default hr_api.g_varchar2
284: ,p_role_to_play in varchar2 default hr_api.g_varchar2
285: ,p_usage_reason in varchar2 default hr_api.g_varchar2
286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2

Line 286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2

282: ,p_quantity in number default hr_api.g_number
283: ,p_resource_type in varchar2 default hr_api.g_varchar2
284: ,p_role_to_play in varchar2 default hr_api.g_varchar2
285: ,p_usage_reason in varchar2 default hr_api.g_varchar2
286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2

Line 287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2

283: ,p_resource_type in varchar2 default hr_api.g_varchar2
284: ,p_role_to_play in varchar2 default hr_api.g_varchar2
285: ,p_usage_reason in varchar2 default hr_api.g_varchar2
286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2

Line 288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2

284: ,p_role_to_play in varchar2 default hr_api.g_varchar2
285: ,p_usage_reason in varchar2 default hr_api.g_varchar2
286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2

Line 289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2

285: ,p_usage_reason in varchar2 default hr_api.g_varchar2
286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2

Line 290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2

286: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2

Line 291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2

287: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2

Line 292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2

288: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2

Line 293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2

289: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2

Line 294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2

290: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2

Line 295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2

291: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2

Line 296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2

292: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2

Line 297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2

293: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2

Line 298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2

294: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2

Line 299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2

295: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
303: ,p_rud_information17 in varchar2 default hr_api.g_varchar2

Line 300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2

296: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
303: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
304: ,p_rud_information18 in varchar2 default hr_api.g_varchar2

Line 301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2

297: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
303: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
304: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
305: ,p_rud_information19 in varchar2 default hr_api.g_varchar2

Line 302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2

298: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
303: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
304: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
305: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
306: ,p_rud_information20 in varchar2 default hr_api.g_varchar2

Line 303: ,p_rud_information17 in varchar2 default hr_api.g_varchar2

299: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
303: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
304: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
305: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
306: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
307: ,p_return_status out nocopy varchar2

Line 304: ,p_rud_information18 in varchar2 default hr_api.g_varchar2

300: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
303: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
304: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
305: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
306: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
307: ,p_return_status out nocopy varchar2
308: ,p_offering_id in number default hr_api.g_number

Line 305: ,p_rud_information19 in varchar2 default hr_api.g_varchar2

301: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
303: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
304: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
305: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
306: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
307: ,p_return_status out nocopy varchar2
308: ,p_offering_id in number default hr_api.g_number
309: ) is

Line 306: ,p_rud_information20 in varchar2 default hr_api.g_varchar2

302: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
303: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
304: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
305: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
306: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
307: ,p_return_status out nocopy varchar2
308: ,p_offering_id in number default hr_api.g_number
309: ) is
310: --

Line 308: ,p_offering_id in number default hr_api.g_number

304: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
305: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
306: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
307: ,p_return_status out nocopy varchar2
308: ,p_offering_id in number default hr_api.g_number
309: ) is
310: --
311: -- Variables for API Boolean parameters
312: l_validate boolean;

Line 337: hr_api.constant_to_boolean

333: --
334: -- Convert constant values to their corresponding boolean value
335: --
336: l_validate :=
337: hr_api.constant_to_boolean
338: (p_constant_value => p_validate);
339: --
340: -- Register Surrogate ID or user key values
341: --