DBA Data[Home] [Help]

APPS.HR_TIC_DEL dependencies on HR_TIC_SHD

Line 52: (p_rec in hr_tic_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in hr_tic_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 91: hr_tic_shd.constraint_error

87: Exception
88: When hr_api.child_integrity_violated then
89: -- Child integrity has been violated
90: --
91: hr_tic_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: --
95: Raise;

Line 130: Procedure pre_delete(p_rec in hr_tic_shd.g_rec_type) is

126: -- Internal Row Handler Use Only.
127: --
128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130: Procedure pre_delete(p_rec in hr_tic_shd.g_rec_type) is
131: --
132: l_proc varchar2(72) := g_package||'pre_delete';
133: --
134: Begin

Line 172: Procedure post_delete(p_rec in hr_tic_shd.g_rec_type) is

168: -- Internal Row Handler Use Only.
169: --
170: -- {End Of Comments}
171: -- -----------------------------------------------------------------------------
172: Procedure post_delete(p_rec in hr_tic_shd.g_rec_type) is
173: --
174: l_proc varchar2(72) := g_package||'post_delete';
175: --
176: Begin

Line 184: => hr_tic_shd.g_old_rec.object_version_number

180: hr_tic_rkd.after_delete
181: (p_template_item_context_id
182: => p_rec.template_item_context_id
183: ,p_object_version_number_o
184: => hr_tic_shd.g_old_rec.object_version_number
185: ,p_template_item_id_o
186: => hr_tic_shd.g_old_rec.template_item_id
187: ,p_context_type_o
188: => hr_tic_shd.g_old_rec.context_type

Line 186: => hr_tic_shd.g_old_rec.template_item_id

182: => p_rec.template_item_context_id
183: ,p_object_version_number_o
184: => hr_tic_shd.g_old_rec.object_version_number
185: ,p_template_item_id_o
186: => hr_tic_shd.g_old_rec.template_item_id
187: ,p_context_type_o
188: => hr_tic_shd.g_old_rec.context_type
189: ,p_item_context_id_o
190: => hr_tic_shd.g_old_rec.item_context_id

Line 188: => hr_tic_shd.g_old_rec.context_type

184: => hr_tic_shd.g_old_rec.object_version_number
185: ,p_template_item_id_o
186: => hr_tic_shd.g_old_rec.template_item_id
187: ,p_context_type_o
188: => hr_tic_shd.g_old_rec.context_type
189: ,p_item_context_id_o
190: => hr_tic_shd.g_old_rec.item_context_id
191: );
192: --

Line 190: => hr_tic_shd.g_old_rec.item_context_id

186: => hr_tic_shd.g_old_rec.template_item_id
187: ,p_context_type_o
188: => hr_tic_shd.g_old_rec.context_type
189: ,p_item_context_id_o
190: => hr_tic_shd.g_old_rec.item_context_id
191: );
192: --
193: exception
194: --

Line 210: (p_rec in hr_tic_shd.g_rec_type

206: -- ----------------------------------------------------------------------------
207: -- |---------------------------------< del >----------------------------------|
208: -- ----------------------------------------------------------------------------
209: Procedure del
210: (p_rec in hr_tic_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'del';
214: --

Line 220: hr_tic_shd.lck

216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: -- We must lock the row which we need to delete.
219: --
220: hr_tic_shd.lck
221: (p_rec.template_item_context_id
222: ,p_rec.object_version_number
223: );
224: --

Line 251: l_rec hr_tic_shd.g_rec_type;

247: (p_template_item_context_id in number
248: ,p_object_version_number in number
249: ) is
250: --
251: l_rec hr_tic_shd.g_rec_type;
252: l_proc varchar2(72) := g_package||'del';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);