[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_pel_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date
90: t.creation_date
91: from pay_element_links_f t
92: where t.element_link_id = p_rec.element_link_id
93: and t.effective_start_date =
94: pay_pel_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pay_element_links_f.created_by%TYPE;
148: l_last_updated_by := fnd_global.user_id;
149: l_last_update_login := fnd_global.login_id;
150: End If;
151: --
152: pay_pel_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: pay_element_links_f
155: --
156: insert into pay_element_links_f
263: ,l_last_updated_by
264: ,l_last_update_login
265: );
266: --
267: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
268: hr_utility.set_location(' Leaving:'||l_proc, 15);
269: --
270: Exception
271: When hr_api.check_integrity_violated Then
269: --
270: Exception
271: When hr_api.check_integrity_violated Then
272: -- A check constraint has been violated
273: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
274: pay_pel_shd.constraint_error
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When hr_api.unique_integrity_violated Then
277: -- Unique integrity has been violated
270: Exception
271: When hr_api.check_integrity_violated Then
272: -- A check constraint has been violated
273: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
274: pay_pel_shd.constraint_error
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When hr_api.unique_integrity_violated Then
277: -- Unique integrity has been violated
278: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
274: pay_pel_shd.constraint_error
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When hr_api.unique_integrity_violated Then
277: -- Unique integrity has been violated
278: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
279: pay_pel_shd.constraint_error
280: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
281: When Others Then
282: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When hr_api.unique_integrity_violated Then
277: -- Unique integrity has been violated
278: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
279: pay_pel_shd.constraint_error
280: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
281: When Others Then
282: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
283: Raise;
278: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
279: pay_pel_shd.constraint_error
280: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
281: When Others Then
282: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
283: Raise;
284: End dt_insert_dml;
285: --
286: -- ----------------------------------------------------------------------------
286: -- ----------------------------------------------------------------------------
287: -- |------------------------------< insert_dml >------------------------------|
288: -- ----------------------------------------------------------------------------
289: Procedure insert_dml
290: (p_rec in out nocopy pay_pel_shd.g_rec_type
291: ,p_effective_date in date
292: ,p_datetrack_mode in varchar2
293: ,p_validation_start_date in date
294: ,p_validation_end_date in date
349: --
350: -- {End Of Comments}
351: -- ----------------------------------------------------------------------------
352: Procedure pre_insert
353: (p_rec in out nocopy pay_pel_shd.g_rec_type
354: ,p_effective_date in date
355: ,p_datetrack_mode in varchar2
356: ,p_validation_start_date in date
357: ,p_validation_end_date in date
450: --
451: -- {End Of Comments}
452: -- ----------------------------------------------------------------------------
453: Procedure post_insert
454: (p_rec in pay_pel_shd.g_rec_type
455: ,p_effective_date in date
456: ,p_datetrack_mode in varchar2
457: ,p_validation_start_date in date
458: ,p_validation_end_date in date
622: -- ----------------------------------------------------------------------------
623: Procedure ins_lck
624: (p_effective_date in date
625: ,p_datetrack_mode in varchar2
626: ,p_rec in pay_pel_shd.g_rec_type
627: ,p_validation_start_date out nocopy date
628: ,p_validation_end_date out nocopy date
629: ) is
630: --
668: -- |---------------------------------< ins >----------------------------------|
669: -- ----------------------------------------------------------------------------
670: Procedure ins
671: (p_effective_date in date
672: ,p_rec in out nocopy pay_pel_shd.g_rec_type
673: ) is
674: --
675: l_proc varchar2(72) := g_package||'ins';
676: l_datetrack_mode varchar2(30) := hr_api.g_insert;
845: ,p_effective_end_date out nocopy date
846: ,p_comment_id out nocopy number
847: ) is
848: --
849: l_rec pay_pel_shd.g_rec_type;
850: l_proc varchar2(72) := g_package||'ins';
851: --
852: Begin
853: hr_utility.set_location('Entering:'||l_proc, 5);
855: -- Call conversion function to turn arguments into the
856: -- p_rec structure.
857: --
858: l_rec :=
859: pay_pel_shd.convert_args
860: (null
861: ,null
862: ,null
863: ,p_payroll_id