DBA Data[Home] [Help]

APPS.PAY_EVC_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 115: When hr_api.check_integrity_violated Then

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

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

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

Line 120: When hr_api.unique_integrity_violated Then

116: -- A check constraint has been violated
117: --
118: pay_evc_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: pay_evc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: pay_evc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
127: Raise;
128: End dt_update_dml;

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

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

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

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

Line 440: when hr_api.cannot_find_prog_unit then

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

Line 442: hr_api.cannot_find_prog_unit_error

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

Line 505: If (p_rec.event_qualifier_id = hr_api.g_number) then

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

Line 509: If (p_rec.datetracked_event_id = hr_api.g_number) then

505: If (p_rec.event_qualifier_id = hr_api.g_number) then
506: p_rec.event_qualifier_id :=
507: pay_evc_shd.g_old_rec.event_qualifier_id;
508: End If;
509: If (p_rec.datetracked_event_id = hr_api.g_number) then
510: p_rec.datetracked_event_id :=
511: pay_evc_shd.g_old_rec.datetracked_event_id;
512: End If;
513: If (p_rec.default_event = hr_api.g_varchar2) then

Line 513: If (p_rec.default_event = hr_api.g_varchar2) then

509: If (p_rec.datetracked_event_id = hr_api.g_number) then
510: p_rec.datetracked_event_id :=
511: pay_evc_shd.g_old_rec.datetracked_event_id;
512: End If;
513: If (p_rec.default_event = hr_api.g_varchar2) then
514: p_rec.default_event :=
515: pay_evc_shd.g_old_rec.default_event;
516: End If;
517: If (p_rec.valid_event = hr_api.g_varchar2) then

Line 517: If (p_rec.valid_event = hr_api.g_varchar2) then

513: If (p_rec.default_event = hr_api.g_varchar2) then
514: p_rec.default_event :=
515: pay_evc_shd.g_old_rec.default_event;
516: End If;
517: If (p_rec.valid_event = hr_api.g_varchar2) then
518: p_rec.valid_event :=
519: pay_evc_shd.g_old_rec.valid_event;
520: End If;
521: If (p_rec.business_group_id = hr_api.g_number) then

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

517: If (p_rec.valid_event = hr_api.g_varchar2) then
518: p_rec.valid_event :=
519: pay_evc_shd.g_old_rec.valid_event;
520: End If;
521: If (p_rec.business_group_id = hr_api.g_number) then
522: p_rec.business_group_id :=
523: pay_evc_shd.g_old_rec.business_group_id;
524: End If;
525: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

521: If (p_rec.business_group_id = hr_api.g_number) then
522: p_rec.business_group_id :=
523: pay_evc_shd.g_old_rec.business_group_id;
524: End If;
525: If (p_rec.legislation_code = hr_api.g_varchar2) then
526: p_rec.legislation_code :=
527: pay_evc_shd.g_old_rec.legislation_code;
528: End If;
529: If (p_rec.from_value = hr_api.g_varchar2) then

Line 529: If (p_rec.from_value = hr_api.g_varchar2) then

525: If (p_rec.legislation_code = hr_api.g_varchar2) then
526: p_rec.legislation_code :=
527: pay_evc_shd.g_old_rec.legislation_code;
528: End If;
529: If (p_rec.from_value = hr_api.g_varchar2) then
530: p_rec.from_value :=
531: pay_evc_shd.g_old_rec.from_value;
532: End If;
533: If (p_rec.to_value = hr_api.g_varchar2) then

Line 533: If (p_rec.to_value = hr_api.g_varchar2) then

529: If (p_rec.from_value = hr_api.g_varchar2) then
530: p_rec.from_value :=
531: pay_evc_shd.g_old_rec.from_value;
532: End If;
533: If (p_rec.to_value = hr_api.g_varchar2) then
534: p_rec.to_value :=
535: pay_evc_shd.g_old_rec.to_value;
536: End If;
537: If (p_rec.proration_style = hr_api.g_varchar2) then

Line 537: If (p_rec.proration_style = hr_api.g_varchar2) then

533: If (p_rec.to_value = hr_api.g_varchar2) then
534: p_rec.to_value :=
535: pay_evc_shd.g_old_rec.to_value;
536: End If;
537: If (p_rec.proration_style = hr_api.g_varchar2) then
538: p_rec.proration_style :=
539: pay_evc_shd.g_old_rec.proration_style;
540: End If;
541: If (p_rec.qualifier_value = hr_api.g_varchar2) then

Line 541: If (p_rec.qualifier_value = hr_api.g_varchar2) then

537: If (p_rec.proration_style = hr_api.g_varchar2) then
538: p_rec.proration_style :=
539: pay_evc_shd.g_old_rec.proration_style;
540: End If;
541: If (p_rec.qualifier_value = hr_api.g_varchar2) then
542: p_rec.qualifier_value :=
543: pay_evc_shd.g_old_rec.qualifier_value;
544: End If;
545: --

Line 640: ,p_from_value in varchar2 default hr_api.g_varchar2

636: (p_effective_date in date
637: ,p_datetrack_mode in varchar2
638: ,p_event_value_change_id in number
639: ,p_object_version_number in out nocopy number
640: ,p_from_value in varchar2 default hr_api.g_varchar2
641: ,p_to_value in varchar2 default hr_api.g_varchar2
642: ,p_valid_event in varchar2 default hr_api.g_varchar2
643: ,p_proration_style in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_value in varchar2 default hr_api.g_varchar2

Line 641: ,p_to_value in varchar2 default hr_api.g_varchar2

637: ,p_datetrack_mode in varchar2
638: ,p_event_value_change_id in number
639: ,p_object_version_number in out nocopy number
640: ,p_from_value in varchar2 default hr_api.g_varchar2
641: ,p_to_value in varchar2 default hr_api.g_varchar2
642: ,p_valid_event in varchar2 default hr_api.g_varchar2
643: ,p_proration_style in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_value in varchar2 default hr_api.g_varchar2
645: ,p_effective_start_date out nocopy date

Line 642: ,p_valid_event in varchar2 default hr_api.g_varchar2

638: ,p_event_value_change_id in number
639: ,p_object_version_number in out nocopy number
640: ,p_from_value in varchar2 default hr_api.g_varchar2
641: ,p_to_value in varchar2 default hr_api.g_varchar2
642: ,p_valid_event in varchar2 default hr_api.g_varchar2
643: ,p_proration_style in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_value in varchar2 default hr_api.g_varchar2
645: ,p_effective_start_date out nocopy date
646: ,p_effective_end_date out nocopy date

Line 643: ,p_proration_style in varchar2 default hr_api.g_varchar2

639: ,p_object_version_number in out nocopy number
640: ,p_from_value in varchar2 default hr_api.g_varchar2
641: ,p_to_value in varchar2 default hr_api.g_varchar2
642: ,p_valid_event in varchar2 default hr_api.g_varchar2
643: ,p_proration_style in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_value in varchar2 default hr_api.g_varchar2
645: ,p_effective_start_date out nocopy date
646: ,p_effective_end_date out nocopy date
647: ) is

Line 644: ,p_qualifier_value in varchar2 default hr_api.g_varchar2

640: ,p_from_value in varchar2 default hr_api.g_varchar2
641: ,p_to_value in varchar2 default hr_api.g_varchar2
642: ,p_valid_event in varchar2 default hr_api.g_varchar2
643: ,p_proration_style in varchar2 default hr_api.g_varchar2
644: ,p_qualifier_value in varchar2 default hr_api.g_varchar2
645: ,p_effective_start_date out nocopy date
646: ,p_effective_end_date out nocopy date
647: ) is
648: --

Line 663: ,hr_api.g_number

659: pay_evc_shd.convert_args
660: (p_event_value_change_id
661: ,null
662: ,null
663: ,hr_api.g_number
664: ,hr_api.g_number
665: ,hr_api.g_varchar2
666: ,p_valid_event
667: ,hr_api.g_number

Line 664: ,hr_api.g_number

660: (p_event_value_change_id
661: ,null
662: ,null
663: ,hr_api.g_number
664: ,hr_api.g_number
665: ,hr_api.g_varchar2
666: ,p_valid_event
667: ,hr_api.g_number
668: ,hr_api.g_varchar2

Line 665: ,hr_api.g_varchar2

661: ,null
662: ,null
663: ,hr_api.g_number
664: ,hr_api.g_number
665: ,hr_api.g_varchar2
666: ,p_valid_event
667: ,hr_api.g_number
668: ,hr_api.g_varchar2
669: ,p_from_value

Line 667: ,hr_api.g_number

663: ,hr_api.g_number
664: ,hr_api.g_number
665: ,hr_api.g_varchar2
666: ,p_valid_event
667: ,hr_api.g_number
668: ,hr_api.g_varchar2
669: ,p_from_value
670: ,p_to_value
671: ,p_proration_style

Line 668: ,hr_api.g_varchar2

664: ,hr_api.g_number
665: ,hr_api.g_varchar2
666: ,p_valid_event
667: ,hr_api.g_number
668: ,hr_api.g_varchar2
669: ,p_from_value
670: ,p_to_value
671: ,p_proration_style
672: ,p_qualifier_value