APPS.OTA_PLE_UPD dependencies on HR_API

Line 111: When hr_api.check_integrity_violated Then

107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
114: ota_ple_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
114: ota_ple_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
119: ota_ple_shd.constraint_error

Line 116: When hr_api.parent_integrity_violated Then

112: -- A check constraint has been violated
113: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
114: ota_ple_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
119: ota_ple_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
119: ota_ple_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
124: ota_ple_shd.constraint_error

Line 121: When hr_api.unique_integrity_violated Then

117: -- Parent integrity has been violated
118: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
119: ota_ple_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
124: ota_ple_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
124: ota_ple_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
128: Raise;
129: End update_dml;

Line 272: If (p_rec.vendor_supply_id = hr_api.g_number) then

268: -- p_rec plsql record structure
269: -- to see if a system default is being used. If a system default
270: -- is being used then we must set to the 'current' argument value.
271: --
272: If (p_rec.vendor_supply_id = hr_api.g_number) then
273: p_rec.vendor_supply_id :=
274: ota_ple_shd.g_old_rec.vendor_supply_id;
275: End If;
276: If (p_rec.activity_version_id = hr_api.g_number) then

Line 276: If (p_rec.activity_version_id = hr_api.g_number) then

272: If (p_rec.vendor_supply_id = hr_api.g_number) then
273: p_rec.vendor_supply_id :=
274: ota_ple_shd.g_old_rec.vendor_supply_id;
275: End If;
276: If (p_rec.activity_version_id = hr_api.g_number) then
277: p_rec.activity_version_id :=
278: ota_ple_shd.g_old_rec.activity_version_id;
279: End If;
280: If (p_rec.price_list_id = hr_api.g_number) then

Line 280: If (p_rec.price_list_id = hr_api.g_number) then

276: If (p_rec.activity_version_id = hr_api.g_number) then
277: p_rec.activity_version_id :=
278: ota_ple_shd.g_old_rec.activity_version_id;
279: End If;
280: If (p_rec.price_list_id = hr_api.g_number) then
281: p_rec.price_list_id :=
282: ota_ple_shd.g_old_rec.price_list_id;
283: End If;
284: If (p_rec.price = hr_api.g_number) then

Line 284: If (p_rec.price = hr_api.g_number) then

280: If (p_rec.price_list_id = hr_api.g_number) then
281: p_rec.price_list_id :=
282: ota_ple_shd.g_old_rec.price_list_id;
283: End If;
284: If (p_rec.price = hr_api.g_number) then
285: p_rec.price :=
286: ota_ple_shd.g_old_rec.price;
287: End If;
288: If (p_rec.price_basis = hr_api.g_varchar2) then

Line 288: If (p_rec.price_basis = hr_api.g_varchar2) then

284: If (p_rec.price = hr_api.g_number) then
285: p_rec.price :=
286: ota_ple_shd.g_old_rec.price;
287: End If;
288: If (p_rec.price_basis = hr_api.g_varchar2) then
289: p_rec.price_basis :=
290: ota_ple_shd.g_old_rec.price_basis;
291: End If;
292: If (p_rec.start_date = hr_api.g_date) then

Line 292: If (p_rec.start_date = hr_api.g_date) then

288: If (p_rec.price_basis = hr_api.g_varchar2) then
289: p_rec.price_basis :=
290: ota_ple_shd.g_old_rec.price_basis;
291: End If;
292: If (p_rec.start_date = hr_api.g_date) then
293: p_rec.start_date :=
294: ota_ple_shd.g_old_rec.start_date;
295: End If;
296: If (p_rec.comments = hr_api.g_varchar2) then

Line 296: If (p_rec.comments = hr_api.g_varchar2) then

292: If (p_rec.start_date = hr_api.g_date) then
293: p_rec.start_date :=
294: ota_ple_shd.g_old_rec.start_date;
295: End If;
296: If (p_rec.comments = hr_api.g_varchar2) then
297: p_rec.comments :=
298: ota_ple_shd.g_old_rec.comments;
299: End If;
300: If (p_rec.end_date = hr_api.g_date) then

Line 300: If (p_rec.end_date = hr_api.g_date) then

296: If (p_rec.comments = hr_api.g_varchar2) then
297: p_rec.comments :=
298: ota_ple_shd.g_old_rec.comments;
299: End If;
300: If (p_rec.end_date = hr_api.g_date) then
301: p_rec.end_date :=
302: ota_ple_shd.g_old_rec.end_date;
303: End If;
304: If (p_rec.maximum_attendees = hr_api.g_number) then

Line 304: If (p_rec.maximum_attendees = hr_api.g_number) then

300: If (p_rec.end_date = hr_api.g_date) then
301: p_rec.end_date :=
302: ota_ple_shd.g_old_rec.end_date;
303: End If;
304: If (p_rec.maximum_attendees = hr_api.g_number) then
305: p_rec.maximum_attendees :=
306: ota_ple_shd.g_old_rec.maximum_attendees;
307: End If;
308: If (p_rec.minimum_attendees = hr_api.g_number) then

Line 308: If (p_rec.minimum_attendees = hr_api.g_number) then

304: If (p_rec.maximum_attendees = hr_api.g_number) then
305: p_rec.maximum_attendees :=
306: ota_ple_shd.g_old_rec.maximum_attendees;
307: End If;
308: If (p_rec.minimum_attendees = hr_api.g_number) then
309: p_rec.minimum_attendees :=
310: ota_ple_shd.g_old_rec.minimum_attendees;
311: End If;
312: If (p_rec.ple_information_category = hr_api.g_varchar2) then

Line 312: If (p_rec.ple_information_category = hr_api.g_varchar2) then

308: If (p_rec.minimum_attendees = hr_api.g_number) then
309: p_rec.minimum_attendees :=
310: ota_ple_shd.g_old_rec.minimum_attendees;
311: End If;
312: If (p_rec.ple_information_category = hr_api.g_varchar2) then
313: p_rec.ple_information_category :=
314: ota_ple_shd.g_old_rec.ple_information_category;
315: End If;
316: If (p_rec.ple_information1 = hr_api.g_varchar2) then

Line 316: If (p_rec.ple_information1 = hr_api.g_varchar2) then

312: If (p_rec.ple_information_category = hr_api.g_varchar2) then
313: p_rec.ple_information_category :=
314: ota_ple_shd.g_old_rec.ple_information_category;
315: End If;
316: If (p_rec.ple_information1 = hr_api.g_varchar2) then
317: p_rec.ple_information1 :=
318: ota_ple_shd.g_old_rec.ple_information1;
319: End If;
320: If (p_rec.ple_information2 = hr_api.g_varchar2) then

Line 320: If (p_rec.ple_information2 = hr_api.g_varchar2) then

316: If (p_rec.ple_information1 = hr_api.g_varchar2) then
317: p_rec.ple_information1 :=
318: ota_ple_shd.g_old_rec.ple_information1;
319: End If;
320: If (p_rec.ple_information2 = hr_api.g_varchar2) then
321: p_rec.ple_information2 :=
322: ota_ple_shd.g_old_rec.ple_information2;
323: End If;
324: If (p_rec.ple_information3 = hr_api.g_varchar2) then

Line 324: If (p_rec.ple_information3 = hr_api.g_varchar2) then

320: If (p_rec.ple_information2 = hr_api.g_varchar2) then
321: p_rec.ple_information2 :=
322: ota_ple_shd.g_old_rec.ple_information2;
323: End If;
324: If (p_rec.ple_information3 = hr_api.g_varchar2) then
325: p_rec.ple_information3 :=
326: ota_ple_shd.g_old_rec.ple_information3;
327: End If;
328: If (p_rec.ple_information4 = hr_api.g_varchar2) then

Line 328: If (p_rec.ple_information4 = hr_api.g_varchar2) then

324: If (p_rec.ple_information3 = hr_api.g_varchar2) then
325: p_rec.ple_information3 :=
326: ota_ple_shd.g_old_rec.ple_information3;
327: End If;
328: If (p_rec.ple_information4 = hr_api.g_varchar2) then
329: p_rec.ple_information4 :=
330: ota_ple_shd.g_old_rec.ple_information4;
331: End If;
332: If (p_rec.ple_information5 = hr_api.g_varchar2) then

Line 332: If (p_rec.ple_information5 = hr_api.g_varchar2) then

328: If (p_rec.ple_information4 = hr_api.g_varchar2) then
329: p_rec.ple_information4 :=
330: ota_ple_shd.g_old_rec.ple_information4;
331: End If;
332: If (p_rec.ple_information5 = hr_api.g_varchar2) then
333: p_rec.ple_information5 :=
334: ota_ple_shd.g_old_rec.ple_information5;
335: End If;
336: If (p_rec.ple_information6 = hr_api.g_varchar2) then

Line 336: If (p_rec.ple_information6 = hr_api.g_varchar2) then

332: If (p_rec.ple_information5 = hr_api.g_varchar2) then
333: p_rec.ple_information5 :=
334: ota_ple_shd.g_old_rec.ple_information5;
335: End If;
336: If (p_rec.ple_information6 = hr_api.g_varchar2) then
337: p_rec.ple_information6 :=
338: ota_ple_shd.g_old_rec.ple_information6;
339: End If;
340: If (p_rec.ple_information7 = hr_api.g_varchar2) then

Line 340: If (p_rec.ple_information7 = hr_api.g_varchar2) then

336: If (p_rec.ple_information6 = hr_api.g_varchar2) then
337: p_rec.ple_information6 :=
338: ota_ple_shd.g_old_rec.ple_information6;
339: End If;
340: If (p_rec.ple_information7 = hr_api.g_varchar2) then
341: p_rec.ple_information7 :=
342: ota_ple_shd.g_old_rec.ple_information7;
343: End If;
344: If (p_rec.ple_information8 = hr_api.g_varchar2) then

Line 344: If (p_rec.ple_information8 = hr_api.g_varchar2) then

340: If (p_rec.ple_information7 = hr_api.g_varchar2) then
341: p_rec.ple_information7 :=
342: ota_ple_shd.g_old_rec.ple_information7;
343: End If;
344: If (p_rec.ple_information8 = hr_api.g_varchar2) then
345: p_rec.ple_information8 :=
346: ota_ple_shd.g_old_rec.ple_information8;
347: End If;
348: If (p_rec.ple_information9 = hr_api.g_varchar2) then

Line 348: If (p_rec.ple_information9 = hr_api.g_varchar2) then

344: If (p_rec.ple_information8 = hr_api.g_varchar2) then
345: p_rec.ple_information8 :=
346: ota_ple_shd.g_old_rec.ple_information8;
347: End If;
348: If (p_rec.ple_information9 = hr_api.g_varchar2) then
349: p_rec.ple_information9 :=
350: ota_ple_shd.g_old_rec.ple_information9;
351: End If;
352: If (p_rec.ple_information10 = hr_api.g_varchar2) then

Line 352: If (p_rec.ple_information10 = hr_api.g_varchar2) then

348: If (p_rec.ple_information9 = hr_api.g_varchar2) then
349: p_rec.ple_information9 :=
350: ota_ple_shd.g_old_rec.ple_information9;
351: End If;
352: If (p_rec.ple_information10 = hr_api.g_varchar2) then
353: p_rec.ple_information10 :=
354: ota_ple_shd.g_old_rec.ple_information10;
355: End If;
356: If (p_rec.ple_information11 = hr_api.g_varchar2) then

Line 356: If (p_rec.ple_information11 = hr_api.g_varchar2) then

352: If (p_rec.ple_information10 = hr_api.g_varchar2) then
353: p_rec.ple_information10 :=
354: ota_ple_shd.g_old_rec.ple_information10;
355: End If;
356: If (p_rec.ple_information11 = hr_api.g_varchar2) then
357: p_rec.ple_information11 :=
358: ota_ple_shd.g_old_rec.ple_information11;
359: End If;
360: If (p_rec.ple_information12 = hr_api.g_varchar2) then

Line 360: If (p_rec.ple_information12 = hr_api.g_varchar2) then

356: If (p_rec.ple_information11 = hr_api.g_varchar2) then
357: p_rec.ple_information11 :=
358: ota_ple_shd.g_old_rec.ple_information11;
359: End If;
360: If (p_rec.ple_information12 = hr_api.g_varchar2) then
361: p_rec.ple_information12 :=
362: ota_ple_shd.g_old_rec.ple_information12;
363: End If;
364: If (p_rec.ple_information13 = hr_api.g_varchar2) then

Line 364: If (p_rec.ple_information13 = hr_api.g_varchar2) then

360: If (p_rec.ple_information12 = hr_api.g_varchar2) then
361: p_rec.ple_information12 :=
362: ota_ple_shd.g_old_rec.ple_information12;
363: End If;
364: If (p_rec.ple_information13 = hr_api.g_varchar2) then
365: p_rec.ple_information13 :=
366: ota_ple_shd.g_old_rec.ple_information13;
367: End If;
368: If (p_rec.ple_information14 = hr_api.g_varchar2) then

Line 368: If (p_rec.ple_information14 = hr_api.g_varchar2) then

364: If (p_rec.ple_information13 = hr_api.g_varchar2) then
365: p_rec.ple_information13 :=
366: ota_ple_shd.g_old_rec.ple_information13;
367: End If;
368: If (p_rec.ple_information14 = hr_api.g_varchar2) then
369: p_rec.ple_information14 :=
370: ota_ple_shd.g_old_rec.ple_information14;
371: End If;
372: If (p_rec.ple_information15 = hr_api.g_varchar2) then

Line 372: If (p_rec.ple_information15 = hr_api.g_varchar2) then

368: If (p_rec.ple_information14 = hr_api.g_varchar2) then
369: p_rec.ple_information14 :=
370: ota_ple_shd.g_old_rec.ple_information14;
371: End If;
372: If (p_rec.ple_information15 = hr_api.g_varchar2) then
373: p_rec.ple_information15 :=
374: ota_ple_shd.g_old_rec.ple_information15;
375: End If;
376: If (p_rec.ple_information16 = hr_api.g_varchar2) then

Line 376: If (p_rec.ple_information16 = hr_api.g_varchar2) then

372: If (p_rec.ple_information15 = hr_api.g_varchar2) then
373: p_rec.ple_information15 :=
374: ota_ple_shd.g_old_rec.ple_information15;
375: End If;
376: If (p_rec.ple_information16 = hr_api.g_varchar2) then
377: p_rec.ple_information16 :=
378: ota_ple_shd.g_old_rec.ple_information16;
379: End If;
380: If (p_rec.ple_information17 = hr_api.g_varchar2) then

Line 380: If (p_rec.ple_information17 = hr_api.g_varchar2) then

376: If (p_rec.ple_information16 = hr_api.g_varchar2) then
377: p_rec.ple_information16 :=
378: ota_ple_shd.g_old_rec.ple_information16;
379: End If;
380: If (p_rec.ple_information17 = hr_api.g_varchar2) then
381: p_rec.ple_information17 :=
382: ota_ple_shd.g_old_rec.ple_information17;
383: End If;
384: If (p_rec.ple_information18 = hr_api.g_varchar2) then

Line 384: If (p_rec.ple_information18 = hr_api.g_varchar2) then

380: If (p_rec.ple_information17 = hr_api.g_varchar2) then
381: p_rec.ple_information17 :=
382: ota_ple_shd.g_old_rec.ple_information17;
383: End If;
384: If (p_rec.ple_information18 = hr_api.g_varchar2) then
385: p_rec.ple_information18 :=
386: ota_ple_shd.g_old_rec.ple_information18;
387: End If;
388: If (p_rec.ple_information19 = hr_api.g_varchar2) then

Line 388: If (p_rec.ple_information19 = hr_api.g_varchar2) then

384: If (p_rec.ple_information18 = hr_api.g_varchar2) then
385: p_rec.ple_information18 :=
386: ota_ple_shd.g_old_rec.ple_information18;
387: End If;
388: If (p_rec.ple_information19 = hr_api.g_varchar2) then
389: p_rec.ple_information19 :=
390: ota_ple_shd.g_old_rec.ple_information19;
391: End If;
392: If (p_rec.ple_information20 = hr_api.g_varchar2) then

Line 392: If (p_rec.ple_information20 = hr_api.g_varchar2) then

388: If (p_rec.ple_information19 = hr_api.g_varchar2) then
389: p_rec.ple_information19 :=
390: ota_ple_shd.g_old_rec.ple_information19;
391: End If;
392: If (p_rec.ple_information20 = hr_api.g_varchar2) then
393: p_rec.ple_information20 :=
394: ota_ple_shd.g_old_rec.ple_information20;
395: End If;
396: --

Line 458: Raise HR_Api.Validate_Enabled;

454: --
455: -- If we are validating then raise the Validate_Enabled exception
456: --
457: If p_validate then
458: Raise HR_Api.Validate_Enabled;
459: End If;
460: --
461: hr_utility.set_location(' Leaving:'||l_proc, 10);
462: Exception

Line 463: When HR_Api.Validate_Enabled Then

459: End If;
460: --
461: hr_utility.set_location(' Leaving:'||l_proc, 10);
462: Exception
463: When HR_Api.Validate_Enabled Then
464: --
465: -- As the Validate_Enabled exception has been raised
466: -- we must rollback to the savepoint
467: --

Line 477: p_vendor_supply_id in number default hr_api.g_number,

473: -- ----------------------------------------------------------------------------
474: Procedure upd
475: (
476: p_price_list_entry_id in number,
477: p_vendor_supply_id in number default hr_api.g_number,
478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,

Line 478: p_activity_version_id in number default hr_api.g_number,

474: Procedure upd
475: (
476: p_price_list_entry_id in number,
477: p_vendor_supply_id in number default hr_api.g_number,
478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,

Line 479: p_price_list_id in number default hr_api.g_number,

475: (
476: p_price_list_entry_id in number,
477: p_vendor_supply_id in number default hr_api.g_number,
478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,

Line 481: p_price in number default hr_api.g_number,

477: p_vendor_supply_id in number default hr_api.g_number,
478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,

Line 482: p_price_basis in varchar2 default hr_api.g_varchar2,

478: p_activity_version_id in number default hr_api.g_number,
479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,

Line 483: p_start_date in date default hr_api.g_date,

479: p_price_list_id in number default hr_api.g_number,
480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,

Line 484: p_comments in varchar2 default hr_api.g_varchar2,

480: p_object_version_number in out number,
481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,

Line 485: p_end_date in date default hr_api.g_date,

481: p_price in number default hr_api.g_number,
482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,

Line 486: p_maximum_attendees in number default hr_api.g_number,

482: p_price_basis in varchar2 default hr_api.g_varchar2,
483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,

Line 487: p_minimum_attendees in number default hr_api.g_number,

483: p_start_date in date default hr_api.g_date,
484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,

Line 488: p_ple_information_category in varchar2 default hr_api.g_varchar2,

484: p_comments in varchar2 default hr_api.g_varchar2,
485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,

Line 489: p_ple_information1 in varchar2 default hr_api.g_varchar2,

485: p_end_date in date default hr_api.g_date,
486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,

Line 490: p_ple_information2 in varchar2 default hr_api.g_varchar2,

486: p_maximum_attendees in number default hr_api.g_number,
487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,

Line 491: p_ple_information3 in varchar2 default hr_api.g_varchar2,

487: p_minimum_attendees in number default hr_api.g_number,
488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,

Line 492: p_ple_information4 in varchar2 default hr_api.g_varchar2,

488: p_ple_information_category in varchar2 default hr_api.g_varchar2,
489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,

Line 493: p_ple_information5 in varchar2 default hr_api.g_varchar2,

489: p_ple_information1 in varchar2 default hr_api.g_varchar2,
490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,

Line 494: p_ple_information6 in varchar2 default hr_api.g_varchar2,

490: p_ple_information2 in varchar2 default hr_api.g_varchar2,
491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,

Line 495: p_ple_information7 in varchar2 default hr_api.g_varchar2,

491: p_ple_information3 in varchar2 default hr_api.g_varchar2,
492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,

Line 496: p_ple_information8 in varchar2 default hr_api.g_varchar2,

492: p_ple_information4 in varchar2 default hr_api.g_varchar2,
493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,

Line 497: p_ple_information9 in varchar2 default hr_api.g_varchar2,

493: p_ple_information5 in varchar2 default hr_api.g_varchar2,
494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,

Line 498: p_ple_information10 in varchar2 default hr_api.g_varchar2,

494: p_ple_information6 in varchar2 default hr_api.g_varchar2,
495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,

Line 499: p_ple_information11 in varchar2 default hr_api.g_varchar2,

495: p_ple_information7 in varchar2 default hr_api.g_varchar2,
496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,

Line 500: p_ple_information12 in varchar2 default hr_api.g_varchar2,

496: p_ple_information8 in varchar2 default hr_api.g_varchar2,
497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,

Line 501: p_ple_information13 in varchar2 default hr_api.g_varchar2,

497: p_ple_information9 in varchar2 default hr_api.g_varchar2,
498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,

Line 502: p_ple_information14 in varchar2 default hr_api.g_varchar2,

498: p_ple_information10 in varchar2 default hr_api.g_varchar2,
499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,

Line 503: p_ple_information15 in varchar2 default hr_api.g_varchar2,

499: p_ple_information11 in varchar2 default hr_api.g_varchar2,
500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,

Line 504: p_ple_information16 in varchar2 default hr_api.g_varchar2,

500: p_ple_information12 in varchar2 default hr_api.g_varchar2,
501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,

Line 505: p_ple_information17 in varchar2 default hr_api.g_varchar2,

501: p_ple_information13 in varchar2 default hr_api.g_varchar2,
502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,
509: p_validate in boolean default false

Line 506: p_ple_information18 in varchar2 default hr_api.g_varchar2,

502: p_ple_information14 in varchar2 default hr_api.g_varchar2,
503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,
509: p_validate in boolean default false
510: ) is

Line 507: p_ple_information19 in varchar2 default hr_api.g_varchar2,

503: p_ple_information15 in varchar2 default hr_api.g_varchar2,
504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,
509: p_validate in boolean default false
510: ) is
511: --

Line 508: p_ple_information20 in varchar2 default hr_api.g_varchar2,

504: p_ple_information16 in varchar2 default hr_api.g_varchar2,
505: p_ple_information17 in varchar2 default hr_api.g_varchar2,
506: p_ple_information18 in varchar2 default hr_api.g_varchar2,
507: p_ple_information19 in varchar2 default hr_api.g_varchar2,
508: p_ple_information20 in varchar2 default hr_api.g_varchar2,
509: p_validate in boolean default false
510: ) is
511: --
512: l_rec ota_ple_shd.g_rec_type;