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_ETC_BUS dependencies on BEN_ETC_SHD

Line 48: l_api_updating := ben_etc_shd.api_updating

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

Line 55: <> ben_etc_shd.g_old_rec.elig_ttl_cvg_vol_prte_id) then

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

Line 59: ben_etc_shd.constraint_error('BEN_elig_ttl_cvg_vol_prte_PK');

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

Line 69: ben_etc_shd.constraint_error('BEN_elig_ttl_cvg_vol_prte_PK');

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

Line 184: l_api_updating := ben_etc_shd.api_updating

180: Begin
181: --
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: l_api_updating := ben_etc_shd.api_updating
185: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
186: p_effective_date => p_effective_date,
187: p_object_version_number => p_object_version_number);
188: --

Line 191: <> ben_etc_shd.g_old_rec.cvg_vol_det_rl

187: p_object_version_number => p_object_version_number);
188: --
189: if (l_api_updating
190: and nvl(p_cvg_vol_det_rl,hr_api.g_number)
191: <> ben_etc_shd.g_old_rec.cvg_vol_det_rl
192: or not l_api_updating)
193: and p_cvg_vol_det_rl is not null then
194: --
195: -- check if value of formula rule is valid.

Line 260: l_api_updating := ben_etc_shd.api_updating

256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: l_api_updating := ben_etc_shd.api_updating
261: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
262: p_effective_date => p_effective_date,
263: p_object_version_number => p_object_version_number);
264: --

Line 267: <> nvl(ben_etc_shd.g_old_rec.cvg_vol_det_cd,hr_api.g_varchar2)

263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating
266: and p_cvg_vol_det_cd
267: <> nvl(ben_etc_shd.g_old_rec.cvg_vol_det_cd,hr_api.g_varchar2)
268: or not l_api_updating)
269: and p_cvg_vol_det_cd is not null then
270: --
271: -- check if value of lookup falls within lookup type.

Line 331: l_api_updating := ben_etc_shd.api_updating

327: Begin
328: --
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: l_api_updating := ben_etc_shd.api_updating
332: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
333: p_effective_date => p_effective_date,
334: p_object_version_number => p_object_version_number);
335: --

Line 338: <> nvl(ben_etc_shd.g_old_rec.no_mx_cvg_vol_amt_apls_flag,hr_api.g_varchar2)

334: p_object_version_number => p_object_version_number);
335: --
336: if (l_api_updating
337: and p_no_mx_cvg_vol_amt_apls_flag
338: <> nvl(ben_etc_shd.g_old_rec.no_mx_cvg_vol_amt_apls_flag,hr_api.g_varchar2)
339: or not l_api_updating) then
340: --
341: -- check if value of lookup falls within lookup type.
342: --

Line 402: l_api_updating := ben_etc_shd.api_updating

398: Begin
399: --
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: --
402: l_api_updating := ben_etc_shd.api_updating
403: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
404: p_effective_date => p_effective_date,
405: p_object_version_number => p_object_version_number);
406: --

Line 409: <> nvl(ben_etc_shd.g_old_rec.no_mn_cvg_vol_amt_apls_flag,hr_api.g_varchar2)

405: p_object_version_number => p_object_version_number);
406: --
407: if (l_api_updating
408: and p_no_mn_cvg_vol_amt_apls_flag
409: <> nvl(ben_etc_shd.g_old_rec.no_mn_cvg_vol_amt_apls_flag,hr_api.g_varchar2)
410: or not l_api_updating) then
411: --
412: -- check if value of lookup falls within lookup type.
413: --

Line 473: l_api_updating := ben_etc_shd.api_updating

469: Begin
470: --
471: hr_utility.set_location('Entering:'||l_proc, 5);
472: --
473: l_api_updating := ben_etc_shd.api_updating
474: (p_elig_ttl_cvg_vol_prte_id => p_elig_ttl_cvg_vol_prte_id,
475: p_effective_date => p_effective_date,
476: p_object_version_number => p_object_version_number);
477: --

Line 480: <> nvl(ben_etc_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

476: p_object_version_number => p_object_version_number);
477: --
478: if (l_api_updating
479: and p_excld_flag
480: <> nvl(ben_etc_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
481: or not l_api_updating) then
482: --
483: -- check if value of lookup falls within lookup type.
484: --

Line 854: (p_rec in ben_etc_shd.g_rec_type,

850: -- ----------------------------------------------------------------------------
851: -- |---------------------------< insert_validate >----------------------------|
852: -- ----------------------------------------------------------------------------
853: Procedure insert_validate
854: (p_rec in ben_etc_shd.g_rec_type,
855: p_effective_date in date,
856: p_datetrack_mode in varchar2,
857: p_validation_start_date in date,
858: p_validation_end_date in date) is

Line 936: (p_rec in ben_etc_shd.g_rec_type,

932: -- ----------------------------------------------------------------------------
933: -- |---------------------------< update_validate >----------------------------|
934: -- ----------------------------------------------------------------------------
935: Procedure update_validate
936: (p_rec in ben_etc_shd.g_rec_type,
937: p_effective_date in date,
938: p_datetrack_mode in varchar2,
939: p_validation_start_date in date,
940: p_validation_end_date in date) is

Line 1026: (p_rec in ben_etc_shd.g_rec_type,

1022: -- ----------------------------------------------------------------------------
1023: -- |---------------------------< delete_validate >----------------------------|
1024: -- ----------------------------------------------------------------------------
1025: Procedure delete_validate
1026: (p_rec in ben_etc_shd.g_rec_type,
1027: p_effective_date in date,
1028: p_datetrack_mode in varchar2,
1029: p_validation_start_date in date,
1030: p_validation_end_date in date) is