[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_rfm_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_report_format_mappings_f t
92: where t.report_format_mapping_id = p_rec.report_format_mapping_id
93: and t.effective_start_date =
94: pay_rfm_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_report_format_mappings_f.created_by%TYPE;
150: Else
151: p_rec.object_version_number := 1; -- Initialise the object version
152: End If;
153: --
154: pay_rfm_shd.g_api_dml := true; -- Set the api dml status
155: --
156: -- Insert the row into: pay_report_format_mappings_f
157: --
158: insert into pay_report_format_mappings_f
209: ,l_last_updated_by
210: ,l_last_update_login
211: );
212: --
213: pay_rfm_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_rfm_shd.g_api_dml := false; -- Unset the api dml status
220: pay_rfm_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_rfm_shd.g_api_dml := false; -- Unset the api dml status
220: pay_rfm_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_rfm_shd.g_api_dml := false; -- Unset the api dml status
220: pay_rfm_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_rfm_shd.g_api_dml := false; -- Unset the api dml status
225: pay_rfm_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: pay_rfm_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_rfm_shd.g_api_dml := false; -- Unset the api dml status
225: pay_rfm_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
229: Raise;
224: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
225: pay_rfm_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: pay_rfm_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_rfm_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_rfm_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
437: --
438: -- {End Of Comments}
439: -- ----------------------------------------------------------------------------
440: Procedure post_insert
441: (p_rec in pay_rfm_shd.g_rec_type
442: ,p_effective_date in date
443: ,p_datetrack_mode in varchar2
444: ,p_validation_start_date in date
445: ,p_validation_end_date in date
492: -- ----------------------------------------------------------------------------
493: Procedure ins_lck
494: (p_effective_date in date
495: ,p_datetrack_mode in varchar2
496: ,p_rec in pay_rfm_shd.g_rec_type
497: ,p_validation_start_date out nocopy date
498: ,p_validation_end_date out nocopy date
499: ) is
500: --
532: -- |---------------------------------< ins >----------------------------------|
533: -- ----------------------------------------------------------------------------
534: Procedure ins
535: (p_effective_date in date
536: ,p_rec in out nocopy pay_rfm_shd.g_rec_type
537: ) is
538: --
539: l_proc varchar2(72) := g_package||'ins';
540: l_datetrack_mode varchar2(30) := hr_api.g_insert;
629: ,p_effective_start_date out nocopy date
630: ,p_effective_end_date out nocopy date
631: ) is
632: --
633: l_rec pay_rfm_shd.g_rec_type;
634: l_proc varchar2(72) := g_package||'ins';
635: --
636: Begin
637: hr_utility.set_location('Entering:'||l_proc, 5);
639: -- Call conversion function to turn arguments into the
640: -- p_rec structure.
641: --
642: l_rec :=
643: pay_rfm_shd.convert_args
644: (p_report_type
645: ,p_report_qualifier
646: ,p_report_format
647: ,null