DBA Data[Home] [Help]

APPS.AME_ITC_UPD dependencies on AME_ITC_SHD

Line 58: (p_rec in out nocopy ame_itc_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_itc_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_itc_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_itc_shd.get_object_version_number
78: (p_item_class_id => p_rec.item_class_id
79: );
80: --
81: -- Update the ame_item_classes Row

Line 104: ame_itc_shd.constraint_error

100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: --
104: ame_itc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --

Line 109: ame_itc_shd.constraint_error

105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --
109: ame_itc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;

Line 148: (p_rec in out nocopy ame_itc_shd.g_rec_type

144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure update_dml
148: (p_rec in out nocopy ame_itc_shd.g_rec_type
149: ,p_effective_date in date
150: ,p_datetrack_mode in varchar2
151: ,p_validation_start_date in date
152: ,p_validation_end_date in date

Line 215: (p_rec in out nocopy ame_itc_shd.g_rec_type

211: --
212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure dt_pre_update
215: (p_rec in out nocopy ame_itc_shd.g_rec_type
216: ,p_effective_date in date
217: ,p_datetrack_mode in varchar2
218: ,p_validation_start_date in date
219: ,p_validation_end_date in date

Line 231: ame_itc_shd.upd_effective_end_date

227: If (p_datetrack_mode <> hr_api.g_correction) then
228: --
229: -- Update the current effective end date
230: --
231: ame_itc_shd.upd_effective_end_date
232: (p_effective_date => p_effective_date
233: ,p_item_class_id => p_rec.item_class_id
234: ,p_new_effective_end_date => p_validation_start_date
235: ,p_validation_start_date => p_validation_start_date

Line 300: (p_rec in out nocopy ame_itc_shd.g_rec_type

296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure pre_update
300: (p_rec in out nocopy ame_itc_shd.g_rec_type
301: ,p_effective_date in date
302: ,p_datetrack_mode in varchar2
303: ,p_validation_start_date in date
304: ,p_validation_end_date in date

Line 358: (p_rec in ame_itc_shd.g_rec_type

354: --
355: -- {End Of Comments}
356: -- ----------------------------------------------------------------------------
357: Procedure post_update
358: (p_rec in ame_itc_shd.g_rec_type
359: ,p_effective_date in date
360: ,p_datetrack_mode in varchar2
361: ,p_validation_start_date in date
362: ,p_validation_end_date in date

Line 381: ,p_name_o => ame_itc_shd.g_old_rec.name

377: ,p_name => p_rec.name
378: ,p_start_date => p_rec.start_date
379: ,p_end_date => p_rec.end_date
380: ,p_object_version_number => p_rec.object_version_number
381: ,p_name_o => ame_itc_shd.g_old_rec.name
382: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date
383: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date
384: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number
385: );

Line 382: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date

378: ,p_start_date => p_rec.start_date
379: ,p_end_date => p_rec.end_date
380: ,p_object_version_number => p_rec.object_version_number
381: ,p_name_o => ame_itc_shd.g_old_rec.name
382: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date
383: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date
384: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number
385: );
386: --

Line 383: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date

379: ,p_end_date => p_rec.end_date
380: ,p_object_version_number => p_rec.object_version_number
381: ,p_name_o => ame_itc_shd.g_old_rec.name
382: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date
383: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date
384: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number
385: );
386: --
387: exception

Line 384: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number

380: ,p_object_version_number => p_rec.object_version_number
381: ,p_name_o => ame_itc_shd.g_old_rec.name
382: ,p_start_date_o => ame_itc_shd.g_old_rec.start_date
383: ,p_end_date_o => ame_itc_shd.g_old_rec.end_date
384: ,p_object_version_number_o => ame_itc_shd.g_old_rec.object_version_number
385: );
386: --
387: exception
388: --

Line 444: (p_rec in out nocopy ame_itc_shd.g_rec_type

440: --
441: -- {End Of Comments}
442: -- ----------------------------------------------------------------------------
443: Procedure convert_defs
444: (p_rec in out nocopy ame_itc_shd.g_rec_type
445: ) is
446: --
447: Begin
448: --

Line 456: ame_itc_shd.g_old_rec.name;

452: -- is being used then we must set to the 'current' argument value.
453: --
454: If (p_rec.name = hr_api.g_varchar2) then
455: p_rec.name :=
456: ame_itc_shd.g_old_rec.name;
457: End If;
458: --
459: End convert_defs;
460: --

Line 467: ,p_rec in out nocopy ame_itc_shd.g_rec_type

463: -- ----------------------------------------------------------------------------
464: Procedure upd
465: (p_effective_date in date
466: ,p_datetrack_mode in varchar2
467: ,p_rec in out nocopy ame_itc_shd.g_rec_type
468: ) is
469: --
470: l_proc varchar2(72) := g_package||'upd';
471: l_validation_start_date date;

Line 483: ame_itc_shd.lck

479: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
480: --
481: -- We must lock the row which we need to update.
482: --
483: ame_itc_shd.lck
484: (p_effective_date => p_effective_date
485: ,p_datetrack_mode => p_datetrack_mode
486: ,p_item_class_id => p_rec.item_class_id
487: ,p_object_version_number => p_rec.object_version_number

Line 558: l_rec ame_itc_shd.g_rec_type;

554: ,p_start_date out nocopy date
555: ,p_end_date out nocopy date
556: ) is
557: --
558: l_rec ame_itc_shd.g_rec_type;
559: l_proc varchar2(72) := g_package||'upd';
560: --
561: Begin
562: hr_utility.set_location('Entering:'||l_proc, 5);

Line 568: ame_itc_shd.convert_args

564: -- Call conversion function to turn arguments into the
565: -- l_rec structure.
566: --
567: l_rec :=
568: ame_itc_shd.convert_args
569: (p_item_class_id
570: ,p_name
571: ,null
572: ,null