[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_etu_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 pay_element_type_usages_f t
70: where t.element_type_usage_id = p_rec.element_type_usage_id
71: and t.effective_start_date =
72: pay_etu_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 pay_element_type_usages_f.created_by%TYPE;
172: Exception
173: When hr_api.check_integrity_violated Then
174: -- A check constraint has been violated
175: --
176: pay_etu_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: --
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: --
181: pay_etu_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When Others Then
184: --
185: Raise;
241: -- ----------------------------------------------------------------------------
242: -- |------------------------------< insert_dml >------------------------------|
243: -- ----------------------------------------------------------------------------
244: Procedure insert_dml
245: (p_rec in out nocopy pay_etu_shd.g_rec_type
246: ,p_effective_date in date
247: ,p_datetrack_mode in varchar2
248: ,p_validation_start_date in date
249: ,p_validation_end_date in date
304: --
305: -- {End Of Comments}
306: -- ----------------------------------------------------------------------------
307: Procedure pre_insert
308: (p_rec in out nocopy pay_etu_shd.g_rec_type
309: ,p_effective_date in date
310: ,p_datetrack_mode in varchar2
311: ,p_validation_start_date in date
312: ,p_validation_end_date in date
362: --
363: -- {End Of Comments}
364: -- ----------------------------------------------------------------------------
365: Procedure post_insert
366: (p_rec in pay_etu_shd.g_rec_type
367: ,p_effective_date in date
368: ,p_datetrack_mode in varchar2
369: ,p_validation_start_date in date
370: ,p_validation_end_date in date
460: -- ----------------------------------------------------------------------------
461: Procedure ins_lck
462: (p_effective_date in date
463: ,p_datetrack_mode in varchar2
464: ,p_rec in pay_etu_shd.g_rec_type
465: ,p_validation_start_date out nocopy date
466: ,p_validation_end_date out nocopy date
467: ) is
468: --
506: -- |---------------------------------< ins >----------------------------------|
507: -- ----------------------------------------------------------------------------
508: Procedure ins
509: (p_effective_date in date
510: ,p_rec in out nocopy pay_etu_shd.g_rec_type
511: ) is
512: --
513: l_proc varchar2(72) := g_package||'ins';
514: l_datetrack_mode varchar2(30) := hr_api.g_insert;
587: ,p_effective_start_date out nocopy date
588: ,p_effective_end_date out nocopy date
589: ) is
590: --
591: l_rec pay_etu_shd.g_rec_type;
592: l_proc varchar2(72) := g_package||'ins';
593: --
594: Begin
595: hr_utility.set_location('Entering:'||l_proc, 5);
597: -- Call conversion function to turn arguments into the
598: -- p_rec structure.
599: --
600: l_rec :=
601: pay_etu_shd.convert_args
602: (p_run_type_id
603: ,p_element_type_id
604: ,p_inclusion_flag
605: ,null