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_ECP_BUS dependencies on BEN_ECP_SHD

Line 48: l_api_updating := ben_ecp_shd.api_updating

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

Line 55: <> ben_ecp_shd.g_old_rec.elig_cmbn_age_los_prte_id) then

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

Line 59: ben_ecp_shd.constraint_error('BEN_ELIG_CMBN_A_S_PK');

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

Line 69: ben_ecp_shd.constraint_error('BEN_ELIG_CMBN_A_S_PK');

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

Line 141: l_api_updating := ben_ecp_shd.api_updating

137: Begin
138: --
139: hr_utility.set_location('Entering:'||l_proc,5);
140: --
141: l_api_updating := ben_ecp_shd.api_updating
142: (p_elig_cmbn_age_los_prte_id => p_elig_cmbn_age_los_prte_id,
143: p_effective_date => p_effective_date,
144: p_object_version_number => p_object_version_number);
145: --

Line 148: <> nvl(ben_ecp_shd.g_old_rec.cmbn_age_los_fctr_id,hr_api.g_number)

144: p_object_version_number => p_object_version_number);
145: --
146: if (l_api_updating
147: and nvl(p_cmbn_age_los_fctr_id,hr_api.g_number)
148: <> nvl(ben_ecp_shd.g_old_rec.cmbn_age_los_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if cmbn_age_los_fctr_id value exists in ben_cmbn_age_los_fctr table
152: --

Line 163: ben_ecp_shd.constraint_error('BEN_ELIG_CMBN_A_S_FK1');

159: --
160: -- raise error as FK does not relate to PK in ben_cmbn_age_los_fctr
161: -- table.
162: --
163: ben_ecp_shd.constraint_error('BEN_ELIG_CMBN_A_S_FK1');
164: --
165: end if;
166: --
167: close c1;

Line 226: l_api_updating := ben_ecp_shd.api_updating

222: Begin
223: --
224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: l_api_updating := ben_ecp_shd.api_updating
227: (p_elig_cmbn_age_los_prte_id => p_elig_cmbn_age_los_prte_id,
228: p_effective_date => p_effective_date,
229: p_object_version_number => p_object_version_number);
230: --

Line 233: <> nvl(ben_ecp_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating
232: and p_mndtry_flag
233: <> nvl(ben_ecp_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)
234: or not l_api_updating) then
235: --
236: -- check if value of lookup falls within lookup type.
237: --

Line 295: l_api_updating := ben_ecp_shd.api_updating

291: Begin
292: --
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: l_api_updating := ben_ecp_shd.api_updating
296: (p_elig_cmbn_age_los_prte_id => p_elig_cmbn_age_los_prte_id,
297: p_effective_date => p_effective_date,
298: p_object_version_number => p_object_version_number);
299: --

Line 302: <> nvl(ben_ecp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

298: p_object_version_number => p_object_version_number);
299: --
300: if (l_api_updating
301: and p_excld_flag
302: <> nvl(ben_ecp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
303: or not l_api_updating) then
304: --
305: -- check if value of lookup falls within lookup type.
306: --

Line 590: (p_rec in ben_ecp_shd.g_rec_type,

586: -- ----------------------------------------------------------------------------
587: -- |---------------------------< insert_validate >----------------------------|
588: -- ----------------------------------------------------------------------------
589: Procedure insert_validate
590: (p_rec in ben_ecp_shd.g_rec_type,
591: p_effective_date in date,
592: p_datetrack_mode in varchar2,
593: p_validation_start_date in date,
594: p_validation_end_date in date) is

Line 646: (p_rec in ben_ecp_shd.g_rec_type,

642: -- ----------------------------------------------------------------------------
643: -- |---------------------------< update_validate >----------------------------|
644: -- ----------------------------------------------------------------------------
645: Procedure update_validate
646: (p_rec in ben_ecp_shd.g_rec_type,
647: p_effective_date in date,
648: p_datetrack_mode in varchar2,
649: p_validation_start_date in date,
650: p_validation_end_date in date) is

Line 710: (p_rec in ben_ecp_shd.g_rec_type,

706: -- ----------------------------------------------------------------------------
707: -- |---------------------------< delete_validate >----------------------------|
708: -- ----------------------------------------------------------------------------
709: Procedure delete_validate
710: (p_rec in ben_ecp_shd.g_rec_type,
711: p_effective_date in date,
712: p_datetrack_mode in varchar2,
713: p_validation_start_date in date,
714: p_validation_end_date in date) is