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_TCV_BUS dependencies on BEN_TCV_SHD

Line 48: l_api_updating := ben_tcv_shd.api_updating

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

Line 55: <> ben_tcv_shd.g_old_rec.ttl_cvg_vol_rt_id) then

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

Line 59: ben_tcv_shd.constraint_error('BEN_TTL_CVG_VOL_RT_PK');

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

Line 69: ben_tcv_shd.constraint_error('BEN_TTL_CVG_VOL_RT_PK');

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

Line 260: l_api_updating := ben_tcv_shd.api_updating

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

Line 267: <> ben_tcv_shd.g_old_rec.cvg_vol_det_rl

263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating
266: and nvl(p_cvg_vol_det_rl,hr_api.g_number)
267: <> ben_tcv_shd.g_old_rec.cvg_vol_det_rl
268: or not l_api_updating)
269: and p_cvg_vol_det_rl is not null then
270: --
271: -- check if value of formula rule is valid.

Line 336: l_api_updating := ben_tcv_shd.api_updating

332: Begin
333: --
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: l_api_updating := ben_tcv_shd.api_updating
337: (p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_id,
338: p_effective_date => p_effective_date,
339: p_object_version_number => p_object_version_number);
340: --

Line 343: <> nvl(ben_tcv_shd.g_old_rec.cvg_vol_det_cd,hr_api.g_varchar2)

339: p_object_version_number => p_object_version_number);
340: --
341: if (l_api_updating
342: and p_cvg_vol_det_cd
343: <> nvl(ben_tcv_shd.g_old_rec.cvg_vol_det_cd,hr_api.g_varchar2)
344: or not l_api_updating)
345: and p_cvg_vol_det_cd is not null then
346: --
347: -- check if value of lookup falls within lookup type.

Line 407: l_api_updating := ben_tcv_shd.api_updating

403: Begin
404: --
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: l_api_updating := ben_tcv_shd.api_updating
408: (p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_id,
409: p_effective_date => p_effective_date,
410: p_object_version_number => p_object_version_number);
411: --

Line 414: <> nvl(ben_tcv_shd.g_old_rec.no_mx_cvg_vol_amt_apls_flag,hr_api.g_varchar2)

410: p_object_version_number => p_object_version_number);
411: --
412: if (l_api_updating
413: and p_no_mx_cvg_vol_amt_apls_flag
414: <> nvl(ben_tcv_shd.g_old_rec.no_mx_cvg_vol_amt_apls_flag,hr_api.g_varchar2)
415: or not l_api_updating) then
416: --
417: -- check if value of lookup falls within lookup type.
418: --

Line 478: l_api_updating := ben_tcv_shd.api_updating

474: Begin
475: --
476: hr_utility.set_location('Entering:'||l_proc, 5);
477: --
478: l_api_updating := ben_tcv_shd.api_updating
479: (p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_id,
480: p_effective_date => p_effective_date,
481: p_object_version_number => p_object_version_number);
482: --

Line 485: <> nvl(ben_tcv_shd.g_old_rec.no_mn_cvg_vol_amt_apls_flag,hr_api.g_varchar2)

481: p_object_version_number => p_object_version_number);
482: --
483: if (l_api_updating
484: and p_no_mn_cvg_vol_amt_apls_flag
485: <> nvl(ben_tcv_shd.g_old_rec.no_mn_cvg_vol_amt_apls_flag,hr_api.g_varchar2)
486: or not l_api_updating) then
487: --
488: -- check if value of lookup falls within lookup type.
489: --

Line 549: l_api_updating := ben_tcv_shd.api_updating

545: Begin
546: --
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: l_api_updating := ben_tcv_shd.api_updating
550: (p_ttl_cvg_vol_rt_id => p_ttl_cvg_vol_rt_id,
551: p_effective_date => p_effective_date,
552: p_object_version_number => p_object_version_number);
553: --

Line 556: <> nvl(ben_tcv_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

552: p_object_version_number => p_object_version_number);
553: --
554: if (l_api_updating
555: and p_excld_flag
556: <> nvl(ben_tcv_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
557: or not l_api_updating) then
558: --
559: -- check if value of lookup falls within lookup type.
560: --

Line 1053: (p_rec in ben_tcv_shd.g_rec_type,

1049: -- ----------------------------------------------------------------------------
1050: -- |---------------------------< insert_validate >----------------------------|
1051: -- ----------------------------------------------------------------------------
1052: Procedure insert_validate
1053: (p_rec in ben_tcv_shd.g_rec_type,
1054: p_effective_date in date,
1055: p_datetrack_mode in varchar2,
1056: p_validation_start_date in date,
1057: p_validation_end_date in date) is

Line 1152: (p_rec in ben_tcv_shd.g_rec_type,

1148: -- ----------------------------------------------------------------------------
1149: -- |---------------------------< update_validate >----------------------------|
1150: -- ----------------------------------------------------------------------------
1151: Procedure update_validate
1152: (p_rec in ben_tcv_shd.g_rec_type,
1153: p_effective_date in date,
1154: p_datetrack_mode in varchar2,
1155: p_validation_start_date in date,
1156: p_validation_end_date in date) is

Line 1259: (p_rec in ben_tcv_shd.g_rec_type,

1255: -- ----------------------------------------------------------------------------
1256: -- |---------------------------< delete_validate >----------------------------|
1257: -- ----------------------------------------------------------------------------
1258: Procedure delete_validate
1259: (p_rec in ben_tcv_shd.g_rec_type,
1260: p_effective_date in date,
1261: p_datetrack_mode in varchar2,
1262: p_validation_start_date in date,
1263: p_validation_end_date in date) is