[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy per_abv_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
68: t.creation_date
69: from per_assignment_budget_values_f t
70: where t.assignment_budget_value_id = p_rec.assignment_budget_value_id
71: and t.effective_start_date =
72: per_abv_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by per_assignment_budget_values_f.created_by%TYPE;
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: --
190: per_abv_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: per_abv_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: --
199: Raise;
202: -- ----------------------------------------------------------------------------
203: -- |------------------------------< insert_dml >------------------------------|
204: -- ----------------------------------------------------------------------------
205: Procedure insert_dml
206: (p_rec in out nocopy per_abv_shd.g_rec_type
207: ,p_effective_date in date
208: ,p_datetrack_mode in varchar2
209: ,p_validation_start_date in date
210: ,p_validation_end_date in date
265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure pre_insert
269: (p_rec in out nocopy per_abv_shd.g_rec_type
270: ,p_effective_date in date
271: ,p_datetrack_mode in varchar2
272: ,p_validation_start_date in date
273: ,p_validation_end_date in date
323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure post_insert
327: (p_rec in per_abv_shd.g_rec_type
328: ,p_effective_date in date
329: ,p_datetrack_mode in varchar2
330: ,p_validation_start_date in date
331: ,p_validation_end_date in date
421: -- ----------------------------------------------------------------------------
422: Procedure ins_lck
423: (p_effective_date in date
424: ,p_datetrack_mode in varchar2
425: ,p_rec in per_abv_shd.g_rec_type
426: ,p_validation_start_date out nocopy date
427: ,p_validation_end_date out nocopy date
428: ) is
429: --
464: -- |---------------------------------< ins >----------------------------------|
465: -- ----------------------------------------------------------------------------
466: Procedure ins
467: (p_effective_date in date
468: ,p_rec in out nocopy per_abv_shd.g_rec_type
469: ) is
470: --
471: l_proc varchar2(72) := g_package||'ins';
472: l_datetrack_mode varchar2(30) := hr_api.g_insert;
547: ,p_effective_start_date out nocopy date
548: ,p_effective_end_date out nocopy date
549: ) is
550: --
551: l_rec per_abv_shd.g_rec_type;
552: l_proc varchar2(72) := g_package||'ins';
553: --
554: Begin
555: hr_utility.set_location('Entering:'||l_proc, 5);
557: -- Call conversion function to turn arguments into the
558: -- p_rec structure.
559: --
560: l_rec :=
561: per_abv_shd.convert_args
562: (null
563: ,p_business_group_id
564: ,p_assignment_id
565: ,p_unit