APPS.PAY_SBC_INS dependencies on PAY_SBC_SHD

Line 50: Procedure insert_dml(p_rec in out nocopy pay_sbc_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_sbc_shd.g_rec_type) is
51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin

Line 83: pay_sbc_shd.constraint_error

79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pay_sbc_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sbc_shd.constraint_error

Line 87: pay_sbc_shd.constraint_error

83: pay_sbc_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sbc_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pay_sbc_shd.constraint_error

Line 91: pay_sbc_shd.constraint_error

87: pay_sbc_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pay_sbc_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: Raise;
95: End insert_dml;

Line 134: Procedure pre_insert(p_rec in out nocopy pay_sbc_shd.g_rec_type) is

130: -- Internal Row Handler Use Only.
131: --
132: -- {End Of Comments}
133: -- ----------------------------------------------------------------------------
134: Procedure pre_insert(p_rec in out nocopy pay_sbc_shd.g_rec_type) is
135: --
136: l_proc varchar2(72) := g_package||'pre_insert';
137: --
138: Cursor C_Sel1 is select pay_shadow_balance_classi_s.nextval from sys.dual;

Line 185: Procedure post_insert(p_rec in pay_sbc_shd.g_rec_type) is

181: -- Internal Row Handler Use Only.
182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure post_insert(p_rec in pay_sbc_shd.g_rec_type) is
186: --
187: l_proc varchar2(72) := g_package||'post_insert';
188: --
189: Begin

Line 200: p_rec in out nocopy pay_sbc_shd.g_rec_type

196: -- |---------------------------------< ins >----------------------------------|
197: -- ----------------------------------------------------------------------------
198: Procedure ins
199: (p_effective_date in date,
200: p_rec in out nocopy pay_sbc_shd.g_rec_type
201: ) is
202: --
203: l_proc varchar2(72) := g_package||'ins';
204: --

Line 239: l_rec pay_sbc_shd.g_rec_type;

235: p_object_version_number out nocopy number
236: ,p_exclusion_rule_id in number default null
237: ) is
238: --
239: l_rec pay_sbc_shd.g_rec_type;
240: l_proc varchar2(72) := g_package||'ins';
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);

Line 249: pay_sbc_shd.convert_args

245: -- Call conversion function to turn arguments into the
246: -- p_rec structure.
247: --
248: l_rec :=
249: pay_sbc_shd.convert_args
250: (
251: null,
252: p_balance_type_id,
253: p_element_classification,