[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_cty_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_city_tax_rules_f t
70: where t.emp_city_tax_rule_id = p_rec.emp_city_tax_rule_id
71: and t.effective_start_date =
72: pay_cty_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_city_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_cty_shd.g_api_dml := true; -- Set the api dml status
130: --
131: -- Insert the row into: pay_us_emp_city_tax_rules_f
132: --
133: insert into pay_us_emp_city_tax_rules_f
310: p_rec.cty_information29,
311: p_rec.cty_information30
312: );
313: --
314: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
315: hr_utility.set_location(' Leaving:'||l_proc, 15);
316: --
317: Exception
318: When hr_api.check_integrity_violated Then
316: --
317: Exception
318: When hr_api.check_integrity_violated Then
319: -- A check constraint has been violated
320: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
321: pay_cty_shd.constraint_error
322: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
323: When hr_api.unique_integrity_violated Then
324: -- Unique integrity has been violated
317: Exception
318: When hr_api.check_integrity_violated Then
319: -- A check constraint has been violated
320: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
321: pay_cty_shd.constraint_error
322: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
323: When hr_api.unique_integrity_violated Then
324: -- Unique integrity has been violated
325: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
321: pay_cty_shd.constraint_error
322: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
323: When hr_api.unique_integrity_violated Then
324: -- Unique integrity has been violated
325: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
326: pay_cty_shd.constraint_error
327: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
328: When Others Then
329: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
322: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
323: When hr_api.unique_integrity_violated Then
324: -- Unique integrity has been violated
325: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
326: pay_cty_shd.constraint_error
327: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
328: When Others Then
329: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
330: Raise;
325: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
326: pay_cty_shd.constraint_error
327: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
328: When Others Then
329: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
330: Raise;
331: End dt_insert_dml;
332: --
333: -- ----------------------------------------------------------------------------
333: -- ----------------------------------------------------------------------------
334: -- |------------------------------< insert_dml >------------------------------|
335: -- ----------------------------------------------------------------------------
336: Procedure insert_dml
337: (p_rec in out nocopy pay_cty_shd.g_rec_type,
338: p_effective_date in date,
339: p_datetrack_mode in varchar2,
340: p_validation_start_date in date,
341: p_validation_end_date in date) is
393: --
394: -- {End Of Comments}
395: -- ----------------------------------------------------------------------------
396: Procedure pre_insert
397: (p_rec in out nocopy pay_cty_shd.g_rec_type,
398: p_effective_date in date,
399: p_datetrack_mode in varchar2,
400: p_validation_start_date in date,
401: p_validation_end_date in date) is
452: --
453: -- {End Of Comments}
454: -- ----------------------------------------------------------------------------
455: Procedure post_insert
456: (p_rec in pay_cty_shd.g_rec_type,
457: p_effective_date in date,
458: p_datetrack_mode in varchar2,
459: p_validation_start_date in date,
460: p_validation_end_date in date) is
555: -- ----------------------------------------------------------------------------
556: Procedure ins_lck
557: (p_effective_date in date,
558: p_datetrack_mode in varchar2,
559: p_rec in pay_cty_shd.g_rec_type,
560: p_validation_start_date out nocopy date,
561: p_validation_end_date out nocopy date) is
562: --
563: l_proc varchar2(72) := g_package||'ins_lck';
596: -- |---------------------------------< ins >----------------------------------|
597: -- ----------------------------------------------------------------------------
598: Procedure ins
599: (
600: p_rec in out nocopy pay_cty_shd.g_rec_type,
601: p_effective_date in date
602: ) is
603: --
604: l_proc varchar2(72) := g_package||'ins';
745: p_cty_information29 in varchar2 default null,
746: p_cty_information30 in varchar2 default null
747: ) is
748: --
749: l_rec pay_cty_shd.g_rec_type;
750: l_proc varchar2(72) := g_package||'ins';
751: --
752: Begin
753: hr_utility.set_location('Entering:'||l_proc, 5);
755: -- Call conversion function to turn arguments into the
756: -- p_rec structure.
757: --
758: l_rec :=
759: pay_cty_shd.convert_args
760: (
761: null,
762: null,
763: null,