[Home] [Help]
75: --
76: -- {End Of Comments}
77: -- ----------------------------------------------------------------------------
78: Procedure dt_insert_dml
79: (p_rec in out nocopy pay_opm_shd.g_rec_type
80: ,p_effective_date in date
81: ,p_datetrack_mode in varchar2
82: ,p_validation_start_date in date
83: ,p_validation_end_date in date
89: t.creation_date
90: from pay_org_payment_methods_f t
91: where t.org_payment_method_id = p_rec.org_payment_method_id
92: and t.effective_start_date =
93: pay_opm_shd.g_old_rec.effective_start_date
94: and t.effective_end_date = (p_validation_start_date - 1);
95: --
96: l_proc varchar2(72) := g_package||'dt_insert_dml';
97: l_created_by pay_org_payment_methods_f.created_by%TYPE;
147: l_last_updated_by := fnd_global.user_id;
148: l_last_update_login := fnd_global.login_id;
149: End If;
150: --
151: pay_opm_shd.g_api_dml := true; -- Set the api dml status
152: --
153: -- Insert the row into: pay_org_payment_methods_f
154: --
155: insert into pay_org_payment_methods_f
282: ,p_rec.cost_cleared_void_payment
283: ,p_rec.exclude_manual_payment
284: );
285: --
286: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
287: hr_utility.set_location(' Leaving:'||l_proc, 15);
288: --
289: Exception
290: When hr_api.check_integrity_violated Then
288: --
289: Exception
290: When hr_api.check_integrity_violated Then
291: -- A check constraint has been violated
292: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
293: pay_opm_shd.constraint_error
294: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
295: When hr_api.unique_integrity_violated Then
296: -- Unique integrity has been violated
289: Exception
290: When hr_api.check_integrity_violated Then
291: -- A check constraint has been violated
292: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
293: pay_opm_shd.constraint_error
294: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
295: When hr_api.unique_integrity_violated Then
296: -- Unique integrity has been violated
297: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
293: pay_opm_shd.constraint_error
294: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
295: When hr_api.unique_integrity_violated Then
296: -- Unique integrity has been violated
297: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
298: pay_opm_shd.constraint_error
299: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
300: When Others Then
301: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
294: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
295: When hr_api.unique_integrity_violated Then
296: -- Unique integrity has been violated
297: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
298: pay_opm_shd.constraint_error
299: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
300: When Others Then
301: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
302: Raise;
297: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
298: pay_opm_shd.constraint_error
299: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
300: When Others Then
301: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
302: Raise;
303: End dt_insert_dml;
304: --
305: -- ----------------------------------------------------------------------------
305: -- ----------------------------------------------------------------------------
306: -- |------------------------------< insert_dml >------------------------------|
307: -- ----------------------------------------------------------------------------
308: Procedure insert_dml
309: (p_rec in out nocopy pay_opm_shd.g_rec_type
310: ,p_effective_date in date
311: ,p_datetrack_mode in varchar2
312: ,p_validation_start_date in date
313: ,p_validation_end_date in date
368: --
369: -- {End Of Comments}
370: -- ----------------------------------------------------------------------------
371: Procedure pre_insert
372: (p_rec in out nocopy pay_opm_shd.g_rec_type
373: ,p_effective_date in date
374: ,p_datetrack_mode in varchar2
375: ,p_validation_start_date in date
376: ,p_validation_end_date in date
468: --
469: -- {End Of Comments}
470: -- ----------------------------------------------------------------------------
471: Procedure post_insert
472: (p_rec in pay_opm_shd.g_rec_type
473: ,p_effective_date in date
474: ,p_datetrack_mode in varchar2
475: ,p_validation_start_date in date
476: ,p_validation_end_date in date
660: -- ----------------------------------------------------------------------------
661: Procedure ins_lck
662: (p_effective_date in date
663: ,p_datetrack_mode in varchar2
664: ,p_rec in pay_opm_shd.g_rec_type
665: ,p_validation_start_date out nocopy date
666: ,p_validation_end_date out nocopy date
667: ) is
668: --
700: -- |---------------------------------< ins >----------------------------------|
701: -- ----------------------------------------------------------------------------
702: Procedure ins
703: (p_effective_date in date
704: ,p_rec in out nocopy pay_opm_shd.g_rec_type
705: ) is
706: --
707: l_proc varchar2(72) := g_package||'ins';
708: l_datetrack_mode varchar2(30) := hr_api.g_insert;
830: ,p_effective_end_date out nocopy date
831: ,p_comment_id out nocopy number
832: ) is
833: --
834: l_rec pay_opm_shd.g_rec_type;
835: l_proc varchar2(72) := g_package||'ins';
836: --
837: Begin
838: hr_utility.set_location('Entering:'||l_proc, 5);
840: -- Call conversion function to turn arguments into the
841: -- p_rec structure.
842: --
843: l_rec :=
844: pay_opm_shd.convert_args
845: (null
846: ,null
847: ,null
848: ,p_business_group_id