DBA Data[Home] [Help]

APPS.HR_PFT_DEL dependencies on HR_API

Line 73: When hr_api.child_integrity_violated then

69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: hr_pft_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: hr_pft_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;
81: End delete_dml;

Line 178: when hr_api.cannot_find_prog_unit then

174: );
175: --
176: exception
177: --
178: when hr_api.cannot_find_prog_unit then
179: --
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'HR_ALL_POSITIONS_F_TL'
182: ,p_hook_type => 'AD');

Line 180: hr_api.cannot_find_prog_unit_error

176: exception
177: --
178: when hr_api.cannot_find_prog_unit then
179: --
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'HR_ALL_POSITIONS_F_TL'
182: ,p_hook_type => 'AD');
183: --
184: end;

Line 280: and psf.effective_end_date = hr_api.g_eot;

276: cursor c_definition_id IS
277: select psf.position_definition_id
278: from hr_all_positions_f psf
279: where psf.position_id = p_position_id
280: and psf.effective_end_date = hr_api.g_eot;
281: --
282: -- Cursor to obtain all the translation rows.
283: --
284: cursor csr_del_langs is

Line 311: hr_pft_ins.ins_tl( p_language_code => hr_api.userenv_lang

307: open c_definition_id;
308: fetch c_definition_id into l_position_definition_id;
309: close c_definition_id;
310: --
311: hr_pft_ins.ins_tl( p_language_code => hr_api.userenv_lang
312: , p_position_id => p_position_id
313: , p_position_definition_id => l_position_definition_id
314: );
315: