APPS.AME_RLU_DEL dependencies on AME_RLU_SHD

Line 54: (p_rec in out nocopy ame_rlu_shd.g_rec_type

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

95: -- ----------------------------------------------------------------------------
96: -- |------------------------------< delete_dml >------------------------------|
97: -- ----------------------------------------------------------------------------
98: Procedure delete_dml
99: (p_rec in out nocopy ame_rlu_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_rlu_shd.g_rec_type

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ame_rlu_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_rlu_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_rlu_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_rlu_shd.upd_end_date

177: End If;
178: --
179: -- Update the current effective end date record
180: --
181: ame_rlu_shd.upd_end_date
182: (p_effective_date => p_effective_date
183: ,p_rule_id => p_rec.rule_id
184: ,p_item_id => p_rec.item_id
185: ,p_old_start_date => p_rec.old_start_date

Line 230: (p_rec in out nocopy ame_rlu_shd.g_rec_type

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

Line 290: (p_rec in ame_rlu_shd.g_rec_type

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

Line 321: => ame_rlu_shd.g_old_rec.usage_type

317: => p_rec.start_date
318: ,p_end_date
319: => p_rec.end_date
320: ,p_usage_type_o
321: => ame_rlu_shd.g_old_rec.usage_type
322: ,p_start_date_o
323: => ame_rlu_shd.g_old_rec.start_date
324: ,p_end_date_o
325: => ame_rlu_shd.g_old_rec.end_date

Line 323: => ame_rlu_shd.g_old_rec.start_date

319: => p_rec.end_date
320: ,p_usage_type_o
321: => ame_rlu_shd.g_old_rec.usage_type
322: ,p_start_date_o
323: => ame_rlu_shd.g_old_rec.start_date
324: ,p_end_date_o
325: => ame_rlu_shd.g_old_rec.end_date
326: ,p_security_group_id_o
327: => ame_rlu_shd.g_old_rec.security_group_id

Line 325: => ame_rlu_shd.g_old_rec.end_date

321: => ame_rlu_shd.g_old_rec.usage_type
322: ,p_start_date_o
323: => ame_rlu_shd.g_old_rec.start_date
324: ,p_end_date_o
325: => ame_rlu_shd.g_old_rec.end_date
326: ,p_security_group_id_o
327: => ame_rlu_shd.g_old_rec.security_group_id
328: ,p_priority_o
329: => ame_rlu_shd.g_old_rec.priority

Line 327: => ame_rlu_shd.g_old_rec.security_group_id

323: => ame_rlu_shd.g_old_rec.start_date
324: ,p_end_date_o
325: => ame_rlu_shd.g_old_rec.end_date
326: ,p_security_group_id_o
327: => ame_rlu_shd.g_old_rec.security_group_id
328: ,p_priority_o
329: => ame_rlu_shd.g_old_rec.priority
330: ,p_approver_category_o
331: => ame_rlu_shd.g_old_rec.approver_category

Line 329: => ame_rlu_shd.g_old_rec.priority

325: => ame_rlu_shd.g_old_rec.end_date
326: ,p_security_group_id_o
327: => ame_rlu_shd.g_old_rec.security_group_id
328: ,p_priority_o
329: => ame_rlu_shd.g_old_rec.priority
330: ,p_approver_category_o
331: => ame_rlu_shd.g_old_rec.approver_category
332: ,p_object_version_number_o
333: => ame_rlu_shd.g_old_rec.object_version_number

Line 331: => ame_rlu_shd.g_old_rec.approver_category

327: => ame_rlu_shd.g_old_rec.security_group_id
328: ,p_priority_o
329: => ame_rlu_shd.g_old_rec.priority
330: ,p_approver_category_o
331: => ame_rlu_shd.g_old_rec.approver_category
332: ,p_object_version_number_o
333: => ame_rlu_shd.g_old_rec.object_version_number
334: );
335: --

Line 333: => ame_rlu_shd.g_old_rec.object_version_number

329: => ame_rlu_shd.g_old_rec.priority
330: ,p_approver_category_o
331: => ame_rlu_shd.g_old_rec.approver_category
332: ,p_object_version_number_o
333: => ame_rlu_shd.g_old_rec.object_version_number
334: );
335: --
336: exception
337: --

Line 355: ,p_rec in out nocopy ame_rlu_shd.g_rec_type

351: -- ----------------------------------------------------------------------------
352: Procedure del
353: (p_effective_date in date
354: ,p_datetrack_mode in varchar2
355: ,p_rec in out nocopy ame_rlu_shd.g_rec_type
356: ) is
357: --
358: l_proc varchar2(72) := g_package||'del';
359: l_validation_start_date date;

Line 371: ame_rlu_shd.lck

367: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
368: --
369: -- We must lock the row which we need to delete.
370: --
371: ame_rlu_shd.lck
372: (p_effective_date => p_effective_date
373: ,p_datetrack_mode => p_datetrack_mode
374: ,p_rule_id => p_rec.rule_id
375: ,p_item_id => p_rec.item_id

Line 443: l_rec ame_rlu_shd.g_rec_type;

439: ,p_start_date in out nocopy date
440: ,p_end_date in out nocopy date
441: ) is
442: --
443: l_rec ame_rlu_shd.g_rec_type;
444: l_proc varchar2(72) := g_package||'del';
445: --
446: Begin
447: hr_utility.set_location('Entering:'||l_proc, 5);