[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_cnt_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_county_tax_rules_f t
70: where t.emp_county_tax_rule_id = p_rec.emp_county_tax_rule_id
71: and t.effective_start_date =
72: pay_cnt_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_county_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_cnt_shd.g_api_dml := true; -- Set the api dml status
130: --
131: -- Insert the row into: pay_us_emp_county_tax_rules_f
132: --
133: insert into pay_us_emp_county_tax_rules_f
309: p_rec.cnt_information29,
310: p_rec.cnt_information30
311: );
312: --
313: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
314: hr_utility.set_location(' Leaving:'||l_proc, 15);
315: --
316: Exception
317: When hr_api.check_integrity_violated Then
315: --
316: Exception
317: When hr_api.check_integrity_violated Then
318: -- A check constraint has been violated
319: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
320: pay_cnt_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
316: Exception
317: When hr_api.check_integrity_violated Then
318: -- A check constraint has been violated
319: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
320: pay_cnt_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
320: pay_cnt_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
325: pay_cnt_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
327: When Others Then
328: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
325: pay_cnt_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
327: When Others Then
328: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
329: Raise;
324: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
325: pay_cnt_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
327: When Others Then
328: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
329: Raise;
330: End dt_insert_dml;
331: --
332: -- ----------------------------------------------------------------------------
332: -- ----------------------------------------------------------------------------
333: -- |------------------------------< insert_dml >------------------------------|
334: -- ----------------------------------------------------------------------------
335: Procedure insert_dml
336: (p_rec in out nocopy pay_cnt_shd.g_rec_type,
337: p_effective_date in date,
338: p_datetrack_mode in varchar2,
339: p_validation_start_date in date,
340: p_validation_end_date in date) is
392: --
393: -- {End Of Comments}
394: -- ----------------------------------------------------------------------------
395: Procedure pre_insert
396: (p_rec in out nocopy pay_cnt_shd.g_rec_type,
397: p_effective_date in date,
398: p_datetrack_mode in varchar2,
399: p_validation_start_date in date,
400: p_validation_end_date in date) is
449: --
450: -- {End Of Comments}
451: -- ----------------------------------------------------------------------------
452: Procedure post_insert
453: (p_rec in pay_cnt_shd.g_rec_type,
454: p_effective_date in date,
455: p_datetrack_mode in varchar2,
456: p_validation_start_date in date,
457: p_validation_end_date in date) is
551: -- ----------------------------------------------------------------------------
552: Procedure ins_lck
553: (p_effective_date in date,
554: p_datetrack_mode in varchar2,
555: p_rec in pay_cnt_shd.g_rec_type,
556: p_validation_start_date out nocopy date,
557: p_validation_end_date out nocopy date) is
558: --
559: l_proc varchar2(72) := g_package||'ins_lck';
592: -- |---------------------------------< ins >----------------------------------|
593: -- ----------------------------------------------------------------------------
594: Procedure ins
595: (
596: p_rec in out nocopy pay_cnt_shd.g_rec_type,
597: p_effective_date in date
598: ) is
599: --
600: l_proc varchar2(72) := g_package||'ins';
740: p_cnt_information29 in varchar2 default null,
741: p_cnt_information30 in varchar2 default null
742: ) is
743: --
744: l_rec pay_cnt_shd.g_rec_type;
745: l_proc varchar2(72) := g_package||'ins';
746: --
747: Begin
748: hr_utility.set_location('Entering:'||l_proc, 5);
750: -- Call conversion function to turn arguments into the
751: -- p_rec structure.
752: --
753: l_rec :=
754: pay_cnt_shd.convert_args
755: (
756: null,
757: null,
758: null,