[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_rfi_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_items_f t
92: where t.report_format_item_id = p_rec.report_format_item_id
93: and t.effective_start_date =
94: pay_rfi_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_items_f.created_by%TYPE;
150: Else
151: p_rec.object_version_number := 1; -- Initialise the object version
152: End If;
153: --
154: pay_rfi_shd.g_api_dml := true; -- Set the api dml status
155: --
156: -- Insert the row into: pay_report_format_items_f
157: --
158: insert into pay_report_format_items_f
191: ,l_last_updated_by
192: ,l_last_update_login
193: );
194: --
195: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
196: hr_utility.set_location(' Leaving:'||l_proc, 15);
197: --
198: Exception
199: When hr_api.check_integrity_violated Then
197: --
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
202: pay_rfi_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
202: pay_rfi_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
202: pay_rfi_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
207: pay_rfi_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When Others Then
210: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
207: pay_rfi_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When Others Then
210: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
211: Raise;
206: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
207: pay_rfi_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When Others Then
210: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
211: Raise;
212: End dt_insert_dml;
213: --
214: -- ----------------------------------------------------------------------------
214: -- ----------------------------------------------------------------------------
215: -- |------------------------------< insert_dml >------------------------------|
216: -- ----------------------------------------------------------------------------
217: Procedure insert_dml
218: (p_rec in out nocopy pay_rfi_shd.g_rec_type
219: ,p_effective_date in date
220: ,p_datetrack_mode in varchar2
221: ,p_validation_start_date in date
222: ,p_validation_end_date in date
277: --
278: -- {End Of Comments}
279: -- ----------------------------------------------------------------------------
280: Procedure pre_insert
281: (p_rec in out nocopy pay_rfi_shd.g_rec_type
282: ,p_effective_date in date
283: ,p_datetrack_mode in varchar2
284: ,p_validation_start_date in date
285: ,p_validation_end_date in date
371: --
372: -- {End Of Comments}
373: -- ----------------------------------------------------------------------------
374: Procedure post_insert
375: (p_rec in pay_rfi_shd.g_rec_type
376: ,p_effective_date in date
377: ,p_datetrack_mode in varchar2
378: ,p_validation_start_date in date
379: ,p_validation_end_date in date
425: -- ----------------------------------------------------------------------------
426: Procedure ins_lck
427: (p_effective_date in date
428: ,p_datetrack_mode in varchar2
429: ,p_rec in pay_rfi_shd.g_rec_type
430: ,p_validation_start_date out nocopy date
431: ,p_validation_end_date out nocopy date
432: ) is
433: --
468: -- |---------------------------------< ins >----------------------------------|
469: -- ----------------------------------------------------------------------------
470: Procedure ins
471: (p_effective_date in date
472: ,p_rec in out nocopy pay_rfi_shd.g_rec_type
473: ) is
474: --
475: l_proc varchar2(72) := g_package||'ins';
476: l_datetrack_mode varchar2(30) := hr_api.g_insert;
556: ,p_effective_start_date out nocopy date
557: ,p_effective_end_date out nocopy date
558: ) is
559: --
560: l_rec pay_rfi_shd.g_rec_type;
561: l_proc varchar2(72) := g_package||'ins';
562: l_report_format_mapping_id pay_report_format_mappings_f.report_format_mapping_id%type;
563: --
564: Begin
573: ,p_report_qualifier => p_report_qualifier
574: ,p_report_category => p_report_category );
575:
576: l_rec :=
577: pay_rfi_shd.convert_args
578: (p_report_type
579: ,p_report_qualifier
580: ,p_report_category
581: ,p_user_entity_id