[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_ivl_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_input_values_f t
92: where t.input_value_id = p_rec.input_value_id
93: and t.effective_start_date =
94: pay_ivl_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_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_ivl_shd.g_api_dml := true; -- Set the api dml status
153: --
154: -- Insert the row into: pay_input_values_f
155: --
156: insert into pay_input_values_f
209: ,l_last_updated_by
210: ,l_last_update_login
211: );
212: --
213: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
214: hr_utility.set_location(' Leaving:'||l_proc, 15);
215: --
216: Exception
217: When hr_api.check_integrity_violated Then
215: --
216: Exception
217: When hr_api.check_integrity_violated Then
218: -- A check constraint has been violated
219: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
220: pay_ivl_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
216: Exception
217: When hr_api.check_integrity_violated Then
218: -- A check constraint has been violated
219: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
220: pay_ivl_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
220: pay_ivl_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
225: pay_ivl_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
225: pay_ivl_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
229: Raise;
224: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
225: pay_ivl_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
229: Raise;
230: End dt_insert_dml;
231: --
232: -- ----------------------------------------------------------------------------
280: -- ----------------------------------------------------------------------------
281: -- |------------------------------< insert_dml >------------------------------|
282: -- ----------------------------------------------------------------------------
283: Procedure insert_dml
284: (p_rec in out nocopy pay_ivl_shd.g_rec_type
285: ,p_effective_date in date
286: ,p_datetrack_mode in varchar2
287: ,p_validation_start_date in date
288: ,p_validation_end_date in date
343: --
344: -- {End Of Comments}
345: -- ----------------------------------------------------------------------------
346: Procedure pre_insert
347: (p_rec in out nocopy pay_ivl_shd.g_rec_type
348: ,p_effective_date in date
349: ,p_datetrack_mode in varchar2
350: ,p_validation_start_date in date
351: ,p_validation_end_date in date
435: --
436: -- {End Of Comments}
437: -- ----------------------------------------------------------------------------
438: Procedure post_insert
439: (p_rec in pay_ivl_shd.g_rec_type
440: ,p_effective_date in date
441: ,p_datetrack_mode in varchar2
442: ,p_validation_start_date in date
443: ,p_validation_end_date in date
557: -- ----------------------------------------------------------------------------
558: Procedure ins_lck
559: (p_effective_date in date
560: ,p_datetrack_mode in varchar2
561: ,p_rec in pay_ivl_shd.g_rec_type
562: ,p_validation_start_date out nocopy date
563: ,p_validation_end_date out nocopy date
564: ) is
565: --
600: -- |---------------------------------< ins >----------------------------------|
601: -- ----------------------------------------------------------------------------
602: Procedure ins
603: (p_effective_date in date
604: ,p_rec in out nocopy pay_ivl_shd.g_rec_type
605: ,p_default_val_warning out nocopy boolean
606: ,p_min_max_warning out nocopy boolean
607: ,p_pay_basis_warning out nocopy boolean
608: ,p_formula_warning out nocopy boolean
728: ,p_assignment_id_warning out nocopy boolean
729: ,p_formula_message out nocopy varchar2
730: ) is
731: --
732: l_rec pay_ivl_shd.g_rec_type;
733: l_proc varchar2(72) := g_package||'ins';
734: l_name pay_input_values_f.name%type;
735: --
736: Begin
748: -- Call conversion function to turn arguments into the
749: -- p_rec structure.
750: --
751: l_rec :=
752: pay_ivl_shd.convert_args
753: (null
754: ,null
755: ,null
756: ,p_element_type_id