DBA Data[Home] [Help]

APPS.HR_TWN_DEL dependencies on HR_TWN_SHD

Line 52: (p_rec in hr_twn_shd.g_rec_type

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

Line 97: hr_twn_shd.constraint_error

93: Exception
94: When hr_api.child_integrity_violated then
95: -- Child integrity has been violated
96: --
97: hr_twn_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;

Line 136: Procedure pre_delete(p_rec in hr_twn_shd.g_rec_type) is

132: -- Internal Row Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_delete(p_rec in hr_twn_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_delete';
139: --
140: Begin

Line 178: Procedure post_delete(p_rec in hr_twn_shd.g_rec_type) is

174: -- Internal Row Handler Use Only.
175: --
176: -- {End Of Comments}
177: -- -----------------------------------------------------------------------------
178: Procedure post_delete(p_rec in hr_twn_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'post_delete';
181: --
182: Begin

Line 190: => hr_twn_shd.g_old_rec.object_version_number

186: hr_twn_rkd.after_delete
187: (p_template_window_id
188: => p_rec.template_window_id
189: ,p_object_version_number_o
190: => hr_twn_shd.g_old_rec.object_version_number
191: ,p_form_template_id_o
192: => hr_twn_shd.g_old_rec.form_template_id
193: ,p_form_window_id_o
194: => hr_twn_shd.g_old_rec.form_window_id

Line 192: => hr_twn_shd.g_old_rec.form_template_id

188: => p_rec.template_window_id
189: ,p_object_version_number_o
190: => hr_twn_shd.g_old_rec.object_version_number
191: ,p_form_template_id_o
192: => hr_twn_shd.g_old_rec.form_template_id
193: ,p_form_window_id_o
194: => hr_twn_shd.g_old_rec.form_window_id
195: );
196: --

Line 194: => hr_twn_shd.g_old_rec.form_window_id

190: => hr_twn_shd.g_old_rec.object_version_number
191: ,p_form_template_id_o
192: => hr_twn_shd.g_old_rec.form_template_id
193: ,p_form_window_id_o
194: => hr_twn_shd.g_old_rec.form_window_id
195: );
196: --
197: exception
198: --

Line 214: (p_rec in hr_twn_shd.g_rec_type

210: -- ----------------------------------------------------------------------------
211: -- |---------------------------------< del >----------------------------------|
212: -- ----------------------------------------------------------------------------
213: Procedure del
214: (p_rec in hr_twn_shd.g_rec_type
215: ) is
216: --
217: l_proc varchar2(72) := g_package||'del';
218: --

Line 224: hr_twn_shd.lck

220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: -- We must lock the row which we need to delete.
223: --
224: hr_twn_shd.lck
225: (p_rec.template_window_id
226: ,p_rec.object_version_number
227: );
228: --

Line 255: l_rec hr_twn_shd.g_rec_type;

251: (p_template_window_id in number
252: ,p_object_version_number in number
253: ) is
254: --
255: l_rec hr_twn_shd.g_rec_type;
256: l_proc varchar2(72) := g_package||'del';
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);