APPS.AME_CON_DEL dependencies on AME_CON_SHD

Line 54: (p_rec in out nocopy ame_con_shd.g_rec_type

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

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy ame_con_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_con_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy ame_con_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_con_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_con_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_con_shd.upd_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ame_con_shd.upd_end_date
180: (p_effective_date => p_effective_date
181: ,p_condition_id => p_rec.condition_id
182: ,p_new_end_date => p_rec.end_date
183: ,p_object_version_number => p_rec.object_version_number

Line 226: (p_rec in out nocopy ame_con_shd.g_rec_type

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

Line 286: (p_rec in ame_con_shd.g_rec_type

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

Line 315: => ame_con_shd.g_old_rec.condition_type

311: => p_rec.start_date
312: ,p_end_date
313: => p_rec.end_date
314: ,p_condition_type_o
315: => ame_con_shd.g_old_rec.condition_type
316: ,p_attribute_id_o
317: => ame_con_shd.g_old_rec.attribute_id
318: ,p_parameter_one_o
319: => ame_con_shd.g_old_rec.parameter_one

Line 317: => ame_con_shd.g_old_rec.attribute_id

313: => p_rec.end_date
314: ,p_condition_type_o
315: => ame_con_shd.g_old_rec.condition_type
316: ,p_attribute_id_o
317: => ame_con_shd.g_old_rec.attribute_id
318: ,p_parameter_one_o
319: => ame_con_shd.g_old_rec.parameter_one
320: ,p_parameter_two_o
321: => ame_con_shd.g_old_rec.parameter_two

Line 319: => ame_con_shd.g_old_rec.parameter_one

315: => ame_con_shd.g_old_rec.condition_type
316: ,p_attribute_id_o
317: => ame_con_shd.g_old_rec.attribute_id
318: ,p_parameter_one_o
319: => ame_con_shd.g_old_rec.parameter_one
320: ,p_parameter_two_o
321: => ame_con_shd.g_old_rec.parameter_two
322: ,p_parameter_three_o
323: => ame_con_shd.g_old_rec.parameter_three

Line 321: => ame_con_shd.g_old_rec.parameter_two

317: => ame_con_shd.g_old_rec.attribute_id
318: ,p_parameter_one_o
319: => ame_con_shd.g_old_rec.parameter_one
320: ,p_parameter_two_o
321: => ame_con_shd.g_old_rec.parameter_two
322: ,p_parameter_three_o
323: => ame_con_shd.g_old_rec.parameter_three
324: ,p_include_lower_limit_o
325: => ame_con_shd.g_old_rec.include_lower_limit

Line 323: => ame_con_shd.g_old_rec.parameter_three

319: => ame_con_shd.g_old_rec.parameter_one
320: ,p_parameter_two_o
321: => ame_con_shd.g_old_rec.parameter_two
322: ,p_parameter_three_o
323: => ame_con_shd.g_old_rec.parameter_three
324: ,p_include_lower_limit_o
325: => ame_con_shd.g_old_rec.include_lower_limit
326: ,p_include_upper_limit_o
327: => ame_con_shd.g_old_rec.include_upper_limit

Line 325: => ame_con_shd.g_old_rec.include_lower_limit

321: => ame_con_shd.g_old_rec.parameter_two
322: ,p_parameter_three_o
323: => ame_con_shd.g_old_rec.parameter_three
324: ,p_include_lower_limit_o
325: => ame_con_shd.g_old_rec.include_lower_limit
326: ,p_include_upper_limit_o
327: => ame_con_shd.g_old_rec.include_upper_limit
328: ,p_start_date_o
329: => ame_con_shd.g_old_rec.start_date

Line 327: => ame_con_shd.g_old_rec.include_upper_limit

323: => ame_con_shd.g_old_rec.parameter_three
324: ,p_include_lower_limit_o
325: => ame_con_shd.g_old_rec.include_lower_limit
326: ,p_include_upper_limit_o
327: => ame_con_shd.g_old_rec.include_upper_limit
328: ,p_start_date_o
329: => ame_con_shd.g_old_rec.start_date
330: ,p_end_date_o
331: => ame_con_shd.g_old_rec.end_date

Line 329: => ame_con_shd.g_old_rec.start_date

325: => ame_con_shd.g_old_rec.include_lower_limit
326: ,p_include_upper_limit_o
327: => ame_con_shd.g_old_rec.include_upper_limit
328: ,p_start_date_o
329: => ame_con_shd.g_old_rec.start_date
330: ,p_end_date_o
331: => ame_con_shd.g_old_rec.end_date
332: ,p_security_group_id_o
333: => ame_con_shd.g_old_rec.security_group_id

Line 331: => ame_con_shd.g_old_rec.end_date

327: => ame_con_shd.g_old_rec.include_upper_limit
328: ,p_start_date_o
329: => ame_con_shd.g_old_rec.start_date
330: ,p_end_date_o
331: => ame_con_shd.g_old_rec.end_date
332: ,p_security_group_id_o
333: => ame_con_shd.g_old_rec.security_group_id
334: ,p_condition_key_o
335: => ame_con_shd.g_old_rec.condition_key

Line 333: => ame_con_shd.g_old_rec.security_group_id

329: => ame_con_shd.g_old_rec.start_date
330: ,p_end_date_o
331: => ame_con_shd.g_old_rec.end_date
332: ,p_security_group_id_o
333: => ame_con_shd.g_old_rec.security_group_id
334: ,p_condition_key_o
335: => ame_con_shd.g_old_rec.condition_key
336: ,p_object_version_number_o
337: => ame_con_shd.g_old_rec.object_version_number

Line 335: => ame_con_shd.g_old_rec.condition_key

331: => ame_con_shd.g_old_rec.end_date
332: ,p_security_group_id_o
333: => ame_con_shd.g_old_rec.security_group_id
334: ,p_condition_key_o
335: => ame_con_shd.g_old_rec.condition_key
336: ,p_object_version_number_o
337: => ame_con_shd.g_old_rec.object_version_number
338: );
339: --

Line 337: => ame_con_shd.g_old_rec.object_version_number

333: => ame_con_shd.g_old_rec.security_group_id
334: ,p_condition_key_o
335: => ame_con_shd.g_old_rec.condition_key
336: ,p_object_version_number_o
337: => ame_con_shd.g_old_rec.object_version_number
338: );
339: --
340: exception
341: --

Line 359: ,p_rec in out nocopy ame_con_shd.g_rec_type

355: -- ----------------------------------------------------------------------------
356: Procedure del
357: (p_effective_date in date
358: ,p_datetrack_mode in varchar2
359: ,p_rec in out nocopy ame_con_shd.g_rec_type
360: ) is
361: --
362: l_proc varchar2(72) := g_package||'del';
363: l_validation_start_date date;

Line 375: ame_con_shd.lck

371: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
372: --
373: -- We must lock the row which we need to delete.
374: --
375: ame_con_shd.lck
376: (p_effective_date => p_effective_date
377: ,p_datetrack_mode => p_datetrack_mode
378: ,p_condition_id => p_rec.condition_id
379: ,p_object_version_number => p_rec.object_version_number

Line 444: l_rec ame_con_shd.g_rec_type;

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