DBA Data[Home] [Help]

APPS.HR_CAL_BUS dependencies on HR_CAL_SHD

Line 41: l_api_updating := hr_cal_shd.api_updating (

37: (p_api_name => l_proc,
38: p_argument => 'calendar name',
39: p_argument_value => p_calendar_name);
40: --
41: l_api_updating := hr_cal_shd.api_updating (
42: p_calendar_id => p_calendar_id,
43: p_object_version_number => p_object_version_number);
44: --
45: if (l_api_updating and hr_cal_shd.g_old_rec.calendar_name <> p_calendar_name)

Line 45: if (l_api_updating and hr_cal_shd.g_old_rec.calendar_name <> p_calendar_name)

41: l_api_updating := hr_cal_shd.api_updating (
42: p_calendar_id => p_calendar_id,
43: p_object_version_number => p_object_version_number);
44: --
45: if (l_api_updating and hr_cal_shd.g_old_rec.calendar_name <> p_calendar_name)
46: or (not l_api_updating) then
47: --
48: open csr_duplicate;
49: fetch csr_duplicate into l_dummy;

Line 53: hr_cal_shd.constraint_error ('HR_PAT_NAME_UK');

49: fetch csr_duplicate into l_dummy;
50: if csr_duplicate%found then
51: --
52: close csr_duplicate;
53: hr_cal_shd.constraint_error ('HR_PAT_NAME_UK');
54: --
55: else
56: --
57: close csr_duplicate;

Line 107: hr_cal_shd.constraint_error ('HR_CAL_PAT_FK');

103: --
104: -- The pattern id must be invalid
105: --
106: close csr_construction_rows;
107: hr_cal_shd.constraint_error ('HR_CAL_PAT_FK');
108: --
109: else
110: --
111: close csr_construction_rows;

Line 244: hr_cal_shd.constraint_error ('HR_CAL_PAT_FK');

240: fetch csr_pattern_details into l_pattern;
241: --
242: if csr_pattern_details%notfound then -- the pattern id must be invalid
243: close csr_pattern_details;
244: hr_cal_shd.constraint_error ('HR_CAL_PAT_FK');
245: else
246: close csr_pattern_details;
247: end if;
248: --

Line 298: Procedure insert_validate(p_rec in hr_cal_shd.g_rec_type) is

294: end chk_calendar_start_time;
295: -- ----------------------------------------------------------------------------
296: -- |---------------------------< insert_validate >----------------------------|
297: -- ----------------------------------------------------------------------------
298: Procedure insert_validate(p_rec in hr_cal_shd.g_rec_type) is
299: --
300: l_proc varchar2(72) := g_package||'insert_validate';
301: --
302: Begin

Line 323: Procedure update_validate(p_rec in hr_cal_shd.g_rec_type) is

319: --
320: -- ----------------------------------------------------------------------------
321: -- |---------------------------< update_validate >----------------------------|
322: -- ----------------------------------------------------------------------------
323: Procedure update_validate(p_rec in hr_cal_shd.g_rec_type) is
324: --
325: l_proc varchar2(72) := g_package||'update_validate';
326: --
327: Begin

Line 343: Procedure delete_validate(p_rec in hr_cal_shd.g_rec_type) is

339: --
340: -- ----------------------------------------------------------------------------
341: -- |---------------------------< delete_validate >----------------------------|
342: -- ----------------------------------------------------------------------------
343: Procedure delete_validate(p_rec in hr_cal_shd.g_rec_type) is
344: --
345: l_proc varchar2(72) := g_package||'delete_validate';
346: --
347: Begin