46: -- Internal Row Handler Use Only.
47: --
48: -- {End Of Comments}
49: -- ----------------------------------------------------------------------------
50: Procedure insert_dml(p_rec in out nocopy pay_sbf_shd.g_rec_type) is
51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: pay_sbf_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_sbf_shd.constraint_error
85: pay_sbf_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: pay_sbf_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: pay_sbf_shd.constraint_error
89: pay_sbf_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: pay_sbf_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then
96: Raise;
97: End insert_dml;
132: -- Internal Row Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_insert(p_rec in out nocopy pay_sbf_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_insert';
139: --
140: Cursor C_Sel1 is select pay_shadow_balance_feeds_s.nextval from sys.dual;
183: -- Internal Row Handler Use Only.
184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure post_insert(p_rec in pay_sbf_shd.g_rec_type) is
188: --
189: l_proc varchar2(72) := g_package||'post_insert';
190: --
191: Begin
199: -- ----------------------------------------------------------------------------
200: Procedure ins
201: (
202: p_effective_date in date,
203: p_rec in out nocopy pay_sbf_shd.g_rec_type
204: ) is
205: --
206: l_proc varchar2(72) := g_package||'ins';
207: --
239: p_exclusion_rule_id in number default null,
240: p_object_version_number out nocopy number
241: ) is
242: --
243: l_rec pay_sbf_shd.g_rec_type;
244: l_proc varchar2(72) := g_package||'ins';
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
249: -- Call conversion function to turn arguments into the
250: -- p_rec structure.
251: --
252: l_rec :=
253: pay_sbf_shd.convert_args
254: (
255: null,
256: p_balance_type_id,
257: p_input_value_id,