APPS.PAY_SBA_INS dependencies on PAY_SBA_SHD

Line 76: (p_rec in out nocopy pay_sba_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy pay_sba_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 111: pay_sba_shd.constraint_error

107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: --
111: pay_sba_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --

Line 116: pay_sba_shd.constraint_error

112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --
116: pay_sba_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --

Line 121: pay_sba_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: pay_sba_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: --
125: Raise;

Line 166: (p_rec in out nocopy pay_sba_shd.g_rec_type

162: --
163: -- {End Of Comments}
164: -- ----------------------------------------------------------------------------
165: Procedure pre_insert
166: (p_rec in out nocopy pay_sba_shd.g_rec_type
167: ) is
168: --
169: Cursor C_Sel1 is select pay_shadow_bal_attributes_s.nextval from sys.dual;
170: --

Line 253: (p_rec in pay_sba_shd.g_rec_type

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure post_insert
253: (p_rec in pay_sba_shd.g_rec_type
254: ) is
255: --
256: l_proc varchar2(72) := g_package||'post_insert';
257: --

Line 268: (p_rec in out nocopy pay_sba_shd.g_rec_type

264: -- ----------------------------------------------------------------------------
265: -- |---------------------------------< ins >----------------------------------|
266: -- ----------------------------------------------------------------------------
267: Procedure ins
268: (p_rec in out nocopy pay_sba_shd.g_rec_type
269: ) is
270: --
271: l_proc varchar2(72) := g_package||'ins';
272: --

Line 316: l_rec pay_sba_shd.g_rec_type;

312: ,p_balance_attribute_id out nocopy number
313: ,p_object_version_number out nocopy number
314: ) is
315: --
316: l_rec pay_sba_shd.g_rec_type;
317: l_proc varchar2(72) := g_package||'ins';
318: --
319: Begin
320: hr_utility.set_location('Entering:'||l_proc, 5);

Line 326: pay_sba_shd.convert_args

322: -- Call conversion function to turn arguments into the
323: -- p_rec structure.
324: --
325: l_rec :=
326: pay_sba_shd.convert_args
327: (null
328: ,p_attribute_name
329: ,p_defined_balance_id
330: ,null