DBA Data[Home] [Help]

APPS.PAY_CAL_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 113: When hr_api.check_integrity_violated Then

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

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

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

Line 118: When hr_api.unique_integrity_violated Then

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

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

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

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

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

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

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

Line 442: when hr_api.cannot_find_prog_unit then

438: );
439: --
440: exception
441: --
442: when hr_api.cannot_find_prog_unit then
443: --
444: hr_api.cannot_find_prog_unit_error
445: (p_module_name => 'PAY_COST_ALLOCATIONS_F'
446: ,p_hook_type => 'AU');

Line 444: hr_api.cannot_find_prog_unit_error

440: exception
441: --
442: when hr_api.cannot_find_prog_unit then
443: --
444: hr_api.cannot_find_prog_unit_error
445: (p_module_name => 'PAY_COST_ALLOCATIONS_F'
446: ,p_hook_type => 'AU');
447: --
448: end;

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

503: -- p_rec plsql record structure
504: -- to see if a system default is being used. If a system default
505: -- is being used then we must set to the 'current' argument value.
506: --
507: If (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: pay_cal_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then

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

507: If (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: pay_cal_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
512: p_rec.cost_allocation_keyflex_id :=
513: pay_cal_shd.g_old_rec.cost_allocation_keyflex_id;
514: End If;
515: If (p_rec.assignment_id = hr_api.g_number) then

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

511: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
512: p_rec.cost_allocation_keyflex_id :=
513: pay_cal_shd.g_old_rec.cost_allocation_keyflex_id;
514: End If;
515: If (p_rec.assignment_id = hr_api.g_number) then
516: p_rec.assignment_id :=
517: pay_cal_shd.g_old_rec.assignment_id;
518: End If;
519: If (p_rec.proportion = hr_api.g_number) then

Line 519: If (p_rec.proportion = hr_api.g_number) then

515: If (p_rec.assignment_id = hr_api.g_number) then
516: p_rec.assignment_id :=
517: pay_cal_shd.g_old_rec.assignment_id;
518: End If;
519: If (p_rec.proportion = hr_api.g_number) then
520: p_rec.proportion :=
521: pay_cal_shd.g_old_rec.proportion;
522: End If;
523: If (p_rec.request_id = hr_api.g_number) then

Line 523: If (p_rec.request_id = hr_api.g_number) then

519: If (p_rec.proportion = hr_api.g_number) then
520: p_rec.proportion :=
521: pay_cal_shd.g_old_rec.proportion;
522: End If;
523: If (p_rec.request_id = hr_api.g_number) then
524: p_rec.request_id :=
525: pay_cal_shd.g_old_rec.request_id;
526: End If;
527: If (p_rec.program_application_id = hr_api.g_number) then

Line 527: If (p_rec.program_application_id = hr_api.g_number) then

523: If (p_rec.request_id = hr_api.g_number) then
524: p_rec.request_id :=
525: pay_cal_shd.g_old_rec.request_id;
526: End If;
527: If (p_rec.program_application_id = hr_api.g_number) then
528: p_rec.program_application_id :=
529: pay_cal_shd.g_old_rec.program_application_id;
530: End If;
531: If (p_rec.program_id = hr_api.g_number) then

Line 531: If (p_rec.program_id = hr_api.g_number) then

527: If (p_rec.program_application_id = hr_api.g_number) then
528: p_rec.program_application_id :=
529: pay_cal_shd.g_old_rec.program_application_id;
530: End If;
531: If (p_rec.program_id = hr_api.g_number) then
532: p_rec.program_id :=
533: pay_cal_shd.g_old_rec.program_id;
534: End If;
535: If (p_rec.program_update_date = hr_api.g_date) then

Line 535: If (p_rec.program_update_date = hr_api.g_date) then

531: If (p_rec.program_id = hr_api.g_number) then
532: p_rec.program_id :=
533: pay_cal_shd.g_old_rec.program_id;
534: End If;
535: If (p_rec.program_update_date = hr_api.g_date) then
536: p_rec.program_update_date :=
537: pay_cal_shd.g_old_rec.program_update_date;
538: End If;
539: --

Line 634: ,p_business_group_id in number default hr_api.g_number

630: (p_effective_date in date
631: ,p_datetrack_mode in varchar2
632: ,p_cost_allocation_id in number
633: ,p_object_version_number in out nocopy number
634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number

Line 635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number

631: ,p_datetrack_mode in varchar2
632: ,p_cost_allocation_id in number
633: ,p_object_version_number in out nocopy number
634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number

Line 636: ,p_assignment_id in number default hr_api.g_number

632: ,p_cost_allocation_id in number
633: ,p_object_version_number in out nocopy number
634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number

Line 637: ,p_proportion in number default hr_api.g_number

633: ,p_object_version_number in out nocopy number
634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date

Line 638: ,p_request_id in number default hr_api.g_number

634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date
642: ,p_effective_start_date out nocopy date

Line 639: ,p_program_application_id in number default hr_api.g_number

635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date
642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date

Line 640: ,p_program_id in number default hr_api.g_number

636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date
642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date
644: ) is

Line 641: ,p_program_update_date in date default hr_api.g_date

637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date
642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date
644: ) is
645: --