[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_rlu_shd.g_rec_type
84: ,p_effective_date in date
85: ,p_datetrack_mode in varchar2
86: ,p_validation_start_date in date
87: ,p_validation_end_date in date
93: from ame_rule_usages t
94: where t.rule_id = p_rec.rule_id
95: and t.item_id = p_rec.item_id
96: and t.start_date =
97: ame_rlu_shd.g_old_rec.start_date
98: and t.end_date = p_validation_start_date;
99: --
100: Cursor C_Sel2 Is
101: select created_by
132: --
133: -- Get the object version number for the insert
134: --
135: p_rec.object_version_number :=
136: ame_rlu_shd.get_object_version_number
137: (p_rule_id => p_rec.rule_id
138: ,p_item_id => p_rec.item_id
139: ,p_old_start_date => p_rec.old_start_date
140: );
242: Exception
243: When hr_api.check_integrity_violated Then
244: -- A check constraint has been violated
245: --
246: ame_rlu_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: ame_rlu_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When Others Then
254: --
255: Raise;
258: -- ----------------------------------------------------------------------------
259: -- |------------------------------< insert_dml >------------------------------|
260: -- ----------------------------------------------------------------------------
261: Procedure insert_dml
262: (p_rec in out nocopy ame_rlu_shd.g_rec_type
263: ,p_effective_date in date
264: ,p_datetrack_mode in varchar2
265: ,p_validation_start_date in date
266: ,p_validation_end_date in date
321: --
322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure pre_insert
325: (p_rec in out nocopy ame_rlu_shd.g_rec_type
326: ,p_effective_date in date
327: ,p_datetrack_mode in varchar2
328: ,p_validation_start_date in date
329: ,p_validation_end_date in date
411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure post_insert
415: (p_rec in ame_rlu_shd.g_rec_type
416: ,p_effective_date in date
417: ,p_datetrack_mode in varchar2
418: ,p_validation_start_date in date
419: ,p_validation_end_date in date
503: -- ----------------------------------------------------------------------------
504: Procedure ins_lck
505: (p_effective_date in date
506: ,p_datetrack_mode in varchar2
507: ,p_rec in ame_rlu_shd.g_rec_type
508: ,p_validation_start_date out nocopy date
509: ,p_validation_end_date out nocopy date
510: ) is
511: --
558: -- |---------------------------------< ins >----------------------------------|
559: -- ----------------------------------------------------------------------------
560: Procedure ins
561: (p_effective_date in date
562: ,p_rec in out nocopy ame_rlu_shd.g_rec_type
563: ) is
564: --
565: l_proc varchar2(72) := g_package||'ins';
566: l_datetrack_mode varchar2(30) := hr_api.g_insert;
644: ,p_end_date in out nocopy date
645: ,p_object_version_number out nocopy number
646: ) is
647: --
648: l_rec ame_rlu_shd.g_rec_type;
649: l_proc varchar2(72) := g_package||'ins';
650: --
651: Begin
652: hr_utility.set_location('Entering:'||l_proc, 5);
654: -- Call conversion function to turn arguments into the
655: -- p_rec structure.
656: --
657: l_rec :=
658: ame_rlu_shd.convert_args
659: (p_item_id
660: ,p_usage_type
661: ,p_rule_id
662: ,p_start_date