[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_liv_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_link_input_values_f t
92: where t.link_input_value_id = p_rec.link_input_value_id
93: and t.effective_start_date =
94: pay_liv_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_link_input_values_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_liv_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: pay_link_input_values_f
155: --
156: insert into pay_link_input_values_f
189: ,l_last_updated_by
190: ,l_last_update_login
191: );
192: --
193: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
194: hr_utility.set_location(' Leaving:'||l_proc, 15);
195: --
196: Exception
197: When hr_api.check_integrity_violated Then
195: --
196: Exception
197: When hr_api.check_integrity_violated Then
198: -- A check constraint has been violated
199: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
200: pay_liv_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
196: Exception
197: When hr_api.check_integrity_violated Then
198: -- A check constraint has been violated
199: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
200: pay_liv_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
200: pay_liv_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
205: pay_liv_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
205: pay_liv_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
209: Raise;
204: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
205: pay_liv_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
209: Raise;
210: End dt_insert_dml;
211: --
212: -- ----------------------------------------------------------------------------
212: -- ----------------------------------------------------------------------------
213: -- |------------------------------< insert_dml >------------------------------|
214: -- ----------------------------------------------------------------------------
215: Procedure insert_dml
216: (p_rec in out nocopy pay_liv_shd.g_rec_type
217: ,p_effective_date in date
218: ,p_datetrack_mode in varchar2
219: ,p_validation_start_date in date
220: ,p_validation_end_date in date
275: --
276: -- {End Of Comments}
277: -- ----------------------------------------------------------------------------
278: Procedure pre_insert
279: (p_rec in out nocopy pay_liv_shd.g_rec_type
280: ,p_effective_date in date
281: ,p_datetrack_mode in varchar2
282: ,p_validation_start_date in date
283: ,p_validation_end_date in date
367: --
368: -- {End Of Comments}
369: -- ----------------------------------------------------------------------------
370: Procedure post_insert
371: (p_rec in pay_liv_shd.g_rec_type
372: ,p_effective_date in date
373: ,p_datetrack_mode in varchar2
374: ,p_validation_start_date in date
375: ,p_validation_end_date in date
463: -- ----------------------------------------------------------------------------
464: Procedure ins_lck
465: (p_effective_date in date
466: ,p_datetrack_mode in varchar2
467: ,p_rec in pay_liv_shd.g_rec_type
468: ,p_validation_start_date out nocopy date
469: ,p_validation_end_date out nocopy date
470: ) is
471: --
509: -- |---------------------------------< ins >----------------------------------|
510: -- ----------------------------------------------------------------------------
511: Procedure ins
512: (p_effective_date in date
513: ,p_rec in out nocopy pay_liv_shd.g_rec_type
514: ) is
515: --
516: l_proc varchar2(72) := g_package||'ins';
517: l_datetrack_mode varchar2(30) := hr_api.g_insert;
598: ,p_effective_start_date out nocopy date
599: ,p_effective_end_date out nocopy date
600: ) is
601: --
602: l_rec pay_liv_shd.g_rec_type;
603: l_proc varchar2(72) := g_package||'ins';
604: --
605: Begin
606: hr_utility.set_location('Entering:'||l_proc, 5);
608: -- Call conversion function to turn arguments into the
609: -- p_rec structure.
610: --
611: l_rec :=
612: pay_liv_shd.convert_args
613: (null
614: ,null
615: ,null
616: ,p_element_link_id