DBA Data[Home] [Help]

APPS.AME_CNU_UPD dependencies on AME_CNU_SHD

Line 58: (p_rec in out nocopy ame_cnu_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ame_cnu_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_cnu_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_cnu_shd.get_object_version_number
78: (p_condition_id => p_rec.condition_id
79: ,p_rule_id => p_rec.rule_id
80: );
81: --

Line 111: ame_cnu_shd.constraint_error

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

Line 116: ame_cnu_shd.constraint_error

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

Line 155: (p_rec in out nocopy ame_cnu_shd.g_rec_type

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure update_dml
155: (p_rec in out nocopy ame_cnu_shd.g_rec_type
156: ,p_effective_date in date
157: ,p_datetrack_mode in varchar2
158: ,p_validation_start_date in date
159: ,p_validation_end_date in date

Line 222: (p_rec in out nocopy ame_cnu_shd.g_rec_type

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

Line 238: ame_cnu_shd.upd_end_date

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

Line 306: (p_rec in out nocopy ame_cnu_shd.g_rec_type

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

Line 364: (p_rec in ame_cnu_shd.g_rec_type

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

Line 399: => ame_cnu_shd.g_old_rec.start_date

395: => p_rec.security_group_id
396: ,p_object_version_number
397: => p_rec.object_version_number
398: ,p_start_date_o
399: => ame_cnu_shd.g_old_rec.start_date
400: ,p_end_date_o
401: => ame_cnu_shd.g_old_rec.end_date
402: ,p_security_group_id_o
403: => ame_cnu_shd.g_old_rec.security_group_id

Line 401: => ame_cnu_shd.g_old_rec.end_date

397: => p_rec.object_version_number
398: ,p_start_date_o
399: => ame_cnu_shd.g_old_rec.start_date
400: ,p_end_date_o
401: => ame_cnu_shd.g_old_rec.end_date
402: ,p_security_group_id_o
403: => ame_cnu_shd.g_old_rec.security_group_id
404: ,p_object_version_number_o
405: => ame_cnu_shd.g_old_rec.object_version_number

Line 403: => ame_cnu_shd.g_old_rec.security_group_id

399: => ame_cnu_shd.g_old_rec.start_date
400: ,p_end_date_o
401: => ame_cnu_shd.g_old_rec.end_date
402: ,p_security_group_id_o
403: => ame_cnu_shd.g_old_rec.security_group_id
404: ,p_object_version_number_o
405: => ame_cnu_shd.g_old_rec.object_version_number
406: );
407: --

Line 405: => ame_cnu_shd.g_old_rec.object_version_number

401: => ame_cnu_shd.g_old_rec.end_date
402: ,p_security_group_id_o
403: => ame_cnu_shd.g_old_rec.security_group_id
404: ,p_object_version_number_o
405: => ame_cnu_shd.g_old_rec.object_version_number
406: );
407: --
408: exception
409: --

Line 465: (p_rec in out nocopy ame_cnu_shd.g_rec_type

461: --
462: -- {End Of Comments}
463: -- ----------------------------------------------------------------------------
464: Procedure convert_defs
465: (p_rec in out nocopy ame_cnu_shd.g_rec_type
466: ) is
467: --
468: Begin
469: --

Line 477: ame_cnu_shd.g_old_rec.security_group_id;

473: -- is being used then we must set to the 'current' argument value.
474: --
475: If (p_rec.security_group_id = hr_api.g_number) then
476: p_rec.security_group_id :=
477: ame_cnu_shd.g_old_rec.security_group_id;
478: End If;
479: If (p_rec.start_date = hr_api.g_date) then
480: p_rec.start_date := ame_cnu_shd.g_old_rec.start_date;
481: End If;

Line 480: p_rec.start_date := ame_cnu_shd.g_old_rec.start_date;

476: p_rec.security_group_id :=
477: ame_cnu_shd.g_old_rec.security_group_id;
478: End If;
479: If (p_rec.start_date = hr_api.g_date) then
480: p_rec.start_date := ame_cnu_shd.g_old_rec.start_date;
481: End If;
482: If (p_rec.end_date = hr_api.g_date) then
483: p_rec.end_date := ame_cnu_shd.g_old_rec.end_date;
484: End If;

Line 483: p_rec.end_date := ame_cnu_shd.g_old_rec.end_date;

479: If (p_rec.start_date = hr_api.g_date) then
480: p_rec.start_date := ame_cnu_shd.g_old_rec.start_date;
481: End If;
482: If (p_rec.end_date = hr_api.g_date) then
483: p_rec.end_date := ame_cnu_shd.g_old_rec.end_date;
484: End If;
485: --
486: End convert_defs;
487: --

Line 494: ,p_rec in out nocopy ame_cnu_shd.g_rec_type

490: -- ----------------------------------------------------------------------------
491: Procedure upd
492: (p_effective_date in date
493: ,p_datetrack_mode in varchar2
494: ,p_rec in out nocopy ame_cnu_shd.g_rec_type
495: ) is
496: --
497: l_proc varchar2(72) := g_package||'upd';
498: l_validation_start_date date;

Line 517: ame_cnu_shd.lck

513: end if;
514: --
515: -- We must lock the row which we need to update.
516: --
517: ame_cnu_shd.lck
518: (p_effective_date => p_effective_date
519: ,p_datetrack_mode => p_datetrack_mode
520: ,p_condition_id => p_rec.condition_id
521: ,p_rule_id => p_rec.rule_id

Line 611: l_rec ame_cnu_shd.g_rec_type;

607: ,p_start_date in out nocopy date
608: ,p_end_date in out nocopy date
609: ) is
610: --
611: l_rec ame_cnu_shd.g_rec_type;
612: l_proc varchar2(72) := g_package||'upd';
613: --
614: Begin
615: hr_utility.set_location('Entering:'||l_proc, 5);

Line 621: ame_cnu_shd.convert_args

617: -- Call conversion function to turn arguments into the
618: -- l_rec structure.
619: --
620: l_rec :=
621: ame_cnu_shd.convert_args
622: (p_rule_id
623: ,p_condition_id
624: ,p_start_date
625: ,p_end_date