APPS.OTA_TPL_UPD dependencies on HR_API

Line 112: When hr_api.check_integrity_violated Then

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

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

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

Line 117: When hr_api.parent_integrity_violated Then

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

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

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

Line 122: When hr_api.unique_integrity_violated Then

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

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

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

Line 273: If (p_rec.business_group_id = hr_api.g_number) then

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

Line 277: If (p_rec.currency_code = hr_api.g_varchar2) then

273: If (p_rec.business_group_id = hr_api.g_number) then
274: p_rec.business_group_id :=
275: ota_tpl_shd.g_old_rec.business_group_id;
276: End If;
277: If (p_rec.currency_code = hr_api.g_varchar2) then
278: p_rec.currency_code :=
279: ota_tpl_shd.g_old_rec.currency_code;
280: End If;
281: If (p_rec.default_flag = hr_api.g_varchar2) then

Line 281: If (p_rec.default_flag = hr_api.g_varchar2) then

277: If (p_rec.currency_code = hr_api.g_varchar2) then
278: p_rec.currency_code :=
279: ota_tpl_shd.g_old_rec.currency_code;
280: End If;
281: If (p_rec.default_flag = hr_api.g_varchar2) then
282: p_rec.default_flag :=
283: ota_tpl_shd.g_old_rec.default_flag;
284: End If;
285: If (p_rec.name = hr_api.g_varchar2) then

Line 285: If (p_rec.name = hr_api.g_varchar2) then

281: If (p_rec.default_flag = hr_api.g_varchar2) then
282: p_rec.default_flag :=
283: ota_tpl_shd.g_old_rec.default_flag;
284: End If;
285: If (p_rec.name = hr_api.g_varchar2) then
286: p_rec.name :=
287: ota_tpl_shd.g_old_rec.name;
288: End If;
289: If (p_rec.price_list_type = hr_api.g_varchar2) then

Line 289: If (p_rec.price_list_type = hr_api.g_varchar2) then

285: If (p_rec.name = hr_api.g_varchar2) then
286: p_rec.name :=
287: ota_tpl_shd.g_old_rec.name;
288: End If;
289: If (p_rec.price_list_type = hr_api.g_varchar2) then
290: p_rec.price_list_type :=
291: ota_tpl_shd.g_old_rec.price_list_type;
292: End If;
293: If (p_rec.start_date = hr_api.g_date) then

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

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

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

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

Line 301: If (p_rec.description = hr_api.g_varchar2) then

297: If (p_rec.comments = hr_api.g_varchar2) then
298: p_rec.comments :=
299: ota_tpl_shd.g_old_rec.comments;
300: End If;
301: If (p_rec.description = hr_api.g_varchar2) then
302: p_rec.description :=
303: ota_tpl_shd.g_old_rec.description;
304: End If;
305: If (p_rec.end_date = hr_api.g_date) then

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

301: If (p_rec.description = hr_api.g_varchar2) then
302: p_rec.description :=
303: ota_tpl_shd.g_old_rec.description;
304: End If;
305: If (p_rec.end_date = hr_api.g_date) then
306: p_rec.end_date :=
307: ota_tpl_shd.g_old_rec.end_date;
308: End If;
309: If (p_rec.single_unit_price = hr_api.g_number) then

Line 309: If (p_rec.single_unit_price = hr_api.g_number) then

305: If (p_rec.end_date = hr_api.g_date) then
306: p_rec.end_date :=
307: ota_tpl_shd.g_old_rec.end_date;
308: End If;
309: If (p_rec.single_unit_price = hr_api.g_number) then
310: p_rec.single_unit_price :=
311: ota_tpl_shd.g_old_rec.single_unit_price;
312: End If;
313: If (p_rec.training_unit_type = hr_api.g_varchar2) then

Line 313: If (p_rec.training_unit_type = hr_api.g_varchar2) then

309: If (p_rec.single_unit_price = hr_api.g_number) then
310: p_rec.single_unit_price :=
311: ota_tpl_shd.g_old_rec.single_unit_price;
312: End If;
313: If (p_rec.training_unit_type = hr_api.g_varchar2) then
314: p_rec.training_unit_type :=
315: ota_tpl_shd.g_old_rec.training_unit_type;
316: End If;
317: If (p_rec.tpl_information_category = hr_api.g_varchar2) then

Line 317: If (p_rec.tpl_information_category = hr_api.g_varchar2) then

313: If (p_rec.training_unit_type = hr_api.g_varchar2) then
314: p_rec.training_unit_type :=
315: ota_tpl_shd.g_old_rec.training_unit_type;
316: End If;
317: If (p_rec.tpl_information_category = hr_api.g_varchar2) then
318: p_rec.tpl_information_category :=
319: ota_tpl_shd.g_old_rec.tpl_information_category;
320: End If;
321: If (p_rec.tpl_information1 = hr_api.g_varchar2) then

Line 321: If (p_rec.tpl_information1 = hr_api.g_varchar2) then

317: If (p_rec.tpl_information_category = hr_api.g_varchar2) then
318: p_rec.tpl_information_category :=
319: ota_tpl_shd.g_old_rec.tpl_information_category;
320: End If;
321: If (p_rec.tpl_information1 = hr_api.g_varchar2) then
322: p_rec.tpl_information1 :=
323: ota_tpl_shd.g_old_rec.tpl_information1;
324: End If;
325: If (p_rec.tpl_information2 = hr_api.g_varchar2) then

Line 325: If (p_rec.tpl_information2 = hr_api.g_varchar2) then

321: If (p_rec.tpl_information1 = hr_api.g_varchar2) then
322: p_rec.tpl_information1 :=
323: ota_tpl_shd.g_old_rec.tpl_information1;
324: End If;
325: If (p_rec.tpl_information2 = hr_api.g_varchar2) then
326: p_rec.tpl_information2 :=
327: ota_tpl_shd.g_old_rec.tpl_information2;
328: End If;
329: If (p_rec.tpl_information3 = hr_api.g_varchar2) then

Line 329: If (p_rec.tpl_information3 = hr_api.g_varchar2) then

325: If (p_rec.tpl_information2 = hr_api.g_varchar2) then
326: p_rec.tpl_information2 :=
327: ota_tpl_shd.g_old_rec.tpl_information2;
328: End If;
329: If (p_rec.tpl_information3 = hr_api.g_varchar2) then
330: p_rec.tpl_information3 :=
331: ota_tpl_shd.g_old_rec.tpl_information3;
332: End If;
333: If (p_rec.tpl_information4 = hr_api.g_varchar2) then

Line 333: If (p_rec.tpl_information4 = hr_api.g_varchar2) then

329: If (p_rec.tpl_information3 = hr_api.g_varchar2) then
330: p_rec.tpl_information3 :=
331: ota_tpl_shd.g_old_rec.tpl_information3;
332: End If;
333: If (p_rec.tpl_information4 = hr_api.g_varchar2) then
334: p_rec.tpl_information4 :=
335: ota_tpl_shd.g_old_rec.tpl_information4;
336: End If;
337: If (p_rec.tpl_information5 = hr_api.g_varchar2) then

Line 337: If (p_rec.tpl_information5 = hr_api.g_varchar2) then

333: If (p_rec.tpl_information4 = hr_api.g_varchar2) then
334: p_rec.tpl_information4 :=
335: ota_tpl_shd.g_old_rec.tpl_information4;
336: End If;
337: If (p_rec.tpl_information5 = hr_api.g_varchar2) then
338: p_rec.tpl_information5 :=
339: ota_tpl_shd.g_old_rec.tpl_information5;
340: End If;
341: If (p_rec.tpl_information6 = hr_api.g_varchar2) then

Line 341: If (p_rec.tpl_information6 = hr_api.g_varchar2) then

337: If (p_rec.tpl_information5 = hr_api.g_varchar2) then
338: p_rec.tpl_information5 :=
339: ota_tpl_shd.g_old_rec.tpl_information5;
340: End If;
341: If (p_rec.tpl_information6 = hr_api.g_varchar2) then
342: p_rec.tpl_information6 :=
343: ota_tpl_shd.g_old_rec.tpl_information6;
344: End If;
345: If (p_rec.tpl_information7 = hr_api.g_varchar2) then

Line 345: If (p_rec.tpl_information7 = hr_api.g_varchar2) then

341: If (p_rec.tpl_information6 = hr_api.g_varchar2) then
342: p_rec.tpl_information6 :=
343: ota_tpl_shd.g_old_rec.tpl_information6;
344: End If;
345: If (p_rec.tpl_information7 = hr_api.g_varchar2) then
346: p_rec.tpl_information7 :=
347: ota_tpl_shd.g_old_rec.tpl_information7;
348: End If;
349: If (p_rec.tpl_information8 = hr_api.g_varchar2) then

Line 349: If (p_rec.tpl_information8 = hr_api.g_varchar2) then

345: If (p_rec.tpl_information7 = hr_api.g_varchar2) then
346: p_rec.tpl_information7 :=
347: ota_tpl_shd.g_old_rec.tpl_information7;
348: End If;
349: If (p_rec.tpl_information8 = hr_api.g_varchar2) then
350: p_rec.tpl_information8 :=
351: ota_tpl_shd.g_old_rec.tpl_information8;
352: End If;
353: If (p_rec.tpl_information9 = hr_api.g_varchar2) then

Line 353: If (p_rec.tpl_information9 = hr_api.g_varchar2) then

349: If (p_rec.tpl_information8 = hr_api.g_varchar2) then
350: p_rec.tpl_information8 :=
351: ota_tpl_shd.g_old_rec.tpl_information8;
352: End If;
353: If (p_rec.tpl_information9 = hr_api.g_varchar2) then
354: p_rec.tpl_information9 :=
355: ota_tpl_shd.g_old_rec.tpl_information9;
356: End If;
357: If (p_rec.tpl_information10 = hr_api.g_varchar2) then

Line 357: If (p_rec.tpl_information10 = hr_api.g_varchar2) then

353: If (p_rec.tpl_information9 = hr_api.g_varchar2) then
354: p_rec.tpl_information9 :=
355: ota_tpl_shd.g_old_rec.tpl_information9;
356: End If;
357: If (p_rec.tpl_information10 = hr_api.g_varchar2) then
358: p_rec.tpl_information10 :=
359: ota_tpl_shd.g_old_rec.tpl_information10;
360: End If;
361: If (p_rec.tpl_information11 = hr_api.g_varchar2) then

Line 361: If (p_rec.tpl_information11 = hr_api.g_varchar2) then

357: If (p_rec.tpl_information10 = hr_api.g_varchar2) then
358: p_rec.tpl_information10 :=
359: ota_tpl_shd.g_old_rec.tpl_information10;
360: End If;
361: If (p_rec.tpl_information11 = hr_api.g_varchar2) then
362: p_rec.tpl_information11 :=
363: ota_tpl_shd.g_old_rec.tpl_information11;
364: End If;
365: If (p_rec.tpl_information12 = hr_api.g_varchar2) then

Line 365: If (p_rec.tpl_information12 = hr_api.g_varchar2) then

361: If (p_rec.tpl_information11 = hr_api.g_varchar2) then
362: p_rec.tpl_information11 :=
363: ota_tpl_shd.g_old_rec.tpl_information11;
364: End If;
365: If (p_rec.tpl_information12 = hr_api.g_varchar2) then
366: p_rec.tpl_information12 :=
367: ota_tpl_shd.g_old_rec.tpl_information12;
368: End If;
369: If (p_rec.tpl_information13 = hr_api.g_varchar2) then

Line 369: If (p_rec.tpl_information13 = hr_api.g_varchar2) then

365: If (p_rec.tpl_information12 = hr_api.g_varchar2) then
366: p_rec.tpl_information12 :=
367: ota_tpl_shd.g_old_rec.tpl_information12;
368: End If;
369: If (p_rec.tpl_information13 = hr_api.g_varchar2) then
370: p_rec.tpl_information13 :=
371: ota_tpl_shd.g_old_rec.tpl_information13;
372: End If;
373: If (p_rec.tpl_information14 = hr_api.g_varchar2) then

Line 373: If (p_rec.tpl_information14 = hr_api.g_varchar2) then

369: If (p_rec.tpl_information13 = hr_api.g_varchar2) then
370: p_rec.tpl_information13 :=
371: ota_tpl_shd.g_old_rec.tpl_information13;
372: End If;
373: If (p_rec.tpl_information14 = hr_api.g_varchar2) then
374: p_rec.tpl_information14 :=
375: ota_tpl_shd.g_old_rec.tpl_information14;
376: End If;
377: If (p_rec.tpl_information15 = hr_api.g_varchar2) then

Line 377: If (p_rec.tpl_information15 = hr_api.g_varchar2) then

373: If (p_rec.tpl_information14 = hr_api.g_varchar2) then
374: p_rec.tpl_information14 :=
375: ota_tpl_shd.g_old_rec.tpl_information14;
376: End If;
377: If (p_rec.tpl_information15 = hr_api.g_varchar2) then
378: p_rec.tpl_information15 :=
379: ota_tpl_shd.g_old_rec.tpl_information15;
380: End If;
381: If (p_rec.tpl_information16 = hr_api.g_varchar2) then

Line 381: If (p_rec.tpl_information16 = hr_api.g_varchar2) then

377: If (p_rec.tpl_information15 = hr_api.g_varchar2) then
378: p_rec.tpl_information15 :=
379: ota_tpl_shd.g_old_rec.tpl_information15;
380: End If;
381: If (p_rec.tpl_information16 = hr_api.g_varchar2) then
382: p_rec.tpl_information16 :=
383: ota_tpl_shd.g_old_rec.tpl_information16;
384: End If;
385: If (p_rec.tpl_information17 = hr_api.g_varchar2) then

Line 385: If (p_rec.tpl_information17 = hr_api.g_varchar2) then

381: If (p_rec.tpl_information16 = hr_api.g_varchar2) then
382: p_rec.tpl_information16 :=
383: ota_tpl_shd.g_old_rec.tpl_information16;
384: End If;
385: If (p_rec.tpl_information17 = hr_api.g_varchar2) then
386: p_rec.tpl_information17 :=
387: ota_tpl_shd.g_old_rec.tpl_information17;
388: End If;
389: If (p_rec.tpl_information18 = hr_api.g_varchar2) then

Line 389: If (p_rec.tpl_information18 = hr_api.g_varchar2) then

385: If (p_rec.tpl_information17 = hr_api.g_varchar2) then
386: p_rec.tpl_information17 :=
387: ota_tpl_shd.g_old_rec.tpl_information17;
388: End If;
389: If (p_rec.tpl_information18 = hr_api.g_varchar2) then
390: p_rec.tpl_information18 :=
391: ota_tpl_shd.g_old_rec.tpl_information18;
392: End If;
393: If (p_rec.tpl_information19 = hr_api.g_varchar2) then

Line 393: If (p_rec.tpl_information19 = hr_api.g_varchar2) then

389: If (p_rec.tpl_information18 = hr_api.g_varchar2) then
390: p_rec.tpl_information18 :=
391: ota_tpl_shd.g_old_rec.tpl_information18;
392: End If;
393: If (p_rec.tpl_information19 = hr_api.g_varchar2) then
394: p_rec.tpl_information19 :=
395: ota_tpl_shd.g_old_rec.tpl_information19;
396: End If;
397: If (p_rec.tpl_information20 = hr_api.g_varchar2) then

Line 397: If (p_rec.tpl_information20 = hr_api.g_varchar2) then

393: If (p_rec.tpl_information19 = hr_api.g_varchar2) then
394: p_rec.tpl_information19 :=
395: ota_tpl_shd.g_old_rec.tpl_information19;
396: End If;
397: If (p_rec.tpl_information20 = hr_api.g_varchar2) then
398: p_rec.tpl_information20 :=
399: ota_tpl_shd.g_old_rec.tpl_information20;
400: End If;
401: --

Line 463: Raise HR_Api.Validate_Enabled;

459: --
460: -- If we are validating then raise the Validate_Enabled exception
461: --
462: If p_validate then
463: Raise HR_Api.Validate_Enabled;
464: End If;
465: --
466: hr_utility.set_location(' Leaving:'||l_proc, 10);
467: Exception

Line 468: When HR_Api.Validate_Enabled Then

464: End If;
465: --
466: hr_utility.set_location(' Leaving:'||l_proc, 10);
467: Exception
468: When HR_Api.Validate_Enabled Then
469: --
470: -- As the Validate_Enabled exception has been raised
471: -- we must rollback to the savepoint
472: --

Line 482: p_business_group_id in number default hr_api.g_number,

478: -- ----------------------------------------------------------------------------
479: Procedure upd
480: (
481: p_price_list_id in number,
482: p_business_group_id in number default hr_api.g_number,
483: p_currency_code in varchar2 default hr_api.g_varchar2,
484: p_default_flag in varchar2 default hr_api.g_varchar2,
485: p_name in varchar2 default hr_api.g_varchar2,
486: p_object_version_number in out number,

Line 483: p_currency_code in varchar2 default hr_api.g_varchar2,

479: Procedure upd
480: (
481: p_price_list_id in number,
482: p_business_group_id in number default hr_api.g_number,
483: p_currency_code in varchar2 default hr_api.g_varchar2,
484: p_default_flag in varchar2 default hr_api.g_varchar2,
485: p_name in varchar2 default hr_api.g_varchar2,
486: p_object_version_number in out number,
487: p_price_list_type in varchar2 default hr_api.g_varchar2,

Line 484: p_default_flag in varchar2 default hr_api.g_varchar2,

480: (
481: p_price_list_id in number,
482: p_business_group_id in number default hr_api.g_number,
483: p_currency_code in varchar2 default hr_api.g_varchar2,
484: p_default_flag in varchar2 default hr_api.g_varchar2,
485: p_name in varchar2 default hr_api.g_varchar2,
486: p_object_version_number in out number,
487: p_price_list_type in varchar2 default hr_api.g_varchar2,
488: p_start_date in date default hr_api.g_date,

Line 485: p_name in varchar2 default hr_api.g_varchar2,

481: p_price_list_id in number,
482: p_business_group_id in number default hr_api.g_number,
483: p_currency_code in varchar2 default hr_api.g_varchar2,
484: p_default_flag in varchar2 default hr_api.g_varchar2,
485: p_name in varchar2 default hr_api.g_varchar2,
486: p_object_version_number in out number,
487: p_price_list_type in varchar2 default hr_api.g_varchar2,
488: p_start_date in date default hr_api.g_date,
489: p_comments in varchar2 default hr_api.g_varchar2,

Line 487: p_price_list_type in varchar2 default hr_api.g_varchar2,

483: p_currency_code in varchar2 default hr_api.g_varchar2,
484: p_default_flag in varchar2 default hr_api.g_varchar2,
485: p_name in varchar2 default hr_api.g_varchar2,
486: p_object_version_number in out number,
487: p_price_list_type in varchar2 default hr_api.g_varchar2,
488: p_start_date in date default hr_api.g_date,
489: p_comments in varchar2 default hr_api.g_varchar2,
490: p_description in varchar2 default hr_api.g_varchar2,
491: p_end_date in date default hr_api.g_date,

Line 488: p_start_date in date default hr_api.g_date,

484: p_default_flag in varchar2 default hr_api.g_varchar2,
485: p_name in varchar2 default hr_api.g_varchar2,
486: p_object_version_number in out number,
487: p_price_list_type in varchar2 default hr_api.g_varchar2,
488: p_start_date in date default hr_api.g_date,
489: p_comments in varchar2 default hr_api.g_varchar2,
490: p_description in varchar2 default hr_api.g_varchar2,
491: p_end_date in date default hr_api.g_date,
492: p_single_unit_price in number default hr_api.g_number,

Line 489: p_comments in varchar2 default hr_api.g_varchar2,

485: p_name in varchar2 default hr_api.g_varchar2,
486: p_object_version_number in out number,
487: p_price_list_type in varchar2 default hr_api.g_varchar2,
488: p_start_date in date default hr_api.g_date,
489: p_comments in varchar2 default hr_api.g_varchar2,
490: p_description in varchar2 default hr_api.g_varchar2,
491: p_end_date in date default hr_api.g_date,
492: p_single_unit_price in number default hr_api.g_number,
493: p_training_unit_type in varchar2 default hr_api.g_varchar2,

Line 490: p_description in varchar2 default hr_api.g_varchar2,

486: p_object_version_number in out number,
487: p_price_list_type in varchar2 default hr_api.g_varchar2,
488: p_start_date in date default hr_api.g_date,
489: p_comments in varchar2 default hr_api.g_varchar2,
490: p_description in varchar2 default hr_api.g_varchar2,
491: p_end_date in date default hr_api.g_date,
492: p_single_unit_price in number default hr_api.g_number,
493: p_training_unit_type in varchar2 default hr_api.g_varchar2,
494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,

Line 491: p_end_date in date default hr_api.g_date,

487: p_price_list_type in varchar2 default hr_api.g_varchar2,
488: p_start_date in date default hr_api.g_date,
489: p_comments in varchar2 default hr_api.g_varchar2,
490: p_description in varchar2 default hr_api.g_varchar2,
491: p_end_date in date default hr_api.g_date,
492: p_single_unit_price in number default hr_api.g_number,
493: p_training_unit_type in varchar2 default hr_api.g_varchar2,
494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,

Line 492: p_single_unit_price in number default hr_api.g_number,

488: p_start_date in date default hr_api.g_date,
489: p_comments in varchar2 default hr_api.g_varchar2,
490: p_description in varchar2 default hr_api.g_varchar2,
491: p_end_date in date default hr_api.g_date,
492: p_single_unit_price in number default hr_api.g_number,
493: p_training_unit_type in varchar2 default hr_api.g_varchar2,
494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,

Line 493: p_training_unit_type in varchar2 default hr_api.g_varchar2,

489: p_comments in varchar2 default hr_api.g_varchar2,
490: p_description in varchar2 default hr_api.g_varchar2,
491: p_end_date in date default hr_api.g_date,
492: p_single_unit_price in number default hr_api.g_number,
493: p_training_unit_type in varchar2 default hr_api.g_varchar2,
494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,

Line 494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,

490: p_description in varchar2 default hr_api.g_varchar2,
491: p_end_date in date default hr_api.g_date,
492: p_single_unit_price in number default hr_api.g_number,
493: p_training_unit_type in varchar2 default hr_api.g_varchar2,
494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,

Line 495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,

491: p_end_date in date default hr_api.g_date,
492: p_single_unit_price in number default hr_api.g_number,
493: p_training_unit_type in varchar2 default hr_api.g_varchar2,
494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,

Line 496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,

492: p_single_unit_price in number default hr_api.g_number,
493: p_training_unit_type in varchar2 default hr_api.g_varchar2,
494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,

Line 497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,

493: p_training_unit_type in varchar2 default hr_api.g_varchar2,
494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,

Line 498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,

494: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,

Line 499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,

495: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,

Line 500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,

496: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,

Line 501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,

497: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,

Line 502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,

498: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,

Line 503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,

499: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,

Line 504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,

500: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,

Line 505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,

501: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,

Line 506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,

502: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,

Line 507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,

503: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
511: p_tpl_information17 in varchar2 default hr_api.g_varchar2,

Line 508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,

504: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
511: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
512: p_tpl_information18 in varchar2 default hr_api.g_varchar2,

Line 509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,

505: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
511: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
512: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
513: p_tpl_information19 in varchar2 default hr_api.g_varchar2,

Line 510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,

506: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
511: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
512: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
513: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
514: p_tpl_information20 in varchar2 default hr_api.g_varchar2,

Line 511: p_tpl_information17 in varchar2 default hr_api.g_varchar2,

507: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
511: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
512: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
513: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
514: p_tpl_information20 in varchar2 default hr_api.g_varchar2,
515: p_validate in boolean default false

Line 512: p_tpl_information18 in varchar2 default hr_api.g_varchar2,

508: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
511: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
512: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
513: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
514: p_tpl_information20 in varchar2 default hr_api.g_varchar2,
515: p_validate in boolean default false
516: ) is

Line 513: p_tpl_information19 in varchar2 default hr_api.g_varchar2,

509: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
511: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
512: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
513: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
514: p_tpl_information20 in varchar2 default hr_api.g_varchar2,
515: p_validate in boolean default false
516: ) is
517: --

Line 514: p_tpl_information20 in varchar2 default hr_api.g_varchar2,

510: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
511: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
512: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
513: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
514: p_tpl_information20 in varchar2 default hr_api.g_varchar2,
515: p_validate in boolean default false
516: ) is
517: --
518: l_rec ota_tpl_shd.g_rec_type;