[Home] [Help]
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_asg_del.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |----------------------------< dt_delete_dml >-----------------------------|
13: -- ----------------------------------------------------------------------------
60: --
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 = 'DELETE_NEXT_CHANGE') then
66: hr_utility.set_location(l_proc, 10);
67: per_asg_shd.g_api_dml := true; -- Set the api dml status
68: --
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
66: hr_utility.set_location(l_proc, 10);
67: per_asg_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Delete the where the effective start date is equal
70: -- to the validation end date.
74: and effective_start_date = p_validation_start_date;
75: --
76: per_asg_shd.g_api_dml := false; -- Unset the api dml status
77: Else
78: hr_utility.set_location(l_proc, 15);
79: per_asg_shd.g_api_dml := true; -- Set the api dml status
80: --
81: -- Delete the row(s) where the effective start date is greater than
82: -- or equal to the validation start date.
86: and effective_start_date >= p_validation_start_date;
87: --
88: per_asg_shd.g_api_dml := false; -- Unset the api dml status
89: End If;
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: per_asg_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: l_proc varchar2(72) := g_package||'delete_dml';
109: --
110: Begin
111: hr_utility.set_location('Entering:'||l_proc, 5);
112: --
113: dt_delete_dml(p_rec => p_rec,
114: p_effective_date => p_effective_date,
115: p_datetrack_mode => p_datetrack_mode,
115: p_datetrack_mode => p_datetrack_mode,
116: p_validation_start_date => p_validation_start_date,
117: p_validation_end_date => p_validation_end_date);
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: End delete_dml;
121: --
122: -- ----------------------------------------------------------------------------
123: -- |----------------------------< dt_pre_delete >-----------------------------|
161: --
162: l_proc varchar2(72) := g_package||'dt_pre_delete';
163: --
164: Begin
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := per_asg_shd.g_old_rec.effective_start_date;
192: --
193: -- 70.1 change g end.
194: --
195: End If;
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
197: End dt_pre_delete;
198: --
199: -- ----------------------------------------------------------------------------
200: -- |------------------------------< pre_delete >------------------------------|
256: or asg2.effective_end_date < p_validation_start_date));
257: --
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: --
263: -- Delete any possible comments
264: --
272: p_datetrack_mode => p_datetrack_mode,
273: p_validation_start_date => p_validation_start_date,
274: p_validation_end_date => p_validation_end_date);
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: End pre_delete;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |-----------------------------< post_delete >------------------------------|
349: l_assgt_term_elements boolean;
350: l_org_now_no_manager_warning boolean;
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: --
355: -- Start of API User Hook for post_delete.
356: --
357: if g_debug then
354: --
355: -- Start of API User Hook for post_delete.
356: --
357: if g_debug then
358: hr_utility.set_location('Before calling post_delete checks ', 10);
359: end if;
360: -- 4888485 -- Added new params
361: hr_assignment_internal.post_delete
362: (p_rec => p_rec,
632: -- Temporary hardcoded hook added for pay object group functionality. Will
633: -- replace by proper hook when dynamic triggers for assignments converted
634: -- to package dynamic triggers.
635: --
636: hr_utility.trace('ovn: '||to_char(p_rec.object_version_number));
637: pay_pog_all_assignments_pkg.after_delete
638: (p_effective_date => p_effective_date
639: ,p_datetrack_mode => p_datetrack_mode
640: ,p_validation_start_date => p_validation_start_date
765: p_datetrack_mode);
766:
767: -- End of call to Workflow Sync Procedure For Assignments
768: --
769: hr_utility.set_location(' Leaving:'||l_proc, 10);
770: End post_delete;
771: --
772: -- ----------------------------------------------------------------------------
773: -- |---------------------------------< del >----------------------------------|
820: l_reterm_lspd date;
821: l_appl_asg_new_end_date date;
822: --
823: Begin
824: hr_utility.set_location('Entering:'||l_proc, 5);
825: --
826: -- Ensure that the DateTrack delete mode is valid
827: --
828: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
950: If p_validate then
951: Raise HR_Api.Validate_Enabled;
952: End If;
953: --
954: hr_utility.set_location(' Leaving:'||l_proc, 10);
955: Exception
956: When HR_Api.Validate_Enabled Then
957: --
958: -- As the Validate_Enabled exception has been raised
987: l_rec per_asg_shd.g_rec_type;
988: l_proc varchar2(72) := g_package||'del';
989: --
990: Begin
991: hr_utility.set_location('Entering:'||l_proc, 5);
992: --
993: -- As the delete procedure accepts a plsql record structure we do need to
994: -- convert the arguments into the record structure.
995: -- We don't need to call the supplied conversion argument routine as we
1029: p_effective_start_date := l_rec.effective_start_date;
1030: p_effective_end_date := l_rec.effective_end_date;
1031: -- p_business_group_id := per_asg_shd.g_old_rec.business_group_id;
1032: --
1033: hr_utility.set_location(' Leaving:'||l_proc, 10);
1034: End del;
1035: --
1036: -- ----------------------------------------------------------------------------
1037: -- |---------------------------------< del >----------------------------------|
1063: l_cobra_coverage_elements boolean;
1064: l_assgt_term_elements boolean;
1065: --
1066: Begin
1067: hr_utility.set_location('Entering:'||l_proc, 5);
1068: --
1069: del(p_validate,
1070: p_assignment_id,
1071: p_effective_date,
1090: p_validation_end_date := p_effective_end_date;
1091: --Added for 5012244
1092: p_business_group_id := per_asg_shd.g_old_rec.business_group_id;
1093: --
1094: hr_utility.set_location('Leaving'||l_proc, 25);
1095: End del;
1096: --
1097: end per_asg_del;