APPS.PER_GRA_BUS dependencies on PER_CAGR_GRADES

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 178: FROM per_cagr_grades_def cgs

174: ) is
175: --
176: cursor crs_cgd is
177: SELECT '1'
178: FROM per_cagr_grades_def cgs
179: wHERE cgs.cagr_grade_def_id = p_cagr_grade_def_id;
180: --
181: l_proc varchar2(72) := g_package||'chk_cagr_grade_def_id';
182: l_exists VARCHAR2(2);

Line 246: FROM per_cagr_grades cgs

242: ) IS
243: --
244: cursor c_all_seq IS
245: SELECT '1'
246: FROM per_cagr_grades cgs
247: wHERE cgs.cagr_grade_structure_id = p_cagr_grade_structure_id
248: AND cgs.sequence = p_sequence
249: AND (p_cagr_grade_id <> cgs.cagr_grade_id
250: OR p_cagr_grade_id IS NULL);