[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_fed_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is
68: t.creation_date
69: from pay_us_emp_fed_tax_rules_f t
70: where t.emp_fed_tax_rule_id = p_rec.emp_fed_tax_rule_id
71: and t.effective_start_date =
72: pay_fed_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by pay_us_emp_fed_tax_rules_f.created_by%TYPE;
125: l_last_updated_by := fnd_global.user_id;
126: l_last_update_login := fnd_global.login_id;
127: End If;
128: --
129: pay_fed_shd.g_api_dml := true; -- Set the api dml status
130: --
131: -- Insert the row into: pay_us_emp_fed_tax_rules_f
132: --
133: insert into pay_us_emp_fed_tax_rules_f
317: p_rec.fed_information28,
318: p_rec.fed_information29,
319: p_rec.fed_information30 );
320: --
321: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
322: hr_utility.set_location(' Leaving:'||l_proc, 15);
323: --
324: Exception
325: When hr_api.check_integrity_violated Then
323: --
324: Exception
325: When hr_api.check_integrity_violated Then
326: -- A check constraint has been violated
327: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
328: pay_fed_shd.constraint_error
329: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
330: When hr_api.unique_integrity_violated Then
331: -- Unique integrity has been violated
324: Exception
325: When hr_api.check_integrity_violated Then
326: -- A check constraint has been violated
327: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
328: pay_fed_shd.constraint_error
329: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
330: When hr_api.unique_integrity_violated Then
331: -- Unique integrity has been violated
332: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
328: pay_fed_shd.constraint_error
329: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
330: When hr_api.unique_integrity_violated Then
331: -- Unique integrity has been violated
332: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
333: pay_fed_shd.constraint_error
334: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
335: When Others Then
336: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
329: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
330: When hr_api.unique_integrity_violated Then
331: -- Unique integrity has been violated
332: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
333: pay_fed_shd.constraint_error
334: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
335: When Others Then
336: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
337: Raise;
332: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
333: pay_fed_shd.constraint_error
334: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
335: When Others Then
336: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
337: Raise;
338: End dt_insert_dml;
339: --
340: -- ----------------------------------------------------------------------------
340: -- ----------------------------------------------------------------------------
341: -- |------------------------------< insert_dml >------------------------------|
342: -- ----------------------------------------------------------------------------
343: Procedure insert_dml
344: (p_rec in out nocopy pay_fed_shd.g_rec_type,
345: p_effective_date in date,
346: p_datetrack_mode in varchar2,
347: p_validation_start_date in date,
348: p_validation_end_date in date) is
400: --
401: -- {End Of Comments}
402: -- ----------------------------------------------------------------------------
403: Procedure pre_insert
404: (p_rec in out nocopy pay_fed_shd.g_rec_type,
405: p_effective_date in date,
406: p_datetrack_mode in varchar2,
407: p_validation_start_date in date,
408: p_validation_end_date in date) is
457: --
458: -- {End Of Comments}
459: -- ----------------------------------------------------------------------------
460: Procedure post_insert
461: (p_rec in pay_fed_shd.g_rec_type,
462: p_effective_date in date,
463: p_datetrack_mode in varchar2,
464: p_validation_start_date in date,
465: p_validation_end_date in date) is
564: -- ----------------------------------------------------------------------------
565: Procedure ins_lck
566: (p_effective_date in date,
567: p_datetrack_mode in varchar2,
568: p_rec in pay_fed_shd.g_rec_type,
569: p_validation_start_date out nocopy date,
570: p_validation_end_date out nocopy date) is
571: --
572: l_proc varchar2(72) := g_package||'ins_lck';
605: -- |---------------------------------< ins >----------------------------------|
606: -- ----------------------------------------------------------------------------
607: Procedure ins
608: (
609: p_rec in out nocopy pay_fed_shd.g_rec_type,
610: p_effective_date in date
611: ) is
612: --
613: l_proc varchar2(72) := g_package||'ins';
758: p_fed_information29 in varchar2 default null,
759: p_fed_information30 in varchar2 default null
760: ) is
761: --
762: l_rec pay_fed_shd.g_rec_type;
763: l_proc varchar2(72) := g_package||'ins';
764: --
765: Begin
766: hr_utility.set_location('Entering:'||l_proc, 5);
768: -- Call conversion function to turn arguments into the
769: -- p_rec structure.
770: --
771: l_rec :=
772: pay_fed_shd.convert_args
773: (
774: null,
775: null,
776: null,