DBA Data[Home] [Help]

APPS.PAY_SDB_DEL dependencies on PAY_SDB_SHD

Line 48: Procedure delete_dml(p_rec in pay_sdb_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure delete_dml(p_rec in pay_sdb_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'delete_dml';
51: --
52: Begin

Line 67: pay_sdb_shd.constraint_error

63: --
64: Exception
65: When hr_api.child_integrity_violated then
66: -- Child integrity has been violated
67: pay_sdb_shd.constraint_error
68: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
69: When Others Then
70: Raise;
71: End delete_dml;

Line 105: Procedure pre_delete(p_rec in pay_sdb_shd.g_rec_type) is

101: -- Internal Row Handler Use Only.
102: --
103: -- {End Of Comments}
104: -- ----------------------------------------------------------------------------
105: Procedure pre_delete(p_rec in pay_sdb_shd.g_rec_type) is
106: --
107: l_proc varchar2(72) := g_package||'pre_delete';
108: --
109: Begin

Line 147: Procedure post_delete(p_rec in pay_sdb_shd.g_rec_type) is

143: -- Internal table Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure post_delete(p_rec in pay_sdb_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'post_delete';
150: --
151: Begin

Line 162: p_rec in pay_sdb_shd.g_rec_type

158: -- |---------------------------------< del >----------------------------------|
159: -- ----------------------------------------------------------------------------
160: Procedure del
161: (
162: p_rec in pay_sdb_shd.g_rec_type
163: ) is
164: --
165: l_proc varchar2(72) := g_package||'del';
166: --

Line 172: pay_sdb_shd.lck

168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: -- We must lock the row which we need to delete.
171: --
172: pay_sdb_shd.lck
173: (
174: p_rec.defined_balance_id,
175: p_rec.object_version_number
176: );

Line 204: l_rec pay_sdb_shd.g_rec_type;

200: p_defined_balance_id in number,
201: p_object_version_number in number
202: ) is
203: --
204: l_rec pay_sdb_shd.g_rec_type;
205: l_proc varchar2(72) := g_package||'del';
206: --
207: Begin
208: hr_utility.set_location('Entering:'||l_proc, 5);