DBA Data[Home] [Help]

APPS.HR_LOT_DEL dependencies on HR_LOT_SHD

Line 45: Procedure delete_dml(p_rec in hr_lot_shd.g_rec_type) is

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

Line 63: hr_lot_shd.constraint_error

59: --
60: Exception
61: When hr_api.child_integrity_violated then
62: -- Child integrity has been violated
63: hr_lot_shd.constraint_error
64: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
65: When Others Then
66: Raise;
67: End delete_dml;

Line 101: Procedure pre_delete(p_rec in hr_lot_shd.g_rec_type) is

97: -- Internal Row Handler Use Only.
98: --
99: -- {End Of Comments}
100: -- ----------------------------------------------------------------------------
101: Procedure pre_delete(p_rec in hr_lot_shd.g_rec_type) is
102: --
103: l_proc varchar2(72) := g_package||'pre_delete';
104: --
105: Begin

Line 143: Procedure post_delete(p_rec in hr_lot_shd.g_rec_type) is

139: -- Internal table Handler Use Only.
140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure post_delete(p_rec in hr_lot_shd.g_rec_type) is
144: --
145: l_proc varchar2(72) := g_package||'post_delete';
146: --
147: Begin

Line 159: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang

155: hr_lot_rkd.after_delete
156: (
157: p_location_id =>p_rec.location_id
158: ,p_language =>p_rec.language
159: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang
160: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code
161: ,p_description_o =>hr_lot_shd.g_old_rec.description
162: );
163: --

Line 160: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code

156: (
157: p_location_id =>p_rec.location_id
158: ,p_language =>p_rec.language
159: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang
160: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code
161: ,p_description_o =>hr_lot_shd.g_old_rec.description
162: );
163: --
164: exception

Line 161: ,p_description_o =>hr_lot_shd.g_old_rec.description

157: p_location_id =>p_rec.location_id
158: ,p_language =>p_rec.language
159: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang
160: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code
161: ,p_description_o =>hr_lot_shd.g_old_rec.description
162: );
163: --
164: exception
165: --

Line 185: p_rec in hr_lot_shd.g_rec_type

181: -- |---------------------------------< del >----------------------------------|
182: -- ----------------------------------------------------------------------------
183: Procedure del
184: (
185: p_rec in hr_lot_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'del';
189: --

Line 195: hr_lot_shd.lck

191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: -- We must lock the row which we need to delete.
194: --
195: hr_lot_shd.lck
196: (
197: p_rec.location_id,
198: p_rec.language
199: );

Line 227: l_rec hr_lot_shd.g_rec_type;

223: p_location_id in number,
224: p_language in varchar2
225: ) is
226: --
227: l_rec hr_lot_shd.g_rec_type;
228: l_proc varchar2(72) := g_package||'del';
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);