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.BEN_ECY_BUS dependencies on BEN_ECY_SHD

Line 48: l_api_updating := ben_ecy_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_ecy_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ELIG_COMPTNCY_PRTE_id => p_ELIG_COMPTNCY_PRTE_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_ecy_shd.g_old_rec.ELIG_COMPTNCY_PRTE_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_ELIG_COMPTNCY_PRTE_id,hr_api.g_number)
55: <> ben_ecy_shd.g_old_rec.ELIG_COMPTNCY_PRTE_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_PK');

Line 59: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_PK');

55: <> ben_ecy_shd.g_old_rec.ELIG_COMPTNCY_PRTE_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_PK');

65: if p_ELIG_COMPTNCY_PRTE_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_PK');
70: --
71: end if;
72: --
73: end if;

Line 130: l_api_updating := ben_ecy_shd.api_updating

126: hr_api.mandatory_arg_error(p_api_name => l_proc,
127: p_argument => 'competence_id',
128: p_argument_value => p_competence_id);
129:
130: l_api_updating := ben_ecy_shd.api_updating
131: (p_ELIG_COMPTNCY_PRTE_id => p_ELIG_COMPTNCY_PRTE_id,
132: p_effective_date => p_effective_date,
133: p_object_version_number => p_object_version_number);
134: --

Line 137: <> nvl(ben_ecy_shd.g_old_rec.competence_id,hr_api.g_number)

133: p_object_version_number => p_object_version_number);
134: --
135: if (l_api_updating
136: and nvl(p_competence_id,hr_api.g_number)
137: <> nvl(ben_ecy_shd.g_old_rec.competence_id,hr_api.g_number)
138: or not l_api_updating)
139: and p_competence_id is not null then
140: --
141: -- check if competence_id value exists in

Line 154: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_F_FK1');

150: --
151: -- raise error as FK does not relate to PK in
152: -- per_competences table.
153: --
154: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_F_FK1');
155: --
156: end if;
157: --
158: close c1;

Line 228: l_api_updating := ben_ecy_shd.api_updating

224: hr_api.mandatory_arg_error(p_api_name => l_proc,
225: p_argument => 'rating_level_id',
226: p_argument_value => p_rating_level_id);
227:
228: l_api_updating := ben_ecy_shd.api_updating
229: (p_ELIG_COMPTNCY_PRTE_id => p_ELIG_COMPTNCY_PRTE_id,
230: p_effective_date => p_effective_date,
231: p_object_version_number => p_object_version_number);
232: --

Line 235: <> nvl(ben_ecy_shd.g_old_rec.rating_level_id,hr_api.g_number)

231: p_object_version_number => p_object_version_number);
232: --
233: if (l_api_updating
234: and nvl(p_rating_level_id,hr_api.g_number)
235: <> nvl(ben_ecy_shd.g_old_rec.rating_level_id,hr_api.g_number)
236: or not l_api_updating)
237: and p_rating_level_id is not null then
238: --
239: -- check if rating_level_id value exists in

Line 252: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_F_FK2');

248: --
249: -- raise error as FK does not relate to PK in
250: -- per_rating_levels table.
251: --
252: ben_ecy_shd.constraint_error('BEN_ELIG_COMPTNCY_PRTE_F_FK2');
253: --
254: end if;
255: --
256: close c1;

Line 302: l_api_updating := ben_ecy_shd.api_updating

298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: l_api_updating := ben_ecy_shd.api_updating
303: (p_ELIG_COMPTNCY_PRTE_id => p_ELIG_COMPTNCY_PRTE_id,
304: p_effective_date => p_effective_date,
305: p_object_version_number => p_object_version_number);
306: --

Line 309: <> nvl(ben_ecy_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

305: p_object_version_number => p_object_version_number);
306: --
307: if (l_api_updating
308: and p_excld_flag
309: <> nvl(ben_ecy_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
310: or not l_api_updating) then
311: --
312: -- check if value of lookup falls within lookup type.
313: --

Line 596: (p_rec in ben_ecy_shd.g_rec_type,

592: -- ----------------------------------------------------------------------------
593: -- |---------------------------< insert_validate >----------------------------|
594: -- ----------------------------------------------------------------------------
595: Procedure insert_validate
596: (p_rec in ben_ecy_shd.g_rec_type,
597: p_effective_date in date,
598: p_datetrack_mode in varchar2,
599: p_validation_start_date in date,
600: p_validation_end_date in date) is

Line 650: (p_rec in ben_ecy_shd.g_rec_type,

646: -- ----------------------------------------------------------------------------
647: -- |---------------------------< update_validate >----------------------------|
648: -- ----------------------------------------------------------------------------
649: Procedure update_validate
650: (p_rec in ben_ecy_shd.g_rec_type,
651: p_effective_date in date,
652: p_datetrack_mode in varchar2,
653: p_validation_start_date in date,
654: p_validation_end_date in date) is

Line 713: (p_rec in ben_ecy_shd.g_rec_type,

709: -- ----------------------------------------------------------------------------
710: -- |---------------------------< delete_validate >----------------------------|
711: -- ----------------------------------------------------------------------------
712: Procedure delete_validate
713: (p_rec in ben_ecy_shd.g_rec_type,
714: p_effective_date in date,
715: p_datetrack_mode in varchar2,
716: p_validation_start_date in date,
717: p_validation_end_date in date) is