DBA Data[Home] [Help]

APPS.PAY_ROM_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 112: When hr_api.check_integrity_violated Then

108: End If;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 15);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: pay_rom_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: pay_rom_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: pay_rom_shd.constraint_error

Line 117: When hr_api.unique_integrity_violated Then

113: -- A check constraint has been violated
114: --
115: pay_rom_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: pay_rom_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: pay_rom_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
124: Raise;
125: End dt_update_dml;

Line 238: If (p_datetrack_mode <> hr_api.g_correction) then

234: l_dummy_version_number number;
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: If (p_datetrack_mode <> hr_api.g_correction) then
239: --
240: -- Update the current effective end date
241: --
242: pay_rom_shd.upd_effective_end_date

Line 251: If (p_datetrack_mode = hr_api.g_update_override) then

247: ,p_validation_end_date => p_validation_end_date
248: ,p_object_version_number => l_dummy_version_number
249: );
250: --
251: If (p_datetrack_mode = hr_api.g_update_override) then
252: --
253: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
254: -- delete any future rows
255: --

Line 430: when hr_api.cannot_find_prog_unit then

426: );
427: --
428: exception
429: --
430: when hr_api.cannot_find_prog_unit then
431: --
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'PAY_RUN_TYPE_ORG_METHODS_F'
434: ,p_hook_type => 'AU');

Line 432: hr_api.cannot_find_prog_unit_error

428: exception
429: --
430: when hr_api.cannot_find_prog_unit then
431: --
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'PAY_RUN_TYPE_ORG_METHODS_F'
434: ,p_hook_type => 'AU');
435: --
436: end;

Line 495: If (p_rec.run_type_id = hr_api.g_number) then

491: -- p_rec plsql record structure
492: -- to see if a system default is being used. If a system default
493: -- is being used then we must set to the 'current' argument value.
494: --
495: If (p_rec.run_type_id = hr_api.g_number) then
496: p_rec.run_type_id :=
497: pay_rom_shd.g_old_rec.run_type_id;
498: End If;
499: If (p_rec.org_payment_method_id = hr_api.g_number) then

Line 499: If (p_rec.org_payment_method_id = hr_api.g_number) then

495: If (p_rec.run_type_id = hr_api.g_number) then
496: p_rec.run_type_id :=
497: pay_rom_shd.g_old_rec.run_type_id;
498: End If;
499: If (p_rec.org_payment_method_id = hr_api.g_number) then
500: p_rec.org_payment_method_id :=
501: pay_rom_shd.g_old_rec.org_payment_method_id;
502: End If;
503: If (p_rec.priority = hr_api.g_number) then

Line 503: If (p_rec.priority = hr_api.g_number) then

499: If (p_rec.org_payment_method_id = hr_api.g_number) then
500: p_rec.org_payment_method_id :=
501: pay_rom_shd.g_old_rec.org_payment_method_id;
502: End If;
503: If (p_rec.priority = hr_api.g_number) then
504: p_rec.priority :=
505: pay_rom_shd.g_old_rec.priority;
506: End If;
507: If (p_rec.percentage = hr_api.g_number) then

Line 507: If (p_rec.percentage = hr_api.g_number) then

503: If (p_rec.priority = hr_api.g_number) then
504: p_rec.priority :=
505: pay_rom_shd.g_old_rec.priority;
506: End If;
507: If (p_rec.percentage = hr_api.g_number) then
508: p_rec.percentage :=
509: pay_rom_shd.g_old_rec.percentage;
510: End If;
511: If (p_rec.amount = hr_api.g_number) then

Line 511: If (p_rec.amount = hr_api.g_number) then

507: If (p_rec.percentage = hr_api.g_number) then
508: p_rec.percentage :=
509: pay_rom_shd.g_old_rec.percentage;
510: End If;
511: If (p_rec.amount = hr_api.g_number) then
512: p_rec.amount :=
513: pay_rom_shd.g_old_rec.amount;
514: End If;
515: If (p_rec.business_group_id = hr_api.g_number) then

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

511: If (p_rec.amount = hr_api.g_number) then
512: p_rec.amount :=
513: pay_rom_shd.g_old_rec.amount;
514: End If;
515: If (p_rec.business_group_id = hr_api.g_number) then
516: p_rec.business_group_id :=
517: pay_rom_shd.g_old_rec.business_group_id;
518: End If;
519: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

515: If (p_rec.business_group_id = hr_api.g_number) then
516: p_rec.business_group_id :=
517: pay_rom_shd.g_old_rec.business_group_id;
518: End If;
519: If (p_rec.legislation_code = hr_api.g_varchar2) then
520: p_rec.legislation_code :=
521: pay_rom_shd.g_old_rec.legislation_code;
522: End If;
523: --

Line 612: ,p_priority in number default hr_api.g_number

608: (p_effective_date in date
609: ,p_datetrack_mode in varchar2
610: ,p_run_type_org_method_id in number
611: ,p_object_version_number in out nocopy number
612: ,p_priority in number default hr_api.g_number
613: ,p_percentage in number default hr_api.g_number
614: ,p_amount in number default hr_api.g_number
615: ,p_effective_start_date out nocopy date
616: ,p_effective_end_date out nocopy date

Line 613: ,p_percentage in number default hr_api.g_number

609: ,p_datetrack_mode in varchar2
610: ,p_run_type_org_method_id in number
611: ,p_object_version_number in out nocopy number
612: ,p_priority in number default hr_api.g_number
613: ,p_percentage in number default hr_api.g_number
614: ,p_amount in number default hr_api.g_number
615: ,p_effective_start_date out nocopy date
616: ,p_effective_end_date out nocopy date
617: ) is

Line 614: ,p_amount in number default hr_api.g_number

610: ,p_run_type_org_method_id in number
611: ,p_object_version_number in out nocopy number
612: ,p_priority in number default hr_api.g_number
613: ,p_percentage in number default hr_api.g_number
614: ,p_amount in number default hr_api.g_number
615: ,p_effective_start_date out nocopy date
616: ,p_effective_end_date out nocopy date
617: ) is
618: --

Line 630: (hr_api.g_number

626: -- l_rec structure.
627: --
628: l_rec :=
629: pay_rom_shd.convert_args
630: (hr_api.g_number
631: ,hr_api.g_number
632: ,null
633: ,null
634: ,p_priority

Line 631: ,hr_api.g_number

627: --
628: l_rec :=
629: pay_rom_shd.convert_args
630: (hr_api.g_number
631: ,hr_api.g_number
632: ,null
633: ,null
634: ,p_priority
635: ,p_percentage

Line 639: ,hr_api.g_number

635: ,p_percentage
636: ,p_amount
637: ,p_object_version_number
638: ,p_run_type_org_method_id
639: ,hr_api.g_number
640: ,hr_api.g_varchar2
641: );
642: --
643: -- Having converted the arguments into the

Line 640: ,hr_api.g_varchar2

636: ,p_amount
637: ,p_object_version_number
638: ,p_run_type_org_method_id
639: ,hr_api.g_number
640: ,hr_api.g_varchar2
641: );
642: --
643: -- Having converted the arguments into the
644: -- plsql record structure we call the corresponding record