136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 10);
138: --
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tfl_api_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tfl_api_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
148: ota_tfl_api_shd.constraint_error
141: -- A check constraint has been violated
142: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tfl_api_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
148: ota_tfl_api_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
148: ota_tfl_api_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
153: ota_tfl_api_shd.constraint_error
146: -- Parent integrity has been violated
147: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
148: ota_tfl_api_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
153: ota_tfl_api_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
153: ota_tfl_api_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: ota_tfl_api_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End update_dml;
297: -- p_rec plsql record structure
298: -- to see if a system default is being used. If a system default
299: -- is being used then we must set to the 'current' argument value.
300: --
301: If (p_rec.finance_header_id = hr_api.g_number) then
302: p_rec.finance_header_id :=
303: ota_tfl_api_shd.g_old_rec.finance_header_id;
304: End If;
305: If (p_rec.cancelled_flag = hr_api.g_varchar2) then
301: If (p_rec.finance_header_id = hr_api.g_number) then
302: p_rec.finance_header_id :=
303: ota_tfl_api_shd.g_old_rec.finance_header_id;
304: End If;
305: If (p_rec.cancelled_flag = hr_api.g_varchar2) then
306: p_rec.cancelled_flag :=
307: ota_tfl_api_shd.g_old_rec.cancelled_flag;
308: End If;
309: If (p_rec.date_raised = hr_api.g_date) then
305: If (p_rec.cancelled_flag = hr_api.g_varchar2) then
306: p_rec.cancelled_flag :=
307: ota_tfl_api_shd.g_old_rec.cancelled_flag;
308: End If;
309: If (p_rec.date_raised = hr_api.g_date) then
310: p_rec.date_raised :=
311: ota_tfl_api_shd.g_old_rec.date_raised;
312: End If;
313: If (p_rec.line_type = hr_api.g_varchar2) then
309: If (p_rec.date_raised = hr_api.g_date) then
310: p_rec.date_raised :=
311: ota_tfl_api_shd.g_old_rec.date_raised;
312: End If;
313: If (p_rec.line_type = hr_api.g_varchar2) then
314: p_rec.line_type :=
315: ota_tfl_api_shd.g_old_rec.line_type;
316: End If;
317: If (p_rec.sequence_number = hr_api.g_number) then
313: If (p_rec.line_type = hr_api.g_varchar2) then
314: p_rec.line_type :=
315: ota_tfl_api_shd.g_old_rec.line_type;
316: End If;
317: If (p_rec.sequence_number = hr_api.g_number) then
318: p_rec.sequence_number :=
319: ota_tfl_api_shd.g_old_rec.sequence_number;
320: End If;
321: If (p_rec.transfer_status = hr_api.g_varchar2) then
317: If (p_rec.sequence_number = hr_api.g_number) then
318: p_rec.sequence_number :=
319: ota_tfl_api_shd.g_old_rec.sequence_number;
320: End If;
321: If (p_rec.transfer_status = hr_api.g_varchar2) then
322: p_rec.transfer_status :=
323: ota_tfl_api_shd.g_old_rec.transfer_status;
324: End If;
325: If (p_rec.comments = hr_api.g_varchar2) then
321: If (p_rec.transfer_status = hr_api.g_varchar2) then
322: p_rec.transfer_status :=
323: ota_tfl_api_shd.g_old_rec.transfer_status;
324: End If;
325: If (p_rec.comments = hr_api.g_varchar2) then
326: p_rec.comments :=
327: ota_tfl_api_shd.g_old_rec.comments;
328: End If;
329: If (p_rec.currency_code = hr_api.g_varchar2) then
325: If (p_rec.comments = hr_api.g_varchar2) then
326: p_rec.comments :=
327: ota_tfl_api_shd.g_old_rec.comments;
328: End If;
329: If (p_rec.currency_code = hr_api.g_varchar2) then
330: p_rec.currency_code :=
331: ota_tfl_api_shd.g_old_rec.currency_code;
332: End If;
333: If (p_rec.money_amount = hr_api.g_number) then
329: If (p_rec.currency_code = hr_api.g_varchar2) then
330: p_rec.currency_code :=
331: ota_tfl_api_shd.g_old_rec.currency_code;
332: End If;
333: If (p_rec.money_amount = hr_api.g_number) then
334: p_rec.money_amount :=
335: ota_tfl_api_shd.g_old_rec.money_amount;
336: End If;
337: If (p_rec.standard_amount = hr_api.g_number) then
333: If (p_rec.money_amount = hr_api.g_number) then
334: p_rec.money_amount :=
335: ota_tfl_api_shd.g_old_rec.money_amount;
336: End If;
337: If (p_rec.standard_amount = hr_api.g_number) then
338: p_rec.standard_amount :=
339: ota_tfl_api_shd.g_old_rec.standard_amount;
340: End If;
341: If (p_rec.trans_information_category = hr_api.g_varchar2) then
337: If (p_rec.standard_amount = hr_api.g_number) then
338: p_rec.standard_amount :=
339: ota_tfl_api_shd.g_old_rec.standard_amount;
340: End If;
341: If (p_rec.trans_information_category = hr_api.g_varchar2) then
342: p_rec.trans_information_category :=
343: ota_tfl_api_shd.g_old_rec.trans_information_category;
344: End If;
345: If (p_rec.trans_information1 = hr_api.g_varchar2) then
341: If (p_rec.trans_information_category = hr_api.g_varchar2) then
342: p_rec.trans_information_category :=
343: ota_tfl_api_shd.g_old_rec.trans_information_category;
344: End If;
345: If (p_rec.trans_information1 = hr_api.g_varchar2) then
346: p_rec.trans_information1 :=
347: ota_tfl_api_shd.g_old_rec.trans_information1;
348: End If;
349: If (p_rec.trans_information10 = hr_api.g_varchar2) then
345: If (p_rec.trans_information1 = hr_api.g_varchar2) then
346: p_rec.trans_information1 :=
347: ota_tfl_api_shd.g_old_rec.trans_information1;
348: End If;
349: If (p_rec.trans_information10 = hr_api.g_varchar2) then
350: p_rec.trans_information10 :=
351: ota_tfl_api_shd.g_old_rec.trans_information10;
352: End If;
353: If (p_rec.trans_information11 = hr_api.g_varchar2) then
349: If (p_rec.trans_information10 = hr_api.g_varchar2) then
350: p_rec.trans_information10 :=
351: ota_tfl_api_shd.g_old_rec.trans_information10;
352: End If;
353: If (p_rec.trans_information11 = hr_api.g_varchar2) then
354: p_rec.trans_information11 :=
355: ota_tfl_api_shd.g_old_rec.trans_information11;
356: End If;
357: If (p_rec.trans_information12 = hr_api.g_varchar2) then
353: If (p_rec.trans_information11 = hr_api.g_varchar2) then
354: p_rec.trans_information11 :=
355: ota_tfl_api_shd.g_old_rec.trans_information11;
356: End If;
357: If (p_rec.trans_information12 = hr_api.g_varchar2) then
358: p_rec.trans_information12 :=
359: ota_tfl_api_shd.g_old_rec.trans_information12;
360: End If;
361: If (p_rec.trans_information13 = hr_api.g_varchar2) then
357: If (p_rec.trans_information12 = hr_api.g_varchar2) then
358: p_rec.trans_information12 :=
359: ota_tfl_api_shd.g_old_rec.trans_information12;
360: End If;
361: If (p_rec.trans_information13 = hr_api.g_varchar2) then
362: p_rec.trans_information13 :=
363: ota_tfl_api_shd.g_old_rec.trans_information13;
364: End If;
365: If (p_rec.trans_information14 = hr_api.g_varchar2) then
361: If (p_rec.trans_information13 = hr_api.g_varchar2) then
362: p_rec.trans_information13 :=
363: ota_tfl_api_shd.g_old_rec.trans_information13;
364: End If;
365: If (p_rec.trans_information14 = hr_api.g_varchar2) then
366: p_rec.trans_information14 :=
367: ota_tfl_api_shd.g_old_rec.trans_information14;
368: End If;
369: If (p_rec.trans_information15 = hr_api.g_varchar2) then
365: If (p_rec.trans_information14 = hr_api.g_varchar2) then
366: p_rec.trans_information14 :=
367: ota_tfl_api_shd.g_old_rec.trans_information14;
368: End If;
369: If (p_rec.trans_information15 = hr_api.g_varchar2) then
370: p_rec.trans_information15 :=
371: ota_tfl_api_shd.g_old_rec.trans_information15;
372: End If;
373: If (p_rec.trans_information16 = hr_api.g_varchar2) then
369: If (p_rec.trans_information15 = hr_api.g_varchar2) then
370: p_rec.trans_information15 :=
371: ota_tfl_api_shd.g_old_rec.trans_information15;
372: End If;
373: If (p_rec.trans_information16 = hr_api.g_varchar2) then
374: p_rec.trans_information16 :=
375: ota_tfl_api_shd.g_old_rec.trans_information16;
376: End If;
377: If (p_rec.trans_information17 = hr_api.g_varchar2) then
373: If (p_rec.trans_information16 = hr_api.g_varchar2) then
374: p_rec.trans_information16 :=
375: ota_tfl_api_shd.g_old_rec.trans_information16;
376: End If;
377: If (p_rec.trans_information17 = hr_api.g_varchar2) then
378: p_rec.trans_information17 :=
379: ota_tfl_api_shd.g_old_rec.trans_information17;
380: End If;
381: If (p_rec.trans_information18 = hr_api.g_varchar2) then
377: If (p_rec.trans_information17 = hr_api.g_varchar2) then
378: p_rec.trans_information17 :=
379: ota_tfl_api_shd.g_old_rec.trans_information17;
380: End If;
381: If (p_rec.trans_information18 = hr_api.g_varchar2) then
382: p_rec.trans_information18 :=
383: ota_tfl_api_shd.g_old_rec.trans_information18;
384: End If;
385: If (p_rec.trans_information19 = hr_api.g_varchar2) then
381: If (p_rec.trans_information18 = hr_api.g_varchar2) then
382: p_rec.trans_information18 :=
383: ota_tfl_api_shd.g_old_rec.trans_information18;
384: End If;
385: If (p_rec.trans_information19 = hr_api.g_varchar2) then
386: p_rec.trans_information19 :=
387: ota_tfl_api_shd.g_old_rec.trans_information19;
388: End If;
389: If (p_rec.trans_information2 = hr_api.g_varchar2) then
385: If (p_rec.trans_information19 = hr_api.g_varchar2) then
386: p_rec.trans_information19 :=
387: ota_tfl_api_shd.g_old_rec.trans_information19;
388: End If;
389: If (p_rec.trans_information2 = hr_api.g_varchar2) then
390: p_rec.trans_information2 :=
391: ota_tfl_api_shd.g_old_rec.trans_information2;
392: End If;
393: If (p_rec.trans_information20 = hr_api.g_varchar2) then
389: If (p_rec.trans_information2 = hr_api.g_varchar2) then
390: p_rec.trans_information2 :=
391: ota_tfl_api_shd.g_old_rec.trans_information2;
392: End If;
393: If (p_rec.trans_information20 = hr_api.g_varchar2) then
394: p_rec.trans_information20 :=
395: ota_tfl_api_shd.g_old_rec.trans_information20;
396: End If;
397: If (p_rec.trans_information3 = hr_api.g_varchar2) then
393: If (p_rec.trans_information20 = hr_api.g_varchar2) then
394: p_rec.trans_information20 :=
395: ota_tfl_api_shd.g_old_rec.trans_information20;
396: End If;
397: If (p_rec.trans_information3 = hr_api.g_varchar2) then
398: p_rec.trans_information3 :=
399: ota_tfl_api_shd.g_old_rec.trans_information3;
400: End If;
401: If (p_rec.trans_information4 = hr_api.g_varchar2) then
397: If (p_rec.trans_information3 = hr_api.g_varchar2) then
398: p_rec.trans_information3 :=
399: ota_tfl_api_shd.g_old_rec.trans_information3;
400: End If;
401: If (p_rec.trans_information4 = hr_api.g_varchar2) then
402: p_rec.trans_information4 :=
403: ota_tfl_api_shd.g_old_rec.trans_information4;
404: End If;
405: If (p_rec.trans_information5 = hr_api.g_varchar2) then
401: If (p_rec.trans_information4 = hr_api.g_varchar2) then
402: p_rec.trans_information4 :=
403: ota_tfl_api_shd.g_old_rec.trans_information4;
404: End If;
405: If (p_rec.trans_information5 = hr_api.g_varchar2) then
406: p_rec.trans_information5 :=
407: ota_tfl_api_shd.g_old_rec.trans_information5;
408: End If;
409: If (p_rec.trans_information6 = hr_api.g_varchar2) then
405: If (p_rec.trans_information5 = hr_api.g_varchar2) then
406: p_rec.trans_information5 :=
407: ota_tfl_api_shd.g_old_rec.trans_information5;
408: End If;
409: If (p_rec.trans_information6 = hr_api.g_varchar2) then
410: p_rec.trans_information6 :=
411: ota_tfl_api_shd.g_old_rec.trans_information6;
412: End If;
413: If (p_rec.trans_information7 = hr_api.g_varchar2) then
409: If (p_rec.trans_information6 = hr_api.g_varchar2) then
410: p_rec.trans_information6 :=
411: ota_tfl_api_shd.g_old_rec.trans_information6;
412: End If;
413: If (p_rec.trans_information7 = hr_api.g_varchar2) then
414: p_rec.trans_information7 :=
415: ota_tfl_api_shd.g_old_rec.trans_information7;
416: End If;
417: If (p_rec.trans_information8 = hr_api.g_varchar2) then
413: If (p_rec.trans_information7 = hr_api.g_varchar2) then
414: p_rec.trans_information7 :=
415: ota_tfl_api_shd.g_old_rec.trans_information7;
416: End If;
417: If (p_rec.trans_information8 = hr_api.g_varchar2) then
418: p_rec.trans_information8 :=
419: ota_tfl_api_shd.g_old_rec.trans_information8;
420: End If;
421: If (p_rec.trans_information9 = hr_api.g_varchar2) then
417: If (p_rec.trans_information8 = hr_api.g_varchar2) then
418: p_rec.trans_information8 :=
419: ota_tfl_api_shd.g_old_rec.trans_information8;
420: End If;
421: If (p_rec.trans_information9 = hr_api.g_varchar2) then
422: p_rec.trans_information9 :=
423: ota_tfl_api_shd.g_old_rec.trans_information9;
424: End If;
425: If (p_rec.transfer_date = hr_api.g_date) then
421: If (p_rec.trans_information9 = hr_api.g_varchar2) then
422: p_rec.trans_information9 :=
423: ota_tfl_api_shd.g_old_rec.trans_information9;
424: End If;
425: If (p_rec.transfer_date = hr_api.g_date) then
426: p_rec.transfer_date :=
427: ota_tfl_api_shd.g_old_rec.transfer_date;
428: End If;
429: If (p_rec.transfer_message = hr_api.g_varchar2) then
425: If (p_rec.transfer_date = hr_api.g_date) then
426: p_rec.transfer_date :=
427: ota_tfl_api_shd.g_old_rec.transfer_date;
428: End If;
429: If (p_rec.transfer_message = hr_api.g_varchar2) then
430: p_rec.transfer_message :=
431: ota_tfl_api_shd.g_old_rec.transfer_message;
432: End If;
433: If (p_rec.unitary_amount = hr_api.g_number) then
429: If (p_rec.transfer_message = hr_api.g_varchar2) then
430: p_rec.transfer_message :=
431: ota_tfl_api_shd.g_old_rec.transfer_message;
432: End If;
433: If (p_rec.unitary_amount = hr_api.g_number) then
434: p_rec.unitary_amount :=
435: ota_tfl_api_shd.g_old_rec.unitary_amount;
436: End If;
437: If (p_rec.booking_deal_id = hr_api.g_number) then
433: If (p_rec.unitary_amount = hr_api.g_number) then
434: p_rec.unitary_amount :=
435: ota_tfl_api_shd.g_old_rec.unitary_amount;
436: End If;
437: If (p_rec.booking_deal_id = hr_api.g_number) then
438: p_rec.booking_deal_id :=
439: ota_tfl_api_shd.g_old_rec.booking_deal_id;
440: End If;
441: If (p_rec.booking_id = hr_api.g_number) then
437: If (p_rec.booking_deal_id = hr_api.g_number) then
438: p_rec.booking_deal_id :=
439: ota_tfl_api_shd.g_old_rec.booking_deal_id;
440: End If;
441: If (p_rec.booking_id = hr_api.g_number) then
442: p_rec.booking_id :=
443: ota_tfl_api_shd.g_old_rec.booking_id;
444: End If;
445: If (p_rec.resource_allocation_id = hr_api.g_number) then
441: If (p_rec.booking_id = hr_api.g_number) then
442: p_rec.booking_id :=
443: ota_tfl_api_shd.g_old_rec.booking_id;
444: End If;
445: If (p_rec.resource_allocation_id = hr_api.g_number) then
446: p_rec.resource_allocation_id :=
447: ota_tfl_api_shd.g_old_rec.resource_allocation_id;
448: End If;
449: If (p_rec.resource_booking_id = hr_api.g_number) then
445: If (p_rec.resource_allocation_id = hr_api.g_number) then
446: p_rec.resource_allocation_id :=
447: ota_tfl_api_shd.g_old_rec.resource_allocation_id;
448: End If;
449: If (p_rec.resource_booking_id = hr_api.g_number) then
450: p_rec.resource_booking_id :=
451: ota_tfl_api_shd.g_old_rec.resource_booking_id;
452: End If;
453: If (p_rec.tfl_information_category = hr_api.g_varchar2) then
449: If (p_rec.resource_booking_id = hr_api.g_number) then
450: p_rec.resource_booking_id :=
451: ota_tfl_api_shd.g_old_rec.resource_booking_id;
452: End If;
453: If (p_rec.tfl_information_category = hr_api.g_varchar2) then
454: p_rec.tfl_information_category :=
455: ota_tfl_api_shd.g_old_rec.tfl_information_category;
456: End If;
457: If (p_rec.tfl_information1 = hr_api.g_varchar2) then
453: If (p_rec.tfl_information_category = hr_api.g_varchar2) then
454: p_rec.tfl_information_category :=
455: ota_tfl_api_shd.g_old_rec.tfl_information_category;
456: End If;
457: If (p_rec.tfl_information1 = hr_api.g_varchar2) then
458: p_rec.tfl_information1 :=
459: ota_tfl_api_shd.g_old_rec.tfl_information1;
460: End If;
461: If (p_rec.tfl_information2 = hr_api.g_varchar2) then
457: If (p_rec.tfl_information1 = hr_api.g_varchar2) then
458: p_rec.tfl_information1 :=
459: ota_tfl_api_shd.g_old_rec.tfl_information1;
460: End If;
461: If (p_rec.tfl_information2 = hr_api.g_varchar2) then
462: p_rec.tfl_information2 :=
463: ota_tfl_api_shd.g_old_rec.tfl_information2;
464: End If;
465: If (p_rec.tfl_information3 = hr_api.g_varchar2) then
461: If (p_rec.tfl_information2 = hr_api.g_varchar2) then
462: p_rec.tfl_information2 :=
463: ota_tfl_api_shd.g_old_rec.tfl_information2;
464: End If;
465: If (p_rec.tfl_information3 = hr_api.g_varchar2) then
466: p_rec.tfl_information3 :=
467: ota_tfl_api_shd.g_old_rec.tfl_information3;
468: End If;
469: If (p_rec.tfl_information4 = hr_api.g_varchar2) then
465: If (p_rec.tfl_information3 = hr_api.g_varchar2) then
466: p_rec.tfl_information3 :=
467: ota_tfl_api_shd.g_old_rec.tfl_information3;
468: End If;
469: If (p_rec.tfl_information4 = hr_api.g_varchar2) then
470: p_rec.tfl_information4 :=
471: ota_tfl_api_shd.g_old_rec.tfl_information4;
472: End If;
473: If (p_rec.tfl_information5 = hr_api.g_varchar2) then
469: If (p_rec.tfl_information4 = hr_api.g_varchar2) then
470: p_rec.tfl_information4 :=
471: ota_tfl_api_shd.g_old_rec.tfl_information4;
472: End If;
473: If (p_rec.tfl_information5 = hr_api.g_varchar2) then
474: p_rec.tfl_information5 :=
475: ota_tfl_api_shd.g_old_rec.tfl_information5;
476: End If;
477: If (p_rec.tfl_information6 = hr_api.g_varchar2) then
473: If (p_rec.tfl_information5 = hr_api.g_varchar2) then
474: p_rec.tfl_information5 :=
475: ota_tfl_api_shd.g_old_rec.tfl_information5;
476: End If;
477: If (p_rec.tfl_information6 = hr_api.g_varchar2) then
478: p_rec.tfl_information6 :=
479: ota_tfl_api_shd.g_old_rec.tfl_information6;
480: End If;
481: If (p_rec.tfl_information7 = hr_api.g_varchar2) then
477: If (p_rec.tfl_information6 = hr_api.g_varchar2) then
478: p_rec.tfl_information6 :=
479: ota_tfl_api_shd.g_old_rec.tfl_information6;
480: End If;
481: If (p_rec.tfl_information7 = hr_api.g_varchar2) then
482: p_rec.tfl_information7 :=
483: ota_tfl_api_shd.g_old_rec.tfl_information7;
484: End If;
485: If (p_rec.tfl_information8 = hr_api.g_varchar2) then
481: If (p_rec.tfl_information7 = hr_api.g_varchar2) then
482: p_rec.tfl_information7 :=
483: ota_tfl_api_shd.g_old_rec.tfl_information7;
484: End If;
485: If (p_rec.tfl_information8 = hr_api.g_varchar2) then
486: p_rec.tfl_information8 :=
487: ota_tfl_api_shd.g_old_rec.tfl_information8;
488: End If;
489: If (p_rec.tfl_information9 = hr_api.g_varchar2) then
485: If (p_rec.tfl_information8 = hr_api.g_varchar2) then
486: p_rec.tfl_information8 :=
487: ota_tfl_api_shd.g_old_rec.tfl_information8;
488: End If;
489: If (p_rec.tfl_information9 = hr_api.g_varchar2) then
490: p_rec.tfl_information9 :=
491: ota_tfl_api_shd.g_old_rec.tfl_information9;
492: End If;
493: If (p_rec.tfl_information10 = hr_api.g_varchar2) then
489: If (p_rec.tfl_information9 = hr_api.g_varchar2) then
490: p_rec.tfl_information9 :=
491: ota_tfl_api_shd.g_old_rec.tfl_information9;
492: End If;
493: If (p_rec.tfl_information10 = hr_api.g_varchar2) then
494: p_rec.tfl_information10 :=
495: ota_tfl_api_shd.g_old_rec.tfl_information10;
496: End If;
497: If (p_rec.tfl_information11 = hr_api.g_varchar2) then
493: If (p_rec.tfl_information10 = hr_api.g_varchar2) then
494: p_rec.tfl_information10 :=
495: ota_tfl_api_shd.g_old_rec.tfl_information10;
496: End If;
497: If (p_rec.tfl_information11 = hr_api.g_varchar2) then
498: p_rec.tfl_information11 :=
499: ota_tfl_api_shd.g_old_rec.tfl_information11;
500: End If;
501: If (p_rec.tfl_information12 = hr_api.g_varchar2) then
497: If (p_rec.tfl_information11 = hr_api.g_varchar2) then
498: p_rec.tfl_information11 :=
499: ota_tfl_api_shd.g_old_rec.tfl_information11;
500: End If;
501: If (p_rec.tfl_information12 = hr_api.g_varchar2) then
502: p_rec.tfl_information12 :=
503: ota_tfl_api_shd.g_old_rec.tfl_information12;
504: End If;
505: If (p_rec.tfl_information13 = hr_api.g_varchar2) then
501: If (p_rec.tfl_information12 = hr_api.g_varchar2) then
502: p_rec.tfl_information12 :=
503: ota_tfl_api_shd.g_old_rec.tfl_information12;
504: End If;
505: If (p_rec.tfl_information13 = hr_api.g_varchar2) then
506: p_rec.tfl_information13 :=
507: ota_tfl_api_shd.g_old_rec.tfl_information13;
508: End If;
509: If (p_rec.tfl_information14 = hr_api.g_varchar2) then
505: If (p_rec.tfl_information13 = hr_api.g_varchar2) then
506: p_rec.tfl_information13 :=
507: ota_tfl_api_shd.g_old_rec.tfl_information13;
508: End If;
509: If (p_rec.tfl_information14 = hr_api.g_varchar2) then
510: p_rec.tfl_information14 :=
511: ota_tfl_api_shd.g_old_rec.tfl_information14;
512: End If;
513: If (p_rec.tfl_information15 = hr_api.g_varchar2) then
509: If (p_rec.tfl_information14 = hr_api.g_varchar2) then
510: p_rec.tfl_information14 :=
511: ota_tfl_api_shd.g_old_rec.tfl_information14;
512: End If;
513: If (p_rec.tfl_information15 = hr_api.g_varchar2) then
514: p_rec.tfl_information15 :=
515: ota_tfl_api_shd.g_old_rec.tfl_information15;
516: End If;
517: If (p_rec.tfl_information16 = hr_api.g_varchar2) then
513: If (p_rec.tfl_information15 = hr_api.g_varchar2) then
514: p_rec.tfl_information15 :=
515: ota_tfl_api_shd.g_old_rec.tfl_information15;
516: End If;
517: If (p_rec.tfl_information16 = hr_api.g_varchar2) then
518: p_rec.tfl_information16 :=
519: ota_tfl_api_shd.g_old_rec.tfl_information16;
520: End If;
521: If (p_rec.tfl_information17 = hr_api.g_varchar2) then
517: If (p_rec.tfl_information16 = hr_api.g_varchar2) then
518: p_rec.tfl_information16 :=
519: ota_tfl_api_shd.g_old_rec.tfl_information16;
520: End If;
521: If (p_rec.tfl_information17 = hr_api.g_varchar2) then
522: p_rec.tfl_information17 :=
523: ota_tfl_api_shd.g_old_rec.tfl_information17;
524: End If;
525: If (p_rec.tfl_information18 = hr_api.g_varchar2) then
521: If (p_rec.tfl_information17 = hr_api.g_varchar2) then
522: p_rec.tfl_information17 :=
523: ota_tfl_api_shd.g_old_rec.tfl_information17;
524: End If;
525: If (p_rec.tfl_information18 = hr_api.g_varchar2) then
526: p_rec.tfl_information18 :=
527: ota_tfl_api_shd.g_old_rec.tfl_information18;
528: End If;
529: If (p_rec.tfl_information19 = hr_api.g_varchar2) then
525: If (p_rec.tfl_information18 = hr_api.g_varchar2) then
526: p_rec.tfl_information18 :=
527: ota_tfl_api_shd.g_old_rec.tfl_information18;
528: End If;
529: If (p_rec.tfl_information19 = hr_api.g_varchar2) then
530: p_rec.tfl_information19 :=
531: ota_tfl_api_shd.g_old_rec.tfl_information19;
532: End If;
533: If (p_rec.tfl_information20 = hr_api.g_varchar2) then
529: If (p_rec.tfl_information19 = hr_api.g_varchar2) then
530: p_rec.tfl_information19 :=
531: ota_tfl_api_shd.g_old_rec.tfl_information19;
532: End If;
533: If (p_rec.tfl_information20 = hr_api.g_varchar2) then
534: p_rec.tfl_information20 :=
535: ota_tfl_api_shd.g_old_rec.tfl_information20;
536: End If;
537: --
609: --
610: -- If we are validating then raise the Validate_Enabled exception
611: --
612: If p_validate then
613: Raise HR_Api.Validate_Enabled;
614: End If;
615: --
616: hr_utility.set_location(' Leaving:'||l_proc, 10);
617: Exception
614: End If;
615: --
616: hr_utility.set_location(' Leaving:'||l_proc, 10);
617: Exception
618: When HR_Api.Validate_Enabled Then
619: --
620: -- As the Validate_Enabled exception has been raised
621: -- we must rollback to the savepoint
622: --
628: -- ----------------------------------------------------------------------------
629: Procedure upd
630: (
631: p_finance_line_id in number,
632: p_finance_header_id in number default hr_api.g_number,
633: p_cancelled_flag in varchar2 default hr_api.g_varchar2,
634: p_date_raised in out nocopy date,
635: p_line_type in varchar2 default hr_api.g_varchar2,
636: p_object_version_number in out nocopy number,
629: Procedure upd
630: (
631: p_finance_line_id in number,
632: p_finance_header_id in number default hr_api.g_number,
633: p_cancelled_flag in varchar2 default hr_api.g_varchar2,
634: p_date_raised in out nocopy date,
635: p_line_type in varchar2 default hr_api.g_varchar2,
636: p_object_version_number in out nocopy number,
637: p_sequence_number in out nocopy number,
631: p_finance_line_id in number,
632: p_finance_header_id in number default hr_api.g_number,
633: p_cancelled_flag in varchar2 default hr_api.g_varchar2,
634: p_date_raised in out nocopy date,
635: p_line_type in varchar2 default hr_api.g_varchar2,
636: p_object_version_number in out nocopy number,
637: p_sequence_number in out nocopy number,
638: p_transfer_status in varchar2 default hr_api.g_varchar2,
639: p_comments in varchar2 default hr_api.g_varchar2,
634: p_date_raised in out nocopy date,
635: p_line_type in varchar2 default hr_api.g_varchar2,
636: p_object_version_number in out nocopy number,
637: p_sequence_number in out nocopy number,
638: p_transfer_status in varchar2 default hr_api.g_varchar2,
639: p_comments in varchar2 default hr_api.g_varchar2,
640: p_currency_code in varchar2 default hr_api.g_varchar2,
641: p_money_amount in number default hr_api.g_number,
642: p_standard_amount in number default hr_api.g_number,
635: p_line_type in varchar2 default hr_api.g_varchar2,
636: p_object_version_number in out nocopy number,
637: p_sequence_number in out nocopy number,
638: p_transfer_status in varchar2 default hr_api.g_varchar2,
639: p_comments in varchar2 default hr_api.g_varchar2,
640: p_currency_code in varchar2 default hr_api.g_varchar2,
641: p_money_amount in number default hr_api.g_number,
642: p_standard_amount in number default hr_api.g_number,
643: p_trans_information_category in varchar2 default hr_api.g_varchar2,
636: p_object_version_number in out nocopy number,
637: p_sequence_number in out nocopy number,
638: p_transfer_status in varchar2 default hr_api.g_varchar2,
639: p_comments in varchar2 default hr_api.g_varchar2,
640: p_currency_code in varchar2 default hr_api.g_varchar2,
641: p_money_amount in number default hr_api.g_number,
642: p_standard_amount in number default hr_api.g_number,
643: p_trans_information_category in varchar2 default hr_api.g_varchar2,
644: p_trans_information1 in varchar2 default hr_api.g_varchar2,
637: p_sequence_number in out nocopy number,
638: p_transfer_status in varchar2 default hr_api.g_varchar2,
639: p_comments in varchar2 default hr_api.g_varchar2,
640: p_currency_code in varchar2 default hr_api.g_varchar2,
641: p_money_amount in number default hr_api.g_number,
642: p_standard_amount in number default hr_api.g_number,
643: p_trans_information_category in varchar2 default hr_api.g_varchar2,
644: p_trans_information1 in varchar2 default hr_api.g_varchar2,
645: p_trans_information10 in varchar2 default hr_api.g_varchar2,
638: p_transfer_status in varchar2 default hr_api.g_varchar2,
639: p_comments in varchar2 default hr_api.g_varchar2,
640: p_currency_code in varchar2 default hr_api.g_varchar2,
641: p_money_amount in number default hr_api.g_number,
642: p_standard_amount in number default hr_api.g_number,
643: p_trans_information_category in varchar2 default hr_api.g_varchar2,
644: p_trans_information1 in varchar2 default hr_api.g_varchar2,
645: p_trans_information10 in varchar2 default hr_api.g_varchar2,
646: p_trans_information11 in varchar2 default hr_api.g_varchar2,
639: p_comments in varchar2 default hr_api.g_varchar2,
640: p_currency_code in varchar2 default hr_api.g_varchar2,
641: p_money_amount in number default hr_api.g_number,
642: p_standard_amount in number default hr_api.g_number,
643: p_trans_information_category in varchar2 default hr_api.g_varchar2,
644: p_trans_information1 in varchar2 default hr_api.g_varchar2,
645: p_trans_information10 in varchar2 default hr_api.g_varchar2,
646: p_trans_information11 in varchar2 default hr_api.g_varchar2,
647: p_trans_information12 in varchar2 default hr_api.g_varchar2,
640: p_currency_code in varchar2 default hr_api.g_varchar2,
641: p_money_amount in number default hr_api.g_number,
642: p_standard_amount in number default hr_api.g_number,
643: p_trans_information_category in varchar2 default hr_api.g_varchar2,
644: p_trans_information1 in varchar2 default hr_api.g_varchar2,
645: p_trans_information10 in varchar2 default hr_api.g_varchar2,
646: p_trans_information11 in varchar2 default hr_api.g_varchar2,
647: p_trans_information12 in varchar2 default hr_api.g_varchar2,
648: p_trans_information13 in varchar2 default hr_api.g_varchar2,
641: p_money_amount in number default hr_api.g_number,
642: p_standard_amount in number default hr_api.g_number,
643: p_trans_information_category in varchar2 default hr_api.g_varchar2,
644: p_trans_information1 in varchar2 default hr_api.g_varchar2,
645: p_trans_information10 in varchar2 default hr_api.g_varchar2,
646: p_trans_information11 in varchar2 default hr_api.g_varchar2,
647: p_trans_information12 in varchar2 default hr_api.g_varchar2,
648: p_trans_information13 in varchar2 default hr_api.g_varchar2,
649: p_trans_information14 in varchar2 default hr_api.g_varchar2,
642: p_standard_amount in number default hr_api.g_number,
643: p_trans_information_category in varchar2 default hr_api.g_varchar2,
644: p_trans_information1 in varchar2 default hr_api.g_varchar2,
645: p_trans_information10 in varchar2 default hr_api.g_varchar2,
646: p_trans_information11 in varchar2 default hr_api.g_varchar2,
647: p_trans_information12 in varchar2 default hr_api.g_varchar2,
648: p_trans_information13 in varchar2 default hr_api.g_varchar2,
649: p_trans_information14 in varchar2 default hr_api.g_varchar2,
650: p_trans_information15 in varchar2 default hr_api.g_varchar2,
643: p_trans_information_category in varchar2 default hr_api.g_varchar2,
644: p_trans_information1 in varchar2 default hr_api.g_varchar2,
645: p_trans_information10 in varchar2 default hr_api.g_varchar2,
646: p_trans_information11 in varchar2 default hr_api.g_varchar2,
647: p_trans_information12 in varchar2 default hr_api.g_varchar2,
648: p_trans_information13 in varchar2 default hr_api.g_varchar2,
649: p_trans_information14 in varchar2 default hr_api.g_varchar2,
650: p_trans_information15 in varchar2 default hr_api.g_varchar2,
651: p_trans_information16 in varchar2 default hr_api.g_varchar2,
644: p_trans_information1 in varchar2 default hr_api.g_varchar2,
645: p_trans_information10 in varchar2 default hr_api.g_varchar2,
646: p_trans_information11 in varchar2 default hr_api.g_varchar2,
647: p_trans_information12 in varchar2 default hr_api.g_varchar2,
648: p_trans_information13 in varchar2 default hr_api.g_varchar2,
649: p_trans_information14 in varchar2 default hr_api.g_varchar2,
650: p_trans_information15 in varchar2 default hr_api.g_varchar2,
651: p_trans_information16 in varchar2 default hr_api.g_varchar2,
652: p_trans_information17 in varchar2 default hr_api.g_varchar2,
645: p_trans_information10 in varchar2 default hr_api.g_varchar2,
646: p_trans_information11 in varchar2 default hr_api.g_varchar2,
647: p_trans_information12 in varchar2 default hr_api.g_varchar2,
648: p_trans_information13 in varchar2 default hr_api.g_varchar2,
649: p_trans_information14 in varchar2 default hr_api.g_varchar2,
650: p_trans_information15 in varchar2 default hr_api.g_varchar2,
651: p_trans_information16 in varchar2 default hr_api.g_varchar2,
652: p_trans_information17 in varchar2 default hr_api.g_varchar2,
653: p_trans_information18 in varchar2 default hr_api.g_varchar2,
646: p_trans_information11 in varchar2 default hr_api.g_varchar2,
647: p_trans_information12 in varchar2 default hr_api.g_varchar2,
648: p_trans_information13 in varchar2 default hr_api.g_varchar2,
649: p_trans_information14 in varchar2 default hr_api.g_varchar2,
650: p_trans_information15 in varchar2 default hr_api.g_varchar2,
651: p_trans_information16 in varchar2 default hr_api.g_varchar2,
652: p_trans_information17 in varchar2 default hr_api.g_varchar2,
653: p_trans_information18 in varchar2 default hr_api.g_varchar2,
654: p_trans_information19 in varchar2 default hr_api.g_varchar2,
647: p_trans_information12 in varchar2 default hr_api.g_varchar2,
648: p_trans_information13 in varchar2 default hr_api.g_varchar2,
649: p_trans_information14 in varchar2 default hr_api.g_varchar2,
650: p_trans_information15 in varchar2 default hr_api.g_varchar2,
651: p_trans_information16 in varchar2 default hr_api.g_varchar2,
652: p_trans_information17 in varchar2 default hr_api.g_varchar2,
653: p_trans_information18 in varchar2 default hr_api.g_varchar2,
654: p_trans_information19 in varchar2 default hr_api.g_varchar2,
655: p_trans_information2 in varchar2 default hr_api.g_varchar2,
648: p_trans_information13 in varchar2 default hr_api.g_varchar2,
649: p_trans_information14 in varchar2 default hr_api.g_varchar2,
650: p_trans_information15 in varchar2 default hr_api.g_varchar2,
651: p_trans_information16 in varchar2 default hr_api.g_varchar2,
652: p_trans_information17 in varchar2 default hr_api.g_varchar2,
653: p_trans_information18 in varchar2 default hr_api.g_varchar2,
654: p_trans_information19 in varchar2 default hr_api.g_varchar2,
655: p_trans_information2 in varchar2 default hr_api.g_varchar2,
656: p_trans_information20 in varchar2 default hr_api.g_varchar2,
649: p_trans_information14 in varchar2 default hr_api.g_varchar2,
650: p_trans_information15 in varchar2 default hr_api.g_varchar2,
651: p_trans_information16 in varchar2 default hr_api.g_varchar2,
652: p_trans_information17 in varchar2 default hr_api.g_varchar2,
653: p_trans_information18 in varchar2 default hr_api.g_varchar2,
654: p_trans_information19 in varchar2 default hr_api.g_varchar2,
655: p_trans_information2 in varchar2 default hr_api.g_varchar2,
656: p_trans_information20 in varchar2 default hr_api.g_varchar2,
657: p_trans_information3 in varchar2 default hr_api.g_varchar2,
650: p_trans_information15 in varchar2 default hr_api.g_varchar2,
651: p_trans_information16 in varchar2 default hr_api.g_varchar2,
652: p_trans_information17 in varchar2 default hr_api.g_varchar2,
653: p_trans_information18 in varchar2 default hr_api.g_varchar2,
654: p_trans_information19 in varchar2 default hr_api.g_varchar2,
655: p_trans_information2 in varchar2 default hr_api.g_varchar2,
656: p_trans_information20 in varchar2 default hr_api.g_varchar2,
657: p_trans_information3 in varchar2 default hr_api.g_varchar2,
658: p_trans_information4 in varchar2 default hr_api.g_varchar2,
651: p_trans_information16 in varchar2 default hr_api.g_varchar2,
652: p_trans_information17 in varchar2 default hr_api.g_varchar2,
653: p_trans_information18 in varchar2 default hr_api.g_varchar2,
654: p_trans_information19 in varchar2 default hr_api.g_varchar2,
655: p_trans_information2 in varchar2 default hr_api.g_varchar2,
656: p_trans_information20 in varchar2 default hr_api.g_varchar2,
657: p_trans_information3 in varchar2 default hr_api.g_varchar2,
658: p_trans_information4 in varchar2 default hr_api.g_varchar2,
659: p_trans_information5 in varchar2 default hr_api.g_varchar2,
652: p_trans_information17 in varchar2 default hr_api.g_varchar2,
653: p_trans_information18 in varchar2 default hr_api.g_varchar2,
654: p_trans_information19 in varchar2 default hr_api.g_varchar2,
655: p_trans_information2 in varchar2 default hr_api.g_varchar2,
656: p_trans_information20 in varchar2 default hr_api.g_varchar2,
657: p_trans_information3 in varchar2 default hr_api.g_varchar2,
658: p_trans_information4 in varchar2 default hr_api.g_varchar2,
659: p_trans_information5 in varchar2 default hr_api.g_varchar2,
660: p_trans_information6 in varchar2 default hr_api.g_varchar2,
653: p_trans_information18 in varchar2 default hr_api.g_varchar2,
654: p_trans_information19 in varchar2 default hr_api.g_varchar2,
655: p_trans_information2 in varchar2 default hr_api.g_varchar2,
656: p_trans_information20 in varchar2 default hr_api.g_varchar2,
657: p_trans_information3 in varchar2 default hr_api.g_varchar2,
658: p_trans_information4 in varchar2 default hr_api.g_varchar2,
659: p_trans_information5 in varchar2 default hr_api.g_varchar2,
660: p_trans_information6 in varchar2 default hr_api.g_varchar2,
661: p_trans_information7 in varchar2 default hr_api.g_varchar2,
654: p_trans_information19 in varchar2 default hr_api.g_varchar2,
655: p_trans_information2 in varchar2 default hr_api.g_varchar2,
656: p_trans_information20 in varchar2 default hr_api.g_varchar2,
657: p_trans_information3 in varchar2 default hr_api.g_varchar2,
658: p_trans_information4 in varchar2 default hr_api.g_varchar2,
659: p_trans_information5 in varchar2 default hr_api.g_varchar2,
660: p_trans_information6 in varchar2 default hr_api.g_varchar2,
661: p_trans_information7 in varchar2 default hr_api.g_varchar2,
662: p_trans_information8 in varchar2 default hr_api.g_varchar2,
655: p_trans_information2 in varchar2 default hr_api.g_varchar2,
656: p_trans_information20 in varchar2 default hr_api.g_varchar2,
657: p_trans_information3 in varchar2 default hr_api.g_varchar2,
658: p_trans_information4 in varchar2 default hr_api.g_varchar2,
659: p_trans_information5 in varchar2 default hr_api.g_varchar2,
660: p_trans_information6 in varchar2 default hr_api.g_varchar2,
661: p_trans_information7 in varchar2 default hr_api.g_varchar2,
662: p_trans_information8 in varchar2 default hr_api.g_varchar2,
663: p_trans_information9 in varchar2 default hr_api.g_varchar2,
656: p_trans_information20 in varchar2 default hr_api.g_varchar2,
657: p_trans_information3 in varchar2 default hr_api.g_varchar2,
658: p_trans_information4 in varchar2 default hr_api.g_varchar2,
659: p_trans_information5 in varchar2 default hr_api.g_varchar2,
660: p_trans_information6 in varchar2 default hr_api.g_varchar2,
661: p_trans_information7 in varchar2 default hr_api.g_varchar2,
662: p_trans_information8 in varchar2 default hr_api.g_varchar2,
663: p_trans_information9 in varchar2 default hr_api.g_varchar2,
664: p_transfer_date in date default hr_api.g_date,
657: p_trans_information3 in varchar2 default hr_api.g_varchar2,
658: p_trans_information4 in varchar2 default hr_api.g_varchar2,
659: p_trans_information5 in varchar2 default hr_api.g_varchar2,
660: p_trans_information6 in varchar2 default hr_api.g_varchar2,
661: p_trans_information7 in varchar2 default hr_api.g_varchar2,
662: p_trans_information8 in varchar2 default hr_api.g_varchar2,
663: p_trans_information9 in varchar2 default hr_api.g_varchar2,
664: p_transfer_date in date default hr_api.g_date,
665: p_transfer_message in varchar2 default hr_api.g_varchar2,
658: p_trans_information4 in varchar2 default hr_api.g_varchar2,
659: p_trans_information5 in varchar2 default hr_api.g_varchar2,
660: p_trans_information6 in varchar2 default hr_api.g_varchar2,
661: p_trans_information7 in varchar2 default hr_api.g_varchar2,
662: p_trans_information8 in varchar2 default hr_api.g_varchar2,
663: p_trans_information9 in varchar2 default hr_api.g_varchar2,
664: p_transfer_date in date default hr_api.g_date,
665: p_transfer_message in varchar2 default hr_api.g_varchar2,
666: p_unitary_amount in number default hr_api.g_number,
659: p_trans_information5 in varchar2 default hr_api.g_varchar2,
660: p_trans_information6 in varchar2 default hr_api.g_varchar2,
661: p_trans_information7 in varchar2 default hr_api.g_varchar2,
662: p_trans_information8 in varchar2 default hr_api.g_varchar2,
663: p_trans_information9 in varchar2 default hr_api.g_varchar2,
664: p_transfer_date in date default hr_api.g_date,
665: p_transfer_message in varchar2 default hr_api.g_varchar2,
666: p_unitary_amount in number default hr_api.g_number,
667: p_booking_deal_id in number default hr_api.g_number,
660: p_trans_information6 in varchar2 default hr_api.g_varchar2,
661: p_trans_information7 in varchar2 default hr_api.g_varchar2,
662: p_trans_information8 in varchar2 default hr_api.g_varchar2,
663: p_trans_information9 in varchar2 default hr_api.g_varchar2,
664: p_transfer_date in date default hr_api.g_date,
665: p_transfer_message in varchar2 default hr_api.g_varchar2,
666: p_unitary_amount in number default hr_api.g_number,
667: p_booking_deal_id in number default hr_api.g_number,
668: p_booking_id in number default hr_api.g_number,
661: p_trans_information7 in varchar2 default hr_api.g_varchar2,
662: p_trans_information8 in varchar2 default hr_api.g_varchar2,
663: p_trans_information9 in varchar2 default hr_api.g_varchar2,
664: p_transfer_date in date default hr_api.g_date,
665: p_transfer_message in varchar2 default hr_api.g_varchar2,
666: p_unitary_amount in number default hr_api.g_number,
667: p_booking_deal_id in number default hr_api.g_number,
668: p_booking_id in number default hr_api.g_number,
669: p_resource_allocation_id in number default hr_api.g_number,
662: p_trans_information8 in varchar2 default hr_api.g_varchar2,
663: p_trans_information9 in varchar2 default hr_api.g_varchar2,
664: p_transfer_date in date default hr_api.g_date,
665: p_transfer_message in varchar2 default hr_api.g_varchar2,
666: p_unitary_amount in number default hr_api.g_number,
667: p_booking_deal_id in number default hr_api.g_number,
668: p_booking_id in number default hr_api.g_number,
669: p_resource_allocation_id in number default hr_api.g_number,
670: p_resource_booking_id in number default hr_api.g_number,
663: p_trans_information9 in varchar2 default hr_api.g_varchar2,
664: p_transfer_date in date default hr_api.g_date,
665: p_transfer_message in varchar2 default hr_api.g_varchar2,
666: p_unitary_amount in number default hr_api.g_number,
667: p_booking_deal_id in number default hr_api.g_number,
668: p_booking_id in number default hr_api.g_number,
669: p_resource_allocation_id in number default hr_api.g_number,
670: p_resource_booking_id in number default hr_api.g_number,
671: p_tfl_information_category in varchar2 default hr_api.g_varchar2,
664: p_transfer_date in date default hr_api.g_date,
665: p_transfer_message in varchar2 default hr_api.g_varchar2,
666: p_unitary_amount in number default hr_api.g_number,
667: p_booking_deal_id in number default hr_api.g_number,
668: p_booking_id in number default hr_api.g_number,
669: p_resource_allocation_id in number default hr_api.g_number,
670: p_resource_booking_id in number default hr_api.g_number,
671: p_tfl_information_category in varchar2 default hr_api.g_varchar2,
672: p_tfl_information1 in varchar2 default hr_api.g_varchar2,
665: p_transfer_message in varchar2 default hr_api.g_varchar2,
666: p_unitary_amount in number default hr_api.g_number,
667: p_booking_deal_id in number default hr_api.g_number,
668: p_booking_id in number default hr_api.g_number,
669: p_resource_allocation_id in number default hr_api.g_number,
670: p_resource_booking_id in number default hr_api.g_number,
671: p_tfl_information_category in varchar2 default hr_api.g_varchar2,
672: p_tfl_information1 in varchar2 default hr_api.g_varchar2,
673: p_tfl_information2 in varchar2 default hr_api.g_varchar2,
666: p_unitary_amount in number default hr_api.g_number,
667: p_booking_deal_id in number default hr_api.g_number,
668: p_booking_id in number default hr_api.g_number,
669: p_resource_allocation_id in number default hr_api.g_number,
670: p_resource_booking_id in number default hr_api.g_number,
671: p_tfl_information_category in varchar2 default hr_api.g_varchar2,
672: p_tfl_information1 in varchar2 default hr_api.g_varchar2,
673: p_tfl_information2 in varchar2 default hr_api.g_varchar2,
674: p_tfl_information3 in varchar2 default hr_api.g_varchar2,
667: p_booking_deal_id in number default hr_api.g_number,
668: p_booking_id in number default hr_api.g_number,
669: p_resource_allocation_id in number default hr_api.g_number,
670: p_resource_booking_id in number default hr_api.g_number,
671: p_tfl_information_category in varchar2 default hr_api.g_varchar2,
672: p_tfl_information1 in varchar2 default hr_api.g_varchar2,
673: p_tfl_information2 in varchar2 default hr_api.g_varchar2,
674: p_tfl_information3 in varchar2 default hr_api.g_varchar2,
675: p_tfl_information4 in varchar2 default hr_api.g_varchar2,
668: p_booking_id in number default hr_api.g_number,
669: p_resource_allocation_id in number default hr_api.g_number,
670: p_resource_booking_id in number default hr_api.g_number,
671: p_tfl_information_category in varchar2 default hr_api.g_varchar2,
672: p_tfl_information1 in varchar2 default hr_api.g_varchar2,
673: p_tfl_information2 in varchar2 default hr_api.g_varchar2,
674: p_tfl_information3 in varchar2 default hr_api.g_varchar2,
675: p_tfl_information4 in varchar2 default hr_api.g_varchar2,
676: p_tfl_information5 in varchar2 default hr_api.g_varchar2,
669: p_resource_allocation_id in number default hr_api.g_number,
670: p_resource_booking_id in number default hr_api.g_number,
671: p_tfl_information_category in varchar2 default hr_api.g_varchar2,
672: p_tfl_information1 in varchar2 default hr_api.g_varchar2,
673: p_tfl_information2 in varchar2 default hr_api.g_varchar2,
674: p_tfl_information3 in varchar2 default hr_api.g_varchar2,
675: p_tfl_information4 in varchar2 default hr_api.g_varchar2,
676: p_tfl_information5 in varchar2 default hr_api.g_varchar2,
677: p_tfl_information6 in varchar2 default hr_api.g_varchar2,
670: p_resource_booking_id in number default hr_api.g_number,
671: p_tfl_information_category in varchar2 default hr_api.g_varchar2,
672: p_tfl_information1 in varchar2 default hr_api.g_varchar2,
673: p_tfl_information2 in varchar2 default hr_api.g_varchar2,
674: p_tfl_information3 in varchar2 default hr_api.g_varchar2,
675: p_tfl_information4 in varchar2 default hr_api.g_varchar2,
676: p_tfl_information5 in varchar2 default hr_api.g_varchar2,
677: p_tfl_information6 in varchar2 default hr_api.g_varchar2,
678: p_tfl_information7 in varchar2 default hr_api.g_varchar2,
671: p_tfl_information_category in varchar2 default hr_api.g_varchar2,
672: p_tfl_information1 in varchar2 default hr_api.g_varchar2,
673: p_tfl_information2 in varchar2 default hr_api.g_varchar2,
674: p_tfl_information3 in varchar2 default hr_api.g_varchar2,
675: p_tfl_information4 in varchar2 default hr_api.g_varchar2,
676: p_tfl_information5 in varchar2 default hr_api.g_varchar2,
677: p_tfl_information6 in varchar2 default hr_api.g_varchar2,
678: p_tfl_information7 in varchar2 default hr_api.g_varchar2,
679: p_tfl_information8 in varchar2 default hr_api.g_varchar2,
672: p_tfl_information1 in varchar2 default hr_api.g_varchar2,
673: p_tfl_information2 in varchar2 default hr_api.g_varchar2,
674: p_tfl_information3 in varchar2 default hr_api.g_varchar2,
675: p_tfl_information4 in varchar2 default hr_api.g_varchar2,
676: p_tfl_information5 in varchar2 default hr_api.g_varchar2,
677: p_tfl_information6 in varchar2 default hr_api.g_varchar2,
678: p_tfl_information7 in varchar2 default hr_api.g_varchar2,
679: p_tfl_information8 in varchar2 default hr_api.g_varchar2,
680: p_tfl_information9 in varchar2 default hr_api.g_varchar2,
673: p_tfl_information2 in varchar2 default hr_api.g_varchar2,
674: p_tfl_information3 in varchar2 default hr_api.g_varchar2,
675: p_tfl_information4 in varchar2 default hr_api.g_varchar2,
676: p_tfl_information5 in varchar2 default hr_api.g_varchar2,
677: p_tfl_information6 in varchar2 default hr_api.g_varchar2,
678: p_tfl_information7 in varchar2 default hr_api.g_varchar2,
679: p_tfl_information8 in varchar2 default hr_api.g_varchar2,
680: p_tfl_information9 in varchar2 default hr_api.g_varchar2,
681: p_tfl_information10 in varchar2 default hr_api.g_varchar2,
674: p_tfl_information3 in varchar2 default hr_api.g_varchar2,
675: p_tfl_information4 in varchar2 default hr_api.g_varchar2,
676: p_tfl_information5 in varchar2 default hr_api.g_varchar2,
677: p_tfl_information6 in varchar2 default hr_api.g_varchar2,
678: p_tfl_information7 in varchar2 default hr_api.g_varchar2,
679: p_tfl_information8 in varchar2 default hr_api.g_varchar2,
680: p_tfl_information9 in varchar2 default hr_api.g_varchar2,
681: p_tfl_information10 in varchar2 default hr_api.g_varchar2,
682: p_tfl_information11 in varchar2 default hr_api.g_varchar2,
675: p_tfl_information4 in varchar2 default hr_api.g_varchar2,
676: p_tfl_information5 in varchar2 default hr_api.g_varchar2,
677: p_tfl_information6 in varchar2 default hr_api.g_varchar2,
678: p_tfl_information7 in varchar2 default hr_api.g_varchar2,
679: p_tfl_information8 in varchar2 default hr_api.g_varchar2,
680: p_tfl_information9 in varchar2 default hr_api.g_varchar2,
681: p_tfl_information10 in varchar2 default hr_api.g_varchar2,
682: p_tfl_information11 in varchar2 default hr_api.g_varchar2,
683: p_tfl_information12 in varchar2 default hr_api.g_varchar2,
676: p_tfl_information5 in varchar2 default hr_api.g_varchar2,
677: p_tfl_information6 in varchar2 default hr_api.g_varchar2,
678: p_tfl_information7 in varchar2 default hr_api.g_varchar2,
679: p_tfl_information8 in varchar2 default hr_api.g_varchar2,
680: p_tfl_information9 in varchar2 default hr_api.g_varchar2,
681: p_tfl_information10 in varchar2 default hr_api.g_varchar2,
682: p_tfl_information11 in varchar2 default hr_api.g_varchar2,
683: p_tfl_information12 in varchar2 default hr_api.g_varchar2,
684: p_tfl_information13 in varchar2 default hr_api.g_varchar2,
677: p_tfl_information6 in varchar2 default hr_api.g_varchar2,
678: p_tfl_information7 in varchar2 default hr_api.g_varchar2,
679: p_tfl_information8 in varchar2 default hr_api.g_varchar2,
680: p_tfl_information9 in varchar2 default hr_api.g_varchar2,
681: p_tfl_information10 in varchar2 default hr_api.g_varchar2,
682: p_tfl_information11 in varchar2 default hr_api.g_varchar2,
683: p_tfl_information12 in varchar2 default hr_api.g_varchar2,
684: p_tfl_information13 in varchar2 default hr_api.g_varchar2,
685: p_tfl_information14 in varchar2 default hr_api.g_varchar2,
678: p_tfl_information7 in varchar2 default hr_api.g_varchar2,
679: p_tfl_information8 in varchar2 default hr_api.g_varchar2,
680: p_tfl_information9 in varchar2 default hr_api.g_varchar2,
681: p_tfl_information10 in varchar2 default hr_api.g_varchar2,
682: p_tfl_information11 in varchar2 default hr_api.g_varchar2,
683: p_tfl_information12 in varchar2 default hr_api.g_varchar2,
684: p_tfl_information13 in varchar2 default hr_api.g_varchar2,
685: p_tfl_information14 in varchar2 default hr_api.g_varchar2,
686: p_tfl_information15 in varchar2 default hr_api.g_varchar2,
679: p_tfl_information8 in varchar2 default hr_api.g_varchar2,
680: p_tfl_information9 in varchar2 default hr_api.g_varchar2,
681: p_tfl_information10 in varchar2 default hr_api.g_varchar2,
682: p_tfl_information11 in varchar2 default hr_api.g_varchar2,
683: p_tfl_information12 in varchar2 default hr_api.g_varchar2,
684: p_tfl_information13 in varchar2 default hr_api.g_varchar2,
685: p_tfl_information14 in varchar2 default hr_api.g_varchar2,
686: p_tfl_information15 in varchar2 default hr_api.g_varchar2,
687: p_tfl_information16 in varchar2 default hr_api.g_varchar2,
680: p_tfl_information9 in varchar2 default hr_api.g_varchar2,
681: p_tfl_information10 in varchar2 default hr_api.g_varchar2,
682: p_tfl_information11 in varchar2 default hr_api.g_varchar2,
683: p_tfl_information12 in varchar2 default hr_api.g_varchar2,
684: p_tfl_information13 in varchar2 default hr_api.g_varchar2,
685: p_tfl_information14 in varchar2 default hr_api.g_varchar2,
686: p_tfl_information15 in varchar2 default hr_api.g_varchar2,
687: p_tfl_information16 in varchar2 default hr_api.g_varchar2,
688: p_tfl_information17 in varchar2 default hr_api.g_varchar2,
681: p_tfl_information10 in varchar2 default hr_api.g_varchar2,
682: p_tfl_information11 in varchar2 default hr_api.g_varchar2,
683: p_tfl_information12 in varchar2 default hr_api.g_varchar2,
684: p_tfl_information13 in varchar2 default hr_api.g_varchar2,
685: p_tfl_information14 in varchar2 default hr_api.g_varchar2,
686: p_tfl_information15 in varchar2 default hr_api.g_varchar2,
687: p_tfl_information16 in varchar2 default hr_api.g_varchar2,
688: p_tfl_information17 in varchar2 default hr_api.g_varchar2,
689: p_tfl_information18 in varchar2 default hr_api.g_varchar2,
682: p_tfl_information11 in varchar2 default hr_api.g_varchar2,
683: p_tfl_information12 in varchar2 default hr_api.g_varchar2,
684: p_tfl_information13 in varchar2 default hr_api.g_varchar2,
685: p_tfl_information14 in varchar2 default hr_api.g_varchar2,
686: p_tfl_information15 in varchar2 default hr_api.g_varchar2,
687: p_tfl_information16 in varchar2 default hr_api.g_varchar2,
688: p_tfl_information17 in varchar2 default hr_api.g_varchar2,
689: p_tfl_information18 in varchar2 default hr_api.g_varchar2,
690: p_tfl_information19 in varchar2 default hr_api.g_varchar2,
683: p_tfl_information12 in varchar2 default hr_api.g_varchar2,
684: p_tfl_information13 in varchar2 default hr_api.g_varchar2,
685: p_tfl_information14 in varchar2 default hr_api.g_varchar2,
686: p_tfl_information15 in varchar2 default hr_api.g_varchar2,
687: p_tfl_information16 in varchar2 default hr_api.g_varchar2,
688: p_tfl_information17 in varchar2 default hr_api.g_varchar2,
689: p_tfl_information18 in varchar2 default hr_api.g_varchar2,
690: p_tfl_information19 in varchar2 default hr_api.g_varchar2,
691: p_tfl_information20 in varchar2 default hr_api.g_varchar2,
684: p_tfl_information13 in varchar2 default hr_api.g_varchar2,
685: p_tfl_information14 in varchar2 default hr_api.g_varchar2,
686: p_tfl_information15 in varchar2 default hr_api.g_varchar2,
687: p_tfl_information16 in varchar2 default hr_api.g_varchar2,
688: p_tfl_information17 in varchar2 default hr_api.g_varchar2,
689: p_tfl_information18 in varchar2 default hr_api.g_varchar2,
690: p_tfl_information19 in varchar2 default hr_api.g_varchar2,
691: p_tfl_information20 in varchar2 default hr_api.g_varchar2,
692: p_validate in boolean default false,
685: p_tfl_information14 in varchar2 default hr_api.g_varchar2,
686: p_tfl_information15 in varchar2 default hr_api.g_varchar2,
687: p_tfl_information16 in varchar2 default hr_api.g_varchar2,
688: p_tfl_information17 in varchar2 default hr_api.g_varchar2,
689: p_tfl_information18 in varchar2 default hr_api.g_varchar2,
690: p_tfl_information19 in varchar2 default hr_api.g_varchar2,
691: p_tfl_information20 in varchar2 default hr_api.g_varchar2,
692: p_validate in boolean default false,
693: p_transaction_type in varchar2
686: p_tfl_information15 in varchar2 default hr_api.g_varchar2,
687: p_tfl_information16 in varchar2 default hr_api.g_varchar2,
688: p_tfl_information17 in varchar2 default hr_api.g_varchar2,
689: p_tfl_information18 in varchar2 default hr_api.g_varchar2,
690: p_tfl_information19 in varchar2 default hr_api.g_varchar2,
691: p_tfl_information20 in varchar2 default hr_api.g_varchar2,
692: p_validate in boolean default false,
693: p_transaction_type in varchar2
694: ) is
687: p_tfl_information16 in varchar2 default hr_api.g_varchar2,
688: p_tfl_information17 in varchar2 default hr_api.g_varchar2,
689: p_tfl_information18 in varchar2 default hr_api.g_varchar2,
690: p_tfl_information19 in varchar2 default hr_api.g_varchar2,
691: p_tfl_information20 in varchar2 default hr_api.g_varchar2,
692: p_validate in boolean default false,
693: p_transaction_type in varchar2
694: ) is
695: --