APPS.PAY_BLT_UPD dependencies on HR_API

Line 116: When hr_api.check_integrity_violated Then

112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: --
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
119: pay_blt_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.check_integrity_violated Then
117: -- A check constraint has been violated
118: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
119: pay_blt_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
124: pay_blt_shd.constraint_error

Line 121: When hr_api.parent_integrity_violated Then

117: -- A check constraint has been violated
118: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
119: pay_blt_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
124: pay_blt_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.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
124: pay_blt_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
129: pay_blt_shd.constraint_error

Line 126: When hr_api.unique_integrity_violated Then

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

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

126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
129: pay_blt_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;
134: End update_dml;

Line 305: when hr_api.cannot_find_prog_unit then

301: );
302: --
303: exception
304: --
305: when hr_api.cannot_find_prog_unit then
306: --
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'PAY_BALANCE_TYPES'
309: ,p_hook_type => 'AU');

Line 307: hr_api.cannot_find_prog_unit_error

303: exception
304: --
305: when hr_api.cannot_find_prog_unit then
306: --
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'PAY_BALANCE_TYPES'
309: ,p_hook_type => 'AU');
310: --
311: end;

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

366: -- p_rec plsql record structure
367: -- to see if a system default is being used. If a system default
368: -- is being used then we must set to the 'current' argument value.
369: --
370: If (p_rec.business_group_id = hr_api.g_number) then
371: p_rec.business_group_id :=
372: pay_blt_shd.g_old_rec.business_group_id;
373: End If;
374: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 374: If (p_rec.legislation_code = hr_api.g_varchar2) then

370: If (p_rec.business_group_id = hr_api.g_number) then
371: p_rec.business_group_id :=
372: pay_blt_shd.g_old_rec.business_group_id;
373: End If;
374: If (p_rec.legislation_code = hr_api.g_varchar2) then
375: p_rec.legislation_code :=
376: pay_blt_shd.g_old_rec.legislation_code;
377: End If;
378: If (p_rec.currency_code = hr_api.g_varchar2) then

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

374: If (p_rec.legislation_code = hr_api.g_varchar2) then
375: p_rec.legislation_code :=
376: pay_blt_shd.g_old_rec.legislation_code;
377: End If;
378: If (p_rec.currency_code = hr_api.g_varchar2) then
379: p_rec.currency_code :=
380: pay_blt_shd.g_old_rec.currency_code;
381: End If;
382: If (p_rec.assignment_remuneration_flag = hr_api.g_varchar2) then

Line 382: If (p_rec.assignment_remuneration_flag = hr_api.g_varchar2) then

378: If (p_rec.currency_code = hr_api.g_varchar2) then
379: p_rec.currency_code :=
380: pay_blt_shd.g_old_rec.currency_code;
381: End If;
382: If (p_rec.assignment_remuneration_flag = hr_api.g_varchar2) then
383: p_rec.assignment_remuneration_flag :=
384: pay_blt_shd.g_old_rec.assignment_remuneration_flag;
385: End If;
386: If (p_rec.balance_name = hr_api.g_varchar2) then

Line 386: If (p_rec.balance_name = hr_api.g_varchar2) then

382: If (p_rec.assignment_remuneration_flag = hr_api.g_varchar2) then
383: p_rec.assignment_remuneration_flag :=
384: pay_blt_shd.g_old_rec.assignment_remuneration_flag;
385: End If;
386: If (p_rec.balance_name = hr_api.g_varchar2) then
387: p_rec.balance_name :=
388: pay_blt_shd.g_old_rec.balance_name;
389: End If;
390: If (p_rec.balance_uom = hr_api.g_varchar2) then

Line 390: If (p_rec.balance_uom = hr_api.g_varchar2) then

386: If (p_rec.balance_name = hr_api.g_varchar2) then
387: p_rec.balance_name :=
388: pay_blt_shd.g_old_rec.balance_name;
389: End If;
390: If (p_rec.balance_uom = hr_api.g_varchar2) then
391: p_rec.balance_uom :=
392: pay_blt_shd.g_old_rec.balance_uom;
393: End If;
394: If (p_rec.comments = hr_api.g_varchar2) then

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

390: If (p_rec.balance_uom = hr_api.g_varchar2) then
391: p_rec.balance_uom :=
392: pay_blt_shd.g_old_rec.balance_uom;
393: End If;
394: If (p_rec.comments = hr_api.g_varchar2) then
395: p_rec.comments :=
396: pay_blt_shd.g_old_rec.comments;
397: End If;
398: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then

Line 398: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then

394: If (p_rec.comments = hr_api.g_varchar2) then
395: p_rec.comments :=
396: pay_blt_shd.g_old_rec.comments;
397: End If;
398: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
399: p_rec.legislation_subgroup :=
400: pay_blt_shd.g_old_rec.legislation_subgroup;
401: End If;
402: If (p_rec.reporting_name = hr_api.g_varchar2) then

Line 402: If (p_rec.reporting_name = hr_api.g_varchar2) then

398: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
399: p_rec.legislation_subgroup :=
400: pay_blt_shd.g_old_rec.legislation_subgroup;
401: End If;
402: If (p_rec.reporting_name = hr_api.g_varchar2) then
403: p_rec.reporting_name :=
404: pay_blt_shd.g_old_rec.reporting_name;
405: End If;
406: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 406: If (p_rec.attribute_category = hr_api.g_varchar2) then

402: If (p_rec.reporting_name = hr_api.g_varchar2) then
403: p_rec.reporting_name :=
404: pay_blt_shd.g_old_rec.reporting_name;
405: End If;
406: If (p_rec.attribute_category = hr_api.g_varchar2) then
407: p_rec.attribute_category :=
408: pay_blt_shd.g_old_rec.attribute_category;
409: End If;
410: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 410: If (p_rec.attribute1 = hr_api.g_varchar2) then

406: If (p_rec.attribute_category = hr_api.g_varchar2) then
407: p_rec.attribute_category :=
408: pay_blt_shd.g_old_rec.attribute_category;
409: End If;
410: If (p_rec.attribute1 = hr_api.g_varchar2) then
411: p_rec.attribute1 :=
412: pay_blt_shd.g_old_rec.attribute1;
413: End If;
414: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 414: If (p_rec.attribute2 = hr_api.g_varchar2) then

410: If (p_rec.attribute1 = hr_api.g_varchar2) then
411: p_rec.attribute1 :=
412: pay_blt_shd.g_old_rec.attribute1;
413: End If;
414: If (p_rec.attribute2 = hr_api.g_varchar2) then
415: p_rec.attribute2 :=
416: pay_blt_shd.g_old_rec.attribute2;
417: End If;
418: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 418: If (p_rec.attribute3 = hr_api.g_varchar2) then

414: If (p_rec.attribute2 = hr_api.g_varchar2) then
415: p_rec.attribute2 :=
416: pay_blt_shd.g_old_rec.attribute2;
417: End If;
418: If (p_rec.attribute3 = hr_api.g_varchar2) then
419: p_rec.attribute3 :=
420: pay_blt_shd.g_old_rec.attribute3;
421: End If;
422: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 422: If (p_rec.attribute4 = hr_api.g_varchar2) then

418: If (p_rec.attribute3 = hr_api.g_varchar2) then
419: p_rec.attribute3 :=
420: pay_blt_shd.g_old_rec.attribute3;
421: End If;
422: If (p_rec.attribute4 = hr_api.g_varchar2) then
423: p_rec.attribute4 :=
424: pay_blt_shd.g_old_rec.attribute4;
425: End If;
426: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 426: If (p_rec.attribute5 = hr_api.g_varchar2) then

422: If (p_rec.attribute4 = hr_api.g_varchar2) then
423: p_rec.attribute4 :=
424: pay_blt_shd.g_old_rec.attribute4;
425: End If;
426: If (p_rec.attribute5 = hr_api.g_varchar2) then
427: p_rec.attribute5 :=
428: pay_blt_shd.g_old_rec.attribute5;
429: End If;
430: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 430: If (p_rec.attribute6 = hr_api.g_varchar2) then

426: If (p_rec.attribute5 = hr_api.g_varchar2) then
427: p_rec.attribute5 :=
428: pay_blt_shd.g_old_rec.attribute5;
429: End If;
430: If (p_rec.attribute6 = hr_api.g_varchar2) then
431: p_rec.attribute6 :=
432: pay_blt_shd.g_old_rec.attribute6;
433: End If;
434: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 434: If (p_rec.attribute7 = hr_api.g_varchar2) then

430: If (p_rec.attribute6 = hr_api.g_varchar2) then
431: p_rec.attribute6 :=
432: pay_blt_shd.g_old_rec.attribute6;
433: End If;
434: If (p_rec.attribute7 = hr_api.g_varchar2) then
435: p_rec.attribute7 :=
436: pay_blt_shd.g_old_rec.attribute7;
437: End If;
438: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 438: If (p_rec.attribute8 = hr_api.g_varchar2) then

434: If (p_rec.attribute7 = hr_api.g_varchar2) then
435: p_rec.attribute7 :=
436: pay_blt_shd.g_old_rec.attribute7;
437: End If;
438: If (p_rec.attribute8 = hr_api.g_varchar2) then
439: p_rec.attribute8 :=
440: pay_blt_shd.g_old_rec.attribute8;
441: End If;
442: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 442: If (p_rec.attribute9 = hr_api.g_varchar2) then

438: If (p_rec.attribute8 = hr_api.g_varchar2) then
439: p_rec.attribute8 :=
440: pay_blt_shd.g_old_rec.attribute8;
441: End If;
442: If (p_rec.attribute9 = hr_api.g_varchar2) then
443: p_rec.attribute9 :=
444: pay_blt_shd.g_old_rec.attribute9;
445: End If;
446: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 446: If (p_rec.attribute10 = hr_api.g_varchar2) then

442: If (p_rec.attribute9 = hr_api.g_varchar2) then
443: p_rec.attribute9 :=
444: pay_blt_shd.g_old_rec.attribute9;
445: End If;
446: If (p_rec.attribute10 = hr_api.g_varchar2) then
447: p_rec.attribute10 :=
448: pay_blt_shd.g_old_rec.attribute10;
449: End If;
450: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 450: If (p_rec.attribute11 = hr_api.g_varchar2) then

446: If (p_rec.attribute10 = hr_api.g_varchar2) then
447: p_rec.attribute10 :=
448: pay_blt_shd.g_old_rec.attribute10;
449: End If;
450: If (p_rec.attribute11 = hr_api.g_varchar2) then
451: p_rec.attribute11 :=
452: pay_blt_shd.g_old_rec.attribute11;
453: End If;
454: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 454: If (p_rec.attribute12 = hr_api.g_varchar2) then

450: If (p_rec.attribute11 = hr_api.g_varchar2) then
451: p_rec.attribute11 :=
452: pay_blt_shd.g_old_rec.attribute11;
453: End If;
454: If (p_rec.attribute12 = hr_api.g_varchar2) then
455: p_rec.attribute12 :=
456: pay_blt_shd.g_old_rec.attribute12;
457: End If;
458: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 458: If (p_rec.attribute13 = hr_api.g_varchar2) then

454: If (p_rec.attribute12 = hr_api.g_varchar2) then
455: p_rec.attribute12 :=
456: pay_blt_shd.g_old_rec.attribute12;
457: End If;
458: If (p_rec.attribute13 = hr_api.g_varchar2) then
459: p_rec.attribute13 :=
460: pay_blt_shd.g_old_rec.attribute13;
461: End If;
462: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 462: If (p_rec.attribute14 = hr_api.g_varchar2) then

458: If (p_rec.attribute13 = hr_api.g_varchar2) then
459: p_rec.attribute13 :=
460: pay_blt_shd.g_old_rec.attribute13;
461: End If;
462: If (p_rec.attribute14 = hr_api.g_varchar2) then
463: p_rec.attribute14 :=
464: pay_blt_shd.g_old_rec.attribute14;
465: End If;
466: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 466: If (p_rec.attribute15 = hr_api.g_varchar2) then

462: If (p_rec.attribute14 = hr_api.g_varchar2) then
463: p_rec.attribute14 :=
464: pay_blt_shd.g_old_rec.attribute14;
465: End If;
466: If (p_rec.attribute15 = hr_api.g_varchar2) then
467: p_rec.attribute15 :=
468: pay_blt_shd.g_old_rec.attribute15;
469: End If;
470: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 470: If (p_rec.attribute16 = hr_api.g_varchar2) then

466: If (p_rec.attribute15 = hr_api.g_varchar2) then
467: p_rec.attribute15 :=
468: pay_blt_shd.g_old_rec.attribute15;
469: End If;
470: If (p_rec.attribute16 = hr_api.g_varchar2) then
471: p_rec.attribute16 :=
472: pay_blt_shd.g_old_rec.attribute16;
473: End If;
474: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 474: If (p_rec.attribute17 = hr_api.g_varchar2) then

470: If (p_rec.attribute16 = hr_api.g_varchar2) then
471: p_rec.attribute16 :=
472: pay_blt_shd.g_old_rec.attribute16;
473: End If;
474: If (p_rec.attribute17 = hr_api.g_varchar2) then
475: p_rec.attribute17 :=
476: pay_blt_shd.g_old_rec.attribute17;
477: End If;
478: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 478: If (p_rec.attribute18 = hr_api.g_varchar2) then

474: If (p_rec.attribute17 = hr_api.g_varchar2) then
475: p_rec.attribute17 :=
476: pay_blt_shd.g_old_rec.attribute17;
477: End If;
478: If (p_rec.attribute18 = hr_api.g_varchar2) then
479: p_rec.attribute18 :=
480: pay_blt_shd.g_old_rec.attribute18;
481: End If;
482: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 482: If (p_rec.attribute19 = hr_api.g_varchar2) then

478: If (p_rec.attribute18 = hr_api.g_varchar2) then
479: p_rec.attribute18 :=
480: pay_blt_shd.g_old_rec.attribute18;
481: End If;
482: If (p_rec.attribute19 = hr_api.g_varchar2) then
483: p_rec.attribute19 :=
484: pay_blt_shd.g_old_rec.attribute19;
485: End If;
486: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 486: If (p_rec.attribute20 = hr_api.g_varchar2) then

482: If (p_rec.attribute19 = hr_api.g_varchar2) then
483: p_rec.attribute19 :=
484: pay_blt_shd.g_old_rec.attribute19;
485: End If;
486: If (p_rec.attribute20 = hr_api.g_varchar2) then
487: p_rec.attribute20 :=
488: pay_blt_shd.g_old_rec.attribute20;
489: End If;
490: If (p_rec.jurisdiction_level = hr_api.g_number) then

Line 490: If (p_rec.jurisdiction_level = hr_api.g_number) then

486: If (p_rec.attribute20 = hr_api.g_varchar2) then
487: p_rec.attribute20 :=
488: pay_blt_shd.g_old_rec.attribute20;
489: End If;
490: If (p_rec.jurisdiction_level = hr_api.g_number) then
491: p_rec.jurisdiction_level :=
492: pay_blt_shd.g_old_rec.jurisdiction_level;
493: End If;
494: If (p_rec.tax_type = hr_api.g_varchar2) then

Line 494: If (p_rec.tax_type = hr_api.g_varchar2) then

490: If (p_rec.jurisdiction_level = hr_api.g_number) then
491: p_rec.jurisdiction_level :=
492: pay_blt_shd.g_old_rec.jurisdiction_level;
493: End If;
494: If (p_rec.tax_type = hr_api.g_varchar2) then
495: p_rec.tax_type :=
496: pay_blt_shd.g_old_rec.tax_type;
497: End If;
498: If (p_rec.balance_category_id = hr_api.g_number) then

Line 498: If (p_rec.balance_category_id = hr_api.g_number) then

494: If (p_rec.tax_type = hr_api.g_varchar2) then
495: p_rec.tax_type :=
496: pay_blt_shd.g_old_rec.tax_type;
497: End If;
498: If (p_rec.balance_category_id = hr_api.g_number) then
499: p_rec.balance_category_id :=
500: pay_blt_shd.g_old_rec.balance_category_id;
501: End If;
502: If (p_rec.base_balance_type_id = hr_api.g_number) then

Line 502: If (p_rec.base_balance_type_id = hr_api.g_number) then

498: If (p_rec.balance_category_id = hr_api.g_number) then
499: p_rec.balance_category_id :=
500: pay_blt_shd.g_old_rec.balance_category_id;
501: End If;
502: If (p_rec.base_balance_type_id = hr_api.g_number) then
503: p_rec.base_balance_type_id :=
504: pay_blt_shd.g_old_rec.base_balance_type_id;
505: End If;
506: If (p_rec.input_value_id = hr_api.g_number) then

Line 506: If (p_rec.input_value_id = hr_api.g_number) then

502: If (p_rec.base_balance_type_id = hr_api.g_number) then
503: p_rec.base_balance_type_id :=
504: pay_blt_shd.g_old_rec.base_balance_type_id;
505: End If;
506: If (p_rec.input_value_id = hr_api.g_number) then
507: p_rec.input_value_id :=
508: pay_blt_shd.g_old_rec.input_value_id;
509: End If;
510: --

Line 601: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2

597: Procedure upd
598: (p_effective_date in date
599: ,p_balance_type_id in number
600: ,p_object_version_number in out nocopy number
601: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
602: ,p_balance_uom in varchar2 default hr_api.g_varchar2
603: ,p_business_group_id in number default hr_api.g_number
604: ,p_legislation_code in varchar2 default hr_api.g_varchar2
605: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 602: ,p_balance_uom in varchar2 default hr_api.g_varchar2

598: (p_effective_date in date
599: ,p_balance_type_id in number
600: ,p_object_version_number in out nocopy number
601: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
602: ,p_balance_uom in varchar2 default hr_api.g_varchar2
603: ,p_business_group_id in number default hr_api.g_number
604: ,p_legislation_code in varchar2 default hr_api.g_varchar2
605: ,p_currency_code in varchar2 default hr_api.g_varchar2
606: ,p_balance_name in varchar2 default hr_api.g_varchar2

Line 603: ,p_business_group_id in number default hr_api.g_number

599: ,p_balance_type_id in number
600: ,p_object_version_number in out nocopy number
601: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
602: ,p_balance_uom in varchar2 default hr_api.g_varchar2
603: ,p_business_group_id in number default hr_api.g_number
604: ,p_legislation_code in varchar2 default hr_api.g_varchar2
605: ,p_currency_code in varchar2 default hr_api.g_varchar2
606: ,p_balance_name in varchar2 default hr_api.g_varchar2
607: ,p_comments in varchar2 default hr_api.g_varchar2

Line 604: ,p_legislation_code in varchar2 default hr_api.g_varchar2

600: ,p_object_version_number in out nocopy number
601: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
602: ,p_balance_uom in varchar2 default hr_api.g_varchar2
603: ,p_business_group_id in number default hr_api.g_number
604: ,p_legislation_code in varchar2 default hr_api.g_varchar2
605: ,p_currency_code in varchar2 default hr_api.g_varchar2
606: ,p_balance_name in varchar2 default hr_api.g_varchar2
607: ,p_comments in varchar2 default hr_api.g_varchar2
608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2

Line 605: ,p_currency_code in varchar2 default hr_api.g_varchar2

601: ,p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2
602: ,p_balance_uom in varchar2 default hr_api.g_varchar2
603: ,p_business_group_id in number default hr_api.g_number
604: ,p_legislation_code in varchar2 default hr_api.g_varchar2
605: ,p_currency_code in varchar2 default hr_api.g_varchar2
606: ,p_balance_name in varchar2 default hr_api.g_varchar2
607: ,p_comments in varchar2 default hr_api.g_varchar2
608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
609: ,p_reporting_name in varchar2 default hr_api.g_varchar2

Line 606: ,p_balance_name in varchar2 default hr_api.g_varchar2

602: ,p_balance_uom in varchar2 default hr_api.g_varchar2
603: ,p_business_group_id in number default hr_api.g_number
604: ,p_legislation_code in varchar2 default hr_api.g_varchar2
605: ,p_currency_code in varchar2 default hr_api.g_varchar2
606: ,p_balance_name in varchar2 default hr_api.g_varchar2
607: ,p_comments in varchar2 default hr_api.g_varchar2
608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
609: ,p_reporting_name in varchar2 default hr_api.g_varchar2
610: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 607: ,p_comments in varchar2 default hr_api.g_varchar2

603: ,p_business_group_id in number default hr_api.g_number
604: ,p_legislation_code in varchar2 default hr_api.g_varchar2
605: ,p_currency_code in varchar2 default hr_api.g_varchar2
606: ,p_balance_name in varchar2 default hr_api.g_varchar2
607: ,p_comments in varchar2 default hr_api.g_varchar2
608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
609: ,p_reporting_name in varchar2 default hr_api.g_varchar2
610: ,p_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2

604: ,p_legislation_code in varchar2 default hr_api.g_varchar2
605: ,p_currency_code in varchar2 default hr_api.g_varchar2
606: ,p_balance_name in varchar2 default hr_api.g_varchar2
607: ,p_comments in varchar2 default hr_api.g_varchar2
608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
609: ,p_reporting_name in varchar2 default hr_api.g_varchar2
610: ,p_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 609: ,p_reporting_name in varchar2 default hr_api.g_varchar2

605: ,p_currency_code in varchar2 default hr_api.g_varchar2
606: ,p_balance_name in varchar2 default hr_api.g_varchar2
607: ,p_comments in varchar2 default hr_api.g_varchar2
608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
609: ,p_reporting_name in varchar2 default hr_api.g_varchar2
610: ,p_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 610: ,p_attribute_category in varchar2 default hr_api.g_varchar2

606: ,p_balance_name in varchar2 default hr_api.g_varchar2
607: ,p_comments in varchar2 default hr_api.g_varchar2
608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
609: ,p_reporting_name in varchar2 default hr_api.g_varchar2
610: ,p_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 611: ,p_attribute1 in varchar2 default hr_api.g_varchar2

607: ,p_comments in varchar2 default hr_api.g_varchar2
608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
609: ,p_reporting_name in varchar2 default hr_api.g_varchar2
610: ,p_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 612: ,p_attribute2 in varchar2 default hr_api.g_varchar2

608: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
609: ,p_reporting_name in varchar2 default hr_api.g_varchar2
610: ,p_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 613: ,p_attribute3 in varchar2 default hr_api.g_varchar2

609: ,p_reporting_name in varchar2 default hr_api.g_varchar2
610: ,p_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 614: ,p_attribute4 in varchar2 default hr_api.g_varchar2

610: ,p_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 615: ,p_attribute5 in varchar2 default hr_api.g_varchar2

611: ,p_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 616: ,p_attribute6 in varchar2 default hr_api.g_varchar2

612: ,p_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 617: ,p_attribute7 in varchar2 default hr_api.g_varchar2

613: ,p_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 618: ,p_attribute8 in varchar2 default hr_api.g_varchar2

614: ,p_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 619: ,p_attribute9 in varchar2 default hr_api.g_varchar2

615: ,p_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 620: ,p_attribute10 in varchar2 default hr_api.g_varchar2

616: ,p_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 621: ,p_attribute11 in varchar2 default hr_api.g_varchar2

617: ,p_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 622: ,p_attribute12 in varchar2 default hr_api.g_varchar2

618: ,p_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 623: ,p_attribute13 in varchar2 default hr_api.g_varchar2

619: ,p_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 624: ,p_attribute14 in varchar2 default hr_api.g_varchar2

620: ,p_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 625: ,p_attribute15 in varchar2 default hr_api.g_varchar2

621: ,p_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 626: ,p_attribute16 in varchar2 default hr_api.g_varchar2

622: ,p_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 627: ,p_attribute17 in varchar2 default hr_api.g_varchar2

623: ,p_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_balance_category_id in number default hr_api.g_number

Line 628: ,p_attribute18 in varchar2 default hr_api.g_varchar2

624: ,p_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_balance_category_id in number default hr_api.g_number
632: ,p_base_balance_type_id in number default hr_api.g_number

Line 629: ,p_attribute19 in varchar2 default hr_api.g_varchar2

625: ,p_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_balance_category_id in number default hr_api.g_number
632: ,p_base_balance_type_id in number default hr_api.g_number
633: ,p_input_value_id in number default hr_api.g_number

Line 630: ,p_attribute20 in varchar2 default hr_api.g_varchar2

626: ,p_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_balance_category_id in number default hr_api.g_number
632: ,p_base_balance_type_id in number default hr_api.g_number
633: ,p_input_value_id in number default hr_api.g_number
634: ,p_balance_name_warning out nocopy number

Line 631: ,p_balance_category_id in number default hr_api.g_number

627: ,p_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_balance_category_id in number default hr_api.g_number
632: ,p_base_balance_type_id in number default hr_api.g_number
633: ,p_input_value_id in number default hr_api.g_number
634: ,p_balance_name_warning out nocopy number
635: ) is

Line 632: ,p_base_balance_type_id in number default hr_api.g_number

628: ,p_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_balance_category_id in number default hr_api.g_number
632: ,p_base_balance_type_id in number default hr_api.g_number
633: ,p_input_value_id in number default hr_api.g_number
634: ,p_balance_name_warning out nocopy number
635: ) is
636: --

Line 633: ,p_input_value_id in number default hr_api.g_number

629: ,p_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_balance_category_id in number default hr_api.g_number
632: ,p_base_balance_type_id in number default hr_api.g_number
633: ,p_input_value_id in number default hr_api.g_number
634: ,p_balance_name_warning out nocopy number
635: ) is
636: --
637: l_rec pay_blt_shd.g_rec_type;

Line 642: l_jurisdiction_level number := hr_api.g_number;

638: l_proc varchar2(72) := g_package||'upd';
639:
640: -- Bug 4248768. jurisdiction_level and tax type
641: -- must not be defaulted to null.
642: l_jurisdiction_level number := hr_api.g_number;
643: l_tax_type varchar2(30) := hr_api.g_varchar2;
644: l_balance_name_warning number;
645: --
646: Begin

Line 643: l_tax_type varchar2(30) := hr_api.g_varchar2;

639:
640: -- Bug 4248768. jurisdiction_level and tax type
641: -- must not be defaulted to null.
642: l_jurisdiction_level number := hr_api.g_number;
643: l_tax_type varchar2(30) := hr_api.g_varchar2;
644: l_balance_name_warning number;
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);