DBA Data[Home] [Help]

APPS.PAY_ETP_DEL dependencies on HR_API

Line 65: If (p_datetrack_mode = hr_api.g_delete_next_change) then

61: l_proc varchar2(72) := g_package||'dt_delete_dml';
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: pay_etp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.

Line 115: p_datetrack_mode = hr_api.g_zap) THEN

111: BEGIN
112: --
113: IF ((hr_startup_data_api_support.return_startup_mode
114: IN ('STARTUP','GENERIC')) AND
115: p_datetrack_mode = hr_api.g_zap) THEN
116: --
117: DELETE FROM hr_application_ownerships
118: WHERE key_name = p_pk_column
119: AND key_value = p_pk_value;

Line 208: If (p_datetrack_mode <> hr_api.g_zap) then

204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: If (p_datetrack_mode <> hr_api.g_zap) then
209: --
210: p_rec.effective_start_date
211: := pay_etp_shd.g_old_rec.effective_start_date;
212: --

Line 213: If (p_datetrack_mode = hr_api.g_delete) then

209: --
210: p_rec.effective_start_date
211: := pay_etp_shd.g_old_rec.effective_start_date;
212: --
213: If (p_datetrack_mode = hr_api.g_delete) then
214: p_rec.effective_end_date := p_validation_start_date - 1;
215: Else
216: p_rec.effective_end_date := p_validation_end_date;
217: End If;

Line 573: when hr_api.cannot_find_prog_unit then

569: );
570: --
571: exception
572: --
573: when hr_api.cannot_find_prog_unit then
574: --
575: hr_api.cannot_find_prog_unit_error
576: (p_module_name => 'PAY_ELEMENT_TYPES_F'
577: ,p_hook_type => 'AD');

Line 575: hr_api.cannot_find_prog_unit_error

571: exception
572: --
573: when hr_api.cannot_find_prog_unit then
574: --
575: hr_api.cannot_find_prog_unit_error
576: (p_module_name => 'PAY_ELEMENT_TYPES_F'
577: ,p_hook_type => 'AD');
578: --
579: end;

Line 632: If p_datetrack_mode = hr_api.g_zap Then

628: );
629: --
630: -- Cascade delete the child entities
631: --
632: If p_datetrack_mode = hr_api.g_zap Then
633: -- We need to delete the database items for the deleted element
634: hrdyndbi.delete_element_type_dict (p_rec.element_type_id);
635: -- -- We need to delete any payroll frequency rules for the element
636: --

Line 652: Elsif p_datetrack_mode = hr_api.g_delete Then

648: -- Delete from TL table
649: --
650: pay_ett_del.del_tl(p_rec.element_type_id);
651: --
652: Elsif p_datetrack_mode = hr_api.g_delete Then
653: -- -- We need to remove any payroll frequency rules starting after the new end
654: -- date
655: --
656: delete from pay_ele_payroll_freq_rules

Line 680: If p_datetrack_mode <> hr_api.g_delete_next_change Then

676: End Loop;
677: --
678: p_balance_feeds_warning := l_balance_feeds_warning;
679: --
680: If p_datetrack_mode <> hr_api.g_delete_next_change Then
681: --
682: ben_benefit_contributions_pkg.parent_deleted
683: (p_rec.element_type_id,
684: p_datetrack_mode,

Line 726: If (l_validation_end_date = hr_api.g_eot and

722: p_rec.legislation_subgroup := pay_etp_shd.g_old_rec.legislation_subgroup;
723: --
724: -- Set the processing_rules_warning parameter
725: --
726: If (l_validation_end_date = hr_api.g_eot and
727: p_datetrack_mode = hr_api.g_delete_next_change) Then
728: --
729: p_processing_rules_warning := True;
730: --

Line 727: p_datetrack_mode = hr_api.g_delete_next_change) Then

723: --
724: -- Set the processing_rules_warning parameter
725: --
726: If (l_validation_end_date = hr_api.g_eot and
727: p_datetrack_mode = hr_api.g_delete_next_change) Then
728: --
729: p_processing_rules_warning := True;
730: --
731: End If;