APPS.PAY_SBT_INS dependencies on PAY_SBT_SHD

Line 50: Procedure insert_dml(p_rec in out nocopy pay_sbt_shd.g_rec_type) is

46: -- Internal Row Handler Use Only.
47: --
48: -- {End Of Comments}
49: -- ----------------------------------------------------------------------------
50: Procedure insert_dml(p_rec in out nocopy pay_sbt_shd.g_rec_type) is
51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin

Line 145: pay_sbt_shd.constraint_error

141: hr_utility.set_location(' Leaving:'||l_proc, 10);
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: pay_sbt_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: pay_sbt_shd.constraint_error

Line 149: pay_sbt_shd.constraint_error

145: pay_sbt_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: pay_sbt_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.unique_integrity_violated Then
152: -- Unique integrity has been violated
153: pay_sbt_shd.constraint_error

Line 153: pay_sbt_shd.constraint_error

149: pay_sbt_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.unique_integrity_violated Then
152: -- Unique integrity has been violated
153: pay_sbt_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: Raise;
157: End insert_dml;

Line 196: Procedure pre_insert(p_rec in out nocopy pay_sbt_shd.g_rec_type) is

192: -- Internal Row Handler Use Only.
193: --
194: -- {End Of Comments}
195: -- ----------------------------------------------------------------------------
196: Procedure pre_insert(p_rec in out nocopy pay_sbt_shd.g_rec_type) is
197: --
198: l_proc varchar2(72) := g_package||'pre_insert';
199: --
200: Cursor C_Sel1 is select pay_shadow_balance_types_s.nextval from sys.dual;

Line 247: Procedure post_insert(p_rec in pay_sbt_shd.g_rec_type) is

243: -- Internal Row Handler Use Only.
244: --
245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure post_insert(p_rec in pay_sbt_shd.g_rec_type) is
248: --
249: l_proc varchar2(72) := g_package||'post_insert';
250: --
251: Begin

Line 263: p_rec in out nocopy pay_sbt_shd.g_rec_type

259: -- ----------------------------------------------------------------------------
260: Procedure ins
261: (
262: p_effective_date in date,
263: p_rec in out nocopy pay_sbt_shd.g_rec_type
264: ) is
265: --
266: l_proc varchar2(72) := g_package||'ins';
267: --

Line 333: l_rec pay_sbt_shd.g_rec_type;

329: p_input_value_id in number default null,
330: p_object_version_number out nocopy number
331: ) is
332: --
333: l_rec pay_sbt_shd.g_rec_type;
334: l_proc varchar2(72) := g_package||'ins';
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);

Line 343: pay_sbt_shd.convert_args

339: -- Call conversion function to turn arguments into the
340: -- p_rec structure.
341: --
342: l_rec :=
343: pay_sbt_shd.convert_args
344: (
345: null,
346: p_template_id,
347: p_assignment_remuneration_flag,