[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_ele_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_entries_f t
70: where t.element_entry_id = p_rec.element_entry_id
71: and t.effective_start_date =
72: pay_ele_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_entries_f.created_by%TYPE;
126: l_last_updated_by := fnd_global.user_id;
127: l_last_update_login := fnd_global.login_id;
128: End If;
129: --
130: pay_ele_shd.g_api_dml := true; -- Set the api dml status
131: --
132: -- Insert the row into: pay_element_entries_f
133: --
134: insert into pay_element_entries_f
233: ,l_last_updated_by
234: ,l_last_update_login
235: );
236: --
237: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
238: hr_utility.set_location(' Leaving:'||l_proc, 15);
239: --
240: Exception
241: When hr_api.check_integrity_violated Then
239: --
240: Exception
241: When hr_api.check_integrity_violated Then
242: -- A check constraint has been violated
243: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
244: pay_ele_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.unique_integrity_violated Then
247: -- Unique integrity has been violated
240: Exception
241: When hr_api.check_integrity_violated Then
242: -- A check constraint has been violated
243: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
244: pay_ele_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.unique_integrity_violated Then
247: -- Unique integrity has been violated
248: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
244: pay_ele_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.unique_integrity_violated Then
247: -- Unique integrity has been violated
248: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
249: pay_ele_shd.constraint_error
250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
251: When Others Then
252: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.unique_integrity_violated Then
247: -- Unique integrity has been violated
248: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
249: pay_ele_shd.constraint_error
250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
251: When Others Then
252: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
253: Raise;
248: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
249: pay_ele_shd.constraint_error
250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
251: When Others Then
252: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
253: Raise;
254: End dt_insert_dml;
255: --
256: -- ----------------------------------------------------------------------------
256: -- ----------------------------------------------------------------------------
257: -- |------------------------------< insert_dml >------------------------------|
258: -- ----------------------------------------------------------------------------
259: Procedure insert_dml
260: (p_rec in out nocopy pay_ele_shd.g_rec_type
261: ,p_effective_date in date
262: ,p_datetrack_mode in varchar2
263: ,p_validation_start_date in date
264: ,p_validation_end_date in date
319: --
320: -- {End Of Comments}
321: -- ----------------------------------------------------------------------------
322: Procedure pre_insert
323: (p_rec in out nocopy pay_ele_shd.g_rec_type
324: ,p_effective_date in date
325: ,p_datetrack_mode in varchar2
326: ,p_validation_start_date in date
327: ,p_validation_end_date in date
386: --
387: -- {End Of Comments}
388: -- ----------------------------------------------------------------------------
389: Procedure post_insert
390: (p_rec in pay_ele_shd.g_rec_type
391: ,p_effective_date in date
392: ,p_datetrack_mode in varchar2
393: ,p_validation_start_date in date
394: ,p_validation_end_date in date
585: -- ----------------------------------------------------------------------------
586: Procedure ins_lck
587: (p_effective_date in date
588: ,p_datetrack_mode in varchar2
589: ,p_rec in pay_ele_shd.g_rec_type
590: ,p_validation_start_date out nocopy date
591: ,p_validation_end_date out nocopy date
592: ) is
593: --
631: -- |---------------------------------< ins >----------------------------------|
632: -- ----------------------------------------------------------------------------
633: Procedure ins
634: (p_effective_date in date
635: ,p_rec in out nocopy pay_ele_shd.g_rec_type
636: ) is
637: --
638: l_proc varchar2(72) := g_package||'ins';
639: l_datetrack_mode varchar2(30) := hr_api.g_insert;
745: ,p_effective_end_date out nocopy date
746: ,p_comment_id out nocopy number
747: ) is
748: --
749: l_rec pay_ele_shd.g_rec_type;
750: l_proc varchar2(72) := g_package||'ins';
751: l_ele_type_id pay_element_types_f.element_type_id%type;
752: --
753: Begin
762: -- Call conversion function to turn arguments into the
763: -- p_rec structure.
764: --
765: l_rec :=
766: pay_ele_shd.convert_args
767: (null
768: ,null
769: ,null
770: ,p_cost_allocation_keyflex_id