eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_EQT_BUS dependencies on PER_ZA_EQT_SHD

Line 22: l_api_updating := per_za_eqt_shd.api_updating

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: l_api_updating := per_za_eqt_shd.api_updating
23: (p_qualification_type_id => p_qualification_type_id,
24: p_object_version_number => p_object_version_number);
25: --
26: if (l_api_updating and

Line 28: <> per_za_eqt_shd.g_old_rec.qualification_type_id or

24: p_object_version_number => p_object_version_number);
25: --
26: if (l_api_updating and
27: nvl(p_qualification_type_id,hr_api.g_number)
28: <> per_za_eqt_shd.g_old_rec.qualification_type_id or
29: not l_api_updating) then
30: --
31: if p_qualification_type_id is not null and
32: not l_api_updating then

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 43: <> per_za_eqt_shd.g_old_rec.qualification_type_id

39: --
40: -- check if qualification_type_id has been updated
41: --
42: if nvl(p_qualification_type_id,hr_api.g_number)
43: <> per_za_eqt_shd.g_old_rec.qualification_type_id
44: and l_api_updating then
45: --
46: -- raise error as update is not allowed
47: --

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 77: l_api_updating := per_za_eqt_shd.api_updating

73: --
74: Begin
75: hr_utility.set_location('Entering:'||l_proc, 5);
76: --
77: l_api_updating := per_za_eqt_shd.api_updating
78: (p_qualification_type_id => p_qualification_type_id,
79: p_object_version_number => p_object_version_number);
80: --
81: if (l_api_updating and

Line 82: nvl(p_name,hr_api.g_varchar2) <> per_za_eqt_shd.g_old_rec.name or

78: (p_qualification_type_id => p_qualification_type_id,
79: p_object_version_number => p_object_version_number);
80: --
81: if (l_api_updating and
82: nvl(p_name,hr_api.g_varchar2) <> per_za_eqt_shd.g_old_rec.name or
83: not l_api_updating) then
84: --
85: if p_name is null then
86: --

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 96: if p_name <> per_za_eqt_shd.g_old_rec.name then

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: --
98: -- only check if it has changed so as to avoid unneccessary accesses to
99: -- the database
100: --

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;

Line 161: l_api_updating := per_za_eqt_shd.api_updating

157: Begin
158: --
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: l_api_updating := per_za_eqt_shd.api_updating
162: (p_qualification_type_id => p_qualification_type_id,
163: p_object_version_number => p_object_version_number);
164: --
165: if (l_api_updating

Line 167: <> per_za_eqt_shd.g_old_rec.category

163: p_object_version_number => p_object_version_number);
164: --
165: if (l_api_updating
166: and nvl(p_category,hr_api.g_varchar2)
167: <> per_za_eqt_shd.g_old_rec.category
168: or not l_api_updating) then
169: --
170: -- check if value of category exists in lookup 'PER_CATEGORIES'
171: --

Line 229: Procedure insert_validate(p_rec in per_za_eqt_shd.g_rec_type,

225: end chk_qualification_delete;
226: -- ----------------------------------------------------------------------------
227: -- |---------------------------< insert_validate >----------------------------|
228: -- ----------------------------------------------------------------------------
229: Procedure insert_validate(p_rec in per_za_eqt_shd.g_rec_type,
230: p_effective_date in date) is
231: --
232: l_proc varchar2(72) := g_package||'insert_validate';
233: --

Line 278: Procedure update_validate(p_rec in per_za_eqt_shd.g_rec_type,

274: --
275: -- ----------------------------------------------------------------------------
276: -- |---------------------------< update_validate >----------------------------|
277: -- ----------------------------------------------------------------------------
278: Procedure update_validate(p_rec in per_za_eqt_shd.g_rec_type,
279: p_effective_date in date) is
280: --
281: l_proc varchar2(72) := g_package||'update_validate';
282: --

Line 327: Procedure delete_validate(p_rec in per_za_eqt_shd.g_rec_type) is

323: --
324: -- ----------------------------------------------------------------------------
325: -- |---------------------------< delete_validate >----------------------------|
326: -- ----------------------------------------------------------------------------
327: Procedure delete_validate(p_rec in per_za_eqt_shd.g_rec_type) is
328: --
329: l_proc varchar2(72) := g_package||'delete_validate';
330: --
331: Begin