DBA Data[Home] [Help]

APPS.AME_ITC_DEL dependencies on AME_ITC_SHD

Line 54: (p_rec in out nocopy ame_itc_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ame_itc_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 97: (p_rec in out nocopy ame_itc_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy ame_itc_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date

Line 154: (p_rec in out nocopy ame_itc_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy ame_itc_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date

Line 169: := ame_itc_shd.g_old_rec.start_date;

165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.start_date
169: := ame_itc_shd.g_old_rec.start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.end_date := p_validation_start_date;
173: Else

Line 179: ame_itc_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ame_itc_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_item_class_id => p_rec.item_class_id
182: ,p_new_effective_end_date => p_rec.end_date
183: ,p_validation_start_date => p_validation_start_date

Line 228: (p_rec in out nocopy ame_itc_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy ame_itc_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 288: (p_rec in ame_itc_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in ame_itc_shd.g_rec_type
289: ,p_effective_date in date
290: ,p_datetrack_mode in varchar2
291: ,p_validation_start_date in date
292: ,p_validation_end_date in date

Line 309: ,p_name_o => ame_itc_shd.g_old_rec.name

305: ,p_validation_end_date => p_validation_end_date
306: ,p_item_class_id => p_rec.item_class_id
307: ,p_start_date => p_rec.start_date
308: ,p_end_date => p_rec.end_date
309: ,p_name_o => ame_itc_shd.g_old_rec.name
310: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date
311: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date
312: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number
313: );

Line 310: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date

306: ,p_item_class_id => p_rec.item_class_id
307: ,p_start_date => p_rec.start_date
308: ,p_end_date => p_rec.end_date
309: ,p_name_o => ame_itc_shd.g_old_rec.name
310: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date
311: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date
312: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number
313: );
314: --

Line 311: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date

307: ,p_start_date => p_rec.start_date
308: ,p_end_date => p_rec.end_date
309: ,p_name_o => ame_itc_shd.g_old_rec.name
310: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date
311: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date
312: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number
313: );
314: --
315: exception

Line 312: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number

308: ,p_end_date => p_rec.end_date
309: ,p_name_o => ame_itc_shd.g_old_rec.name
310: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date
311: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date
312: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number
313: );
314: --
315: exception
316: --

Line 334: ,p_rec in out nocopy ame_itc_shd.g_rec_type

330: -- ----------------------------------------------------------------------------
331: Procedure del
332: (p_effective_date in date
333: ,p_datetrack_mode in varchar2
334: ,p_rec in out nocopy ame_itc_shd.g_rec_type
335: ) is
336: --
337: l_proc varchar2(72) := g_package||'del';
338: l_validation_start_date date;

Line 350: ame_itc_shd.lck

346: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
347: --
348: -- We must lock the row which we need to delete.
349: --
350: ame_itc_shd.lck
351: (p_effective_date => p_effective_date
352: ,p_datetrack_mode => p_datetrack_mode
353: ,p_item_class_id => p_rec.item_class_id
354: ,p_object_version_number => p_rec.object_version_number

Line 419: l_rec ame_itc_shd.g_rec_type;

415: ,p_start_date out nocopy date
416: ,p_end_date out nocopy date
417: ) is
418: --
419: l_rec ame_itc_shd.g_rec_type;
420: l_proc varchar2(72) := g_package||'del';
421: --
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);