DBA Data[Home] [Help]

APPS.PER_GRA_BUS dependencies on PER_GRA_SHD

Line 50: l_api_updating := per_gra_shd.api_updating

46: Begin
47: --
48: hr_utility.set_location('Entering:'||l_proc, 5);
49: --
50: l_api_updating := per_gra_shd.api_updating
51: (p_cagr_grade_id => p_cagr_grade_id,
52: p_object_version_number => p_object_version_number,
53: p_effective_date => p_effective_date);
54: --

Line 57: <> per_gra_shd.g_old_rec.cagr_grade_id) then

53: p_effective_date => p_effective_date);
54: --
55: if (l_api_updating
56: and nvl(p_cagr_grade_id,hr_api.g_number)
57: <> per_gra_shd.g_old_rec.cagr_grade_id) then
58: --
59: -- raise error as PK has changed
60: --
61: per_gra_shd.constraint_error('PER_CAGR_GRADES_PK');

Line 61: per_gra_shd.constraint_error('PER_CAGR_GRADES_PK');

57: <> per_gra_shd.g_old_rec.cagr_grade_id) then
58: --
59: -- raise error as PK has changed
60: --
61: per_gra_shd.constraint_error('PER_CAGR_GRADES_PK');
62: --
63: elsif not l_api_updating then
64: --
65: -- check if PK is null

Line 71: per_gra_shd.constraint_error('PER_CAGR_GRADES_PK');

67: if p_cagr_grade_id is not null then
68: --
69: -- raise error as PK is not null
70: --
71: per_gra_shd.constraint_error('PER_CAGR_GRADES_PK');
72: --
73: end if;
74: --
75: end if;

Line 289: Procedure insert_validate(p_rec in per_gra_shd.g_rec_type,

285: --
286: -- ----------------------------------------------------------------------------
287: -- |---------------------------< insert_validate >----------------------------|
288: -- ----------------------------------------------------------------------------
289: Procedure insert_validate(p_rec in per_gra_shd.g_rec_type,
290: p_effective_date in date) is
291: --
292: l_proc varchar2(72) := g_package||'insert_validate';
293: --

Line 322: Procedure update_validate(p_rec in per_gra_shd.g_rec_type,

318: --
319: -- ----------------------------------------------------------------------------
320: -- |---------------------------< update_validate >----------------------------|
321: -- ----------------------------------------------------------------------------
322: Procedure update_validate(p_rec in per_gra_shd.g_rec_type,
323: p_effective_date in date) is
324: --
325: l_proc varchar2(72) := g_package||'update_validate';
326: --

Line 355: Procedure delete_validate(p_rec in per_gra_shd.g_rec_type,

351: --
352: -- ----------------------------------------------------------------------------
353: -- |---------------------------< delete_validate >----------------------------|
354: -- ----------------------------------------------------------------------------
355: Procedure delete_validate(p_rec in per_gra_shd.g_rec_type,
356: p_effective_date in date) is
357: --
358: l_proc varchar2(72) := g_package||'delete_validate';
359: --