APPS.PER_ZA_EQT_BUS dependencies on PER_QUALIFICATION_TYPES

Line 36: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');

32: not l_api_updating then
33: --
34: -- raise error as PK not null
35: --
36: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');
37: --
38: end if;
39: --
40: -- check if qualification_type_id has been updated

Line 48: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');

44: and l_api_updating then
45: --
46: -- raise error as update is not allowed
47: --
48: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');
49: --
50: end if;
51: --
52: end if;

Line 71: from per_qualification_types per

67: l_dummy varchar2(1);
68: --
69: cursor c1 is
70: select null
71: from per_qualification_types per
72: where per.name = p_name;
73: --
74: Begin
75: hr_utility.set_location('Entering:'||l_proc, 5);

Line 89: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_UK');

85: if p_name is null then
86: --
87: -- raise error
88: --
89: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_UK');
90: --
91: end if;
92: --
93: -- check if the qualification name exists in the per_qualification_types

Line 93: -- check if the qualification name exists in the per_qualification_types

89: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_UK');
90: --
91: end if;
92: --
93: -- check if the qualification name exists in the per_qualification_types
94: -- table.
95: --
96: if p_name <> per_za_eqt_shd.g_old_rec.name then
97: --

Line 109: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_UK');

105: --
106: -- raise error
107: --
108: close c1;
109: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_UK');
110: --
111: end if;
112: --
113: close c1;