DBA Data[Home] [Help]

APPS.AME_ITU_DEL dependencies on AME_ITU_SHD

Line 54: (p_rec in out nocopy ame_itu_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ame_itu_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 99: (p_rec in out nocopy ame_itu_shd.g_rec_type

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

Line 156: (p_rec in out nocopy ame_itu_shd.g_rec_type

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

Line 171: := ame_itu_shd.g_old_rec.start_date;

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

Line 181: ame_itu_shd.upd_effective_end_date

177: End If;
178: --
179: -- Update the current effective end date record
180: --
181: ame_itu_shd.upd_effective_end_date
182: (p_effective_date => p_effective_date
183: ,p_item_class_id => p_rec.item_class_id
184: ,p_application_id => p_rec.application_id
185: ,p_new_effective_end_date => p_rec.end_date

Line 231: (p_rec in out nocopy ame_itu_shd.g_rec_type

227: --
228: -- {End Of Comments}
229: -- ----------------------------------------------------------------------------
230: Procedure pre_delete
231: (p_rec in out nocopy ame_itu_shd.g_rec_type
232: ,p_effective_date in date
233: ,p_datetrack_mode in varchar2
234: ,p_validation_start_date in date
235: ,p_validation_end_date in date

Line 291: (p_rec in ame_itu_shd.g_rec_type

287: --
288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure post_delete
291: (p_rec in ame_itu_shd.g_rec_type
292: ,p_effective_date in date
293: ,p_datetrack_mode in varchar2
294: ,p_validation_start_date in date
295: ,p_validation_end_date in date

Line 313: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query

309: ,p_application_id => p_rec.application_id
310: ,p_item_class_id => p_rec.item_class_id
311: ,p_start_date => p_rec.start_date
312: ,p_end_date => p_rec.end_date
313: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
314: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
315: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
316: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
317: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date

Line 314: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number

310: ,p_item_class_id => p_rec.item_class_id
311: ,p_start_date => p_rec.start_date
312: ,p_end_date => p_rec.end_date
313: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
314: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
315: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
316: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
317: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
318: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date

Line 315: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode

311: ,p_start_date => p_rec.start_date
312: ,p_end_date => p_rec.end_date
313: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
314: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
315: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
316: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
317: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
318: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
319: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number

Line 316: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode

312: ,p_end_date => p_rec.end_date
313: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
314: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
315: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
316: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
317: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
318: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
319: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number
320: );

Line 317: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date

313: ,p_item_id_query_o => ame_itu_shd.g_old_rec.item_id_query
314: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
315: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
316: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
317: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
318: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
319: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number
320: );
321: --

Line 318: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date

314: ,p_item_class_order_number_o => ame_itu_shd.g_old_rec.item_class_order_number
315: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
316: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
317: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
318: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
319: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number
320: );
321: --
322: exception

Line 319: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number

315: ,p_item_class_par_mode_o => ame_itu_shd.g_old_rec.item_class_par_mode
316: ,p_item_class_sublist_mode_o => ame_itu_shd.g_old_rec.item_class_sublist_mode
317: ,p_start_date_o => ame_itu_shd.g_old_rec.start_date
318: ,p_end_date_o => ame_itu_shd.g_old_rec.end_date
319: ,p_object_version_number_o => ame_itu_shd.g_old_rec.object_version_number
320: );
321: --
322: exception
323: --

Line 341: ,p_rec in out nocopy ame_itu_shd.g_rec_type

337: -- ----------------------------------------------------------------------------
338: Procedure del
339: (p_effective_date in date
340: ,p_datetrack_mode in varchar2
341: ,p_rec in out nocopy ame_itu_shd.g_rec_type
342: ) is
343: --
344: l_proc varchar2(72) := g_package||'del';
345: l_validation_start_date date;

Line 357: ame_itu_shd.lck

353: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
354: --
355: -- We must lock the row which we need to delete.
356: --
357: ame_itu_shd.lck
358: (p_effective_date => p_effective_date
359: ,p_datetrack_mode => p_datetrack_mode
360: ,p_item_class_id => p_rec.item_class_id
361: ,p_application_id => p_rec.application_id

Line 428: l_rec ame_itu_shd.g_rec_type;

424: ,p_start_date out nocopy date
425: ,p_end_date out nocopy date
426: ) is
427: --
428: l_rec ame_itu_shd.g_rec_type;
429: l_proc varchar2(72) := g_package||'del';
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);