DBA Data[Home] [Help]

APPS.AME_ACU_UPD dependencies on AME_ACU_SHD

Line 58: (p_rec in out nocopy ame_acu_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_acu_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 77: ame_acu_shd.get_object_version_number

73: -- Because we are updating a row we must get the next object
74: -- version number.
75: --
76: p_rec.object_version_number :=
77: ame_acu_shd.get_object_version_number
78: (p_action_id => p_rec.action_id
79: ,p_rule_id => p_rec.rule_id
80: );
81: --

Line 110: ame_acu_shd.constraint_error

106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: ame_acu_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.unique_integrity_violated Then
113: -- Unique integrity has been violated
114: --

Line 115: ame_acu_shd.constraint_error

111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.unique_integrity_violated Then
113: -- Unique integrity has been violated
114: --
115: ame_acu_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When Others Then
118: --
119: Raise;

Line 154: (p_rec in out nocopy ame_acu_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure update_dml
154: (p_rec in out nocopy ame_acu_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 221: (p_rec in out nocopy ame_acu_shd.g_rec_type

217: --
218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: Procedure dt_pre_update
221: (p_rec in out nocopy ame_acu_shd.g_rec_type
222: ,p_effective_date in date
223: ,p_datetrack_mode in varchar2
224: ,p_validation_start_date in date
225: ,p_validation_end_date in date

Line 237: ame_acu_shd.upd_end_date

233: If (p_datetrack_mode <> hr_api.g_correction) then
234: --
235: -- Update the current effective end date
236: --
237: ame_acu_shd.upd_end_date
238: (p_effective_date => p_effective_date
239: ,p_action_id => p_rec.action_id
240: ,p_rule_id => p_rec.rule_id
241: ,p_new_end_date => p_validation_start_date

Line 305: (p_rec in out nocopy ame_acu_shd.g_rec_type

301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure pre_update
305: (p_rec in out nocopy ame_acu_shd.g_rec_type
306: ,p_effective_date in date
307: ,p_datetrack_mode in varchar2
308: ,p_validation_start_date in date
309: ,p_validation_end_date in date

Line 363: (p_rec in ame_acu_shd.g_rec_type

359: --
360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure post_update
363: (p_rec in ame_acu_shd.g_rec_type
364: ,p_effective_date in date
365: ,p_datetrack_mode in varchar2
366: ,p_validation_start_date in date
367: ,p_validation_end_date in date

Line 396: => ame_acu_shd.g_old_rec.start_date

392: => p_rec.end_date
393: ,p_object_version_number
394: => p_rec.object_version_number
395: ,p_start_date_o
396: => ame_acu_shd.g_old_rec.start_date
397: ,p_end_date_o
398: => ame_acu_shd.g_old_rec.end_date
399: ,p_object_version_number_o
400: => ame_acu_shd.g_old_rec.object_version_number

Line 398: => ame_acu_shd.g_old_rec.end_date

394: => p_rec.object_version_number
395: ,p_start_date_o
396: => ame_acu_shd.g_old_rec.start_date
397: ,p_end_date_o
398: => ame_acu_shd.g_old_rec.end_date
399: ,p_object_version_number_o
400: => ame_acu_shd.g_old_rec.object_version_number
401: );
402: --

Line 400: => ame_acu_shd.g_old_rec.object_version_number

396: => ame_acu_shd.g_old_rec.start_date
397: ,p_end_date_o
398: => ame_acu_shd.g_old_rec.end_date
399: ,p_object_version_number_o
400: => ame_acu_shd.g_old_rec.object_version_number
401: );
402: --
403: exception
404: --

Line 460: (p_rec in out nocopy ame_acu_shd.g_rec_type

456: --
457: -- {End Of Comments}
458: -- ----------------------------------------------------------------------------
459: Procedure convert_defs
460: (p_rec in out nocopy ame_acu_shd.g_rec_type
461: ) is
462: --
463: Begin
464: --

Line 466: p_rec.start_date := ame_acu_shd.g_old_rec.start_date;

462: --
463: Begin
464: --
465: If (p_rec.start_date = hr_api.g_date) then
466: p_rec.start_date := ame_acu_shd.g_old_rec.start_date;
467: End If;
468: If (p_rec.end_date = hr_api.g_date) then
469: p_rec.end_date := ame_acu_shd.g_old_rec.end_date;
470: End If;

Line 469: p_rec.end_date := ame_acu_shd.g_old_rec.end_date;

465: If (p_rec.start_date = hr_api.g_date) then
466: p_rec.start_date := ame_acu_shd.g_old_rec.start_date;
467: End If;
468: If (p_rec.end_date = hr_api.g_date) then
469: p_rec.end_date := ame_acu_shd.g_old_rec.end_date;
470: End If;
471: --
472: End convert_defs;
473: --

Line 480: ,p_rec in out nocopy ame_acu_shd.g_rec_type

476: -- ----------------------------------------------------------------------------
477: Procedure upd
478: (p_effective_date in date
479: ,p_datetrack_mode in varchar2
480: ,p_rec in out nocopy ame_acu_shd.g_rec_type
481: ) is
482: --
483: l_proc varchar2(72) := g_package||'upd';
484: l_validation_start_date date;

Line 505: ame_acu_shd.lck

501: end if;
502: --
503: -- We must lock the row which we need to update.
504: --
505: ame_acu_shd.lck
506: (p_effective_date => p_effective_date
507: ,p_datetrack_mode => p_datetrack_mode
508: ,p_action_id => p_rec.action_id
509: ,p_rule_id => p_rec.rule_id

Line 598: l_rec ame_acu_shd.g_rec_type;

594: ,p_start_date in out nocopy date
595: ,p_end_date in out nocopy date
596: ) is
597: --
598: l_rec ame_acu_shd.g_rec_type;
599: l_proc varchar2(72) := g_package||'upd';
600: --
601: Begin
602: hr_utility.set_location('Entering:'||l_proc, 5);

Line 608: ame_acu_shd.convert_args

604: -- Call conversion function to turn arguments into the
605: -- l_rec structure.
606: --
607: l_rec :=
608: ame_acu_shd.convert_args
609: (p_rule_id
610: ,p_action_id
611: ,p_start_date
612: ,p_end_date