DBA Data[Home] [Help]

APPS.BEN_DPNT_EGD_INS dependencies on BEN_ELIGY_CRITERIA_DPNT

Line 65: insert into ben_eligy_criteria_dpnt

61: ben_dpnt_egd_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ben_eligy_criteria
64: --
65: insert into ben_eligy_criteria_dpnt
66: (
67: eligy_criteria_dpnt_id,
68: name,
69: short_code,

Line 254: Cursor C_Sel1 is select ben_eligy_criteria_dpnt_s.nextval from sys.dual;

250: Procedure pre_insert(p_rec in out nocopy ben_dpnt_egd_shd.g_rec_type) is
251: --
252: l_proc varchar2(72) := g_package||'pre_insert';
253: --
254: Cursor C_Sel1 is select ben_eligy_criteria_dpnt_s.nextval from sys.dual;
255: --
256: Begin
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --

Line 305: l_eligy_criteria_dpnt_id ben_eligy_criteria_dpnt.eligy_criteria_dpnt_id%TYPE;

301: Procedure post_insert(p_rec in ben_dpnt_egd_shd.g_rec_type
302: ,p_effective_date in date) is
303: --
304: l_proc varchar2(72) := g_package||'post_insert';
305: l_eligy_criteria_dpnt_id ben_eligy_criteria_dpnt.eligy_criteria_dpnt_id%TYPE;
306: --
307: Begin
308:
309: hr_utility.set_location('Entering:'||l_proc, 5);

Line 385: (p_module_name => 'ben_eligy_criteria_dpnt'

381: --
382: when hr_api.cannot_find_prog_unit then
383: --
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'ben_eligy_criteria_dpnt'
386: ,p_hook_type => 'AI');
387: --
388: end;
389: --