DBA Data[Home] [Help]

APPS.AME_APU_UPD dependencies on AME_APU_SHD

Line 58: (p_rec in out nocopy ame_apu_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_apu_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_apu_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_apu_shd.get_object_version_number
78: (p_approver_type_id => p_rec.approver_type_id
79: ,p_action_type_id => p_rec.action_type_id
80: );
81: --

Line 110: ame_apu_shd.constraint_error

106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: ame_apu_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_apu_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_apu_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_apu_shd.g_rec_type

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

217: --
218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: Procedure dt_pre_update
221: (p_rec in out nocopy ame_apu_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_apu_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_apu_shd.upd_end_date
238: (p_effective_date => p_effective_date
239: ,p_approver_type_id => p_rec.approver_type_id
240: ,p_action_type_id => p_rec.action_type_id
241: ,p_new_end_date => p_validation_start_date

Line 307: (p_rec in out nocopy ame_apu_shd.g_rec_type

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

Line 365: (p_rec in ame_apu_shd.g_rec_type

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

Line 398: => ame_apu_shd.g_old_rec.start_date

394: => p_rec.end_date
395: ,p_object_version_number
396: => p_rec.object_version_number
397: ,p_start_date_o
398: => ame_apu_shd.g_old_rec.start_date
399: ,p_end_date_o
400: => ame_apu_shd.g_old_rec.end_date
401: ,p_object_version_number_o
402: => ame_apu_shd.g_old_rec.object_version_number

Line 400: => ame_apu_shd.g_old_rec.end_date

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

Line 402: => ame_apu_shd.g_old_rec.object_version_number

398: => ame_apu_shd.g_old_rec.start_date
399: ,p_end_date_o
400: => ame_apu_shd.g_old_rec.end_date
401: ,p_object_version_number_o
402: => ame_apu_shd.g_old_rec.object_version_number
403: );
404: --
405: exception
406: --

Line 462: (p_rec in out nocopy ame_apu_shd.g_rec_type

458: --
459: -- {End Of Comments}
460: -- ----------------------------------------------------------------------------
461: Procedure convert_defs
462: (p_rec in out nocopy ame_apu_shd.g_rec_type
463: ) is
464: --
465: Begin
466: null;

Line 482: ,p_rec in out nocopy ame_apu_shd.g_rec_type

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

Line 498: ame_apu_shd.lck

494: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
495: --
496: -- We must lock the row which we need to update.
497: --
498: ame_apu_shd.lck
499: (p_effective_date => p_effective_date
500: ,p_datetrack_mode => p_datetrack_mode
501: ,p_approver_type_id => p_rec.approver_type_id
502: ,p_action_type_id => p_rec.action_type_id

Line 574: l_rec ame_apu_shd.g_rec_type;

570: ,p_start_date out nocopy date
571: ,p_end_date out nocopy date
572: ) is
573: --
574: l_rec ame_apu_shd.g_rec_type;
575: l_proc varchar2(72) := g_package||'upd';
576: --
577: Begin
578: hr_utility.set_location('Entering:'||l_proc, 5);

Line 584: ame_apu_shd.convert_args

580: -- Call conversion function to turn arguments into the
581: -- l_rec structure.
582: --
583: l_rec :=
584: ame_apu_shd.convert_args
585: (p_approver_type_id
586: ,p_action_type_id
587: ,p_start_date
588: ,p_end_date