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_ETP_BUS dependencies on BEN_ETP_SHD

Line 48: l_api_updating := ben_etp_shd.api_updating

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

Line 55: <> ben_etp_shd.g_old_rec.ELIG_TTL_PRTT_PRTE_id) then

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

Line 59: ben_etp_shd.constraint_error('BEN_ELIG_TTL_PRTT_PRTE_PK');

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

Line 69: ben_etp_shd.constraint_error('BEN_ELIG_TTL_PRTT_PRTE_PK');

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

Line 185: l_api_updating := ben_etp_shd.api_updating

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

Line 192: <> ben_etp_shd.g_old_rec.prtt_det_rl

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

Line 261: l_api_updating := ben_etp_shd.api_updating

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

Line 268: <> nvl(ben_etp_shd.g_old_rec.prtt_det_cd,hr_api.g_varchar2)

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

Line 332: l_api_updating := ben_etp_shd.api_updating

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

Line 339: <> nvl(ben_etp_shd.g_old_rec.no_mx_prtt_num_apls_flag,hr_api.g_varchar2)

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

Line 403: l_api_updating := ben_etp_shd.api_updating

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

Line 410: <> nvl(ben_etp_shd.g_old_rec.no_mn_prtt_num_apls_flag,hr_api.g_varchar2)

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

Line 474: l_api_updating := ben_etp_shd.api_updating

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

Line 481: <> nvl(ben_etp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 853: (p_rec in ben_etp_shd.g_rec_type,

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

Line 935: (p_rec in ben_etp_shd.g_rec_type,

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

Line 1025: (p_rec in ben_etp_shd.g_rec_type,

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