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_DDR_BUS dependencies on BEN_DDR_SHD

Line 48: l_api_updating := ben_ddr_shd.api_updating

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

Line 55: <> ben_ddr_shd.g_old_rec.dsgn_rqmt_id) then

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

Line 59: ben_ddr_shd.constraint_error('BEN_DSGN_RQMT_PK');

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

Line 69: ben_ddr_shd.constraint_error('BEN_DSGN_RQMT_PK');

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

Line 117: l_api_updating := ben_ddr_shd.api_updating

113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_ddr_shd.api_updating
118: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
119: p_effective_date => p_effective_date,
120: p_object_version_number => p_object_version_number);
121: --

Line 124: <> nvl(ben_ddr_shd.g_old_rec.dsgn_typ_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_dsgn_typ_cd
124: <> nvl(ben_ddr_shd.g_old_rec.dsgn_typ_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_dsgn_typ_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 195: l_api_updating := ben_ddr_shd.api_updating

191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: --
194:
195: l_api_updating := ben_ddr_shd.api_updating
196: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
197: p_effective_date => p_effective_date,
198: p_object_version_number => p_object_version_number);
199: --

Line 263: l_api_updating := ben_ddr_shd.api_updating

259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: --
262:
263: l_api_updating := ben_ddr_shd.api_updating
264: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
265: p_effective_date => p_effective_date,
266: p_object_version_number => p_object_version_number);
267: --

Line 323: l_api_updating := ben_ddr_shd.api_updating

319: Begin
320: --
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: l_api_updating := ben_ddr_shd.api_updating
324: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
325: p_effective_date => p_effective_date,
326: p_object_version_number => p_object_version_number);
327: --

Line 330: <> nvl(ben_ddr_shd.g_old_rec.cvr_all_elig_flag,hr_api.g_varchar2)

326: p_object_version_number => p_object_version_number);
327: --
328: if (l_api_updating
329: and p_cvr_all_elig_flag
330: <> nvl(ben_ddr_shd.g_old_rec.cvr_all_elig_flag,hr_api.g_varchar2)
331: or not l_api_updating) then
332: --
333: -- check if value of lookup falls within lookup type.
334: --

Line 392: l_api_updating := ben_ddr_shd.api_updating

388: Begin
389: --
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: l_api_updating := ben_ddr_shd.api_updating
393: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
394: p_effective_date => p_effective_date,
395: p_object_version_number => p_object_version_number);
396: --

Line 399: <> nvl(ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag,hr_api.g_varchar2)

395: p_object_version_number => p_object_version_number);
396: --
397: if (l_api_updating
398: and p_no_mx_num_dfnd_flag
399: <> nvl(ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag,hr_api.g_varchar2)
400: or not l_api_updating) then
401: --
402: -- check if value of lookup falls within lookup type.
403: --

Line 461: l_api_updating := ben_ddr_shd.api_updating

457: Begin
458: --
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: l_api_updating := ben_ddr_shd.api_updating
462: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
463: p_effective_date => p_effective_date,
464: p_object_version_number => p_object_version_number);
465: --

Line 468: <> nvl(ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag,hr_api.g_varchar2)

464: p_object_version_number => p_object_version_number);
465: --
466: if (l_api_updating
467: and p_no_mn_num_dfnd_flag
468: <> nvl(ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag,hr_api.g_varchar2)
469: or not l_api_updating) then
470: --
471: -- check if value of lookup falls within lookup type.
472: --

Line 530: l_api_updating := ben_ddr_shd.api_updating

526: Begin
527: --
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: l_api_updating := ben_ddr_shd.api_updating
531: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
532: p_effective_date => p_effective_date,
533: p_object_version_number => p_object_version_number);
534: --

Line 537: <> nvl(ben_ddr_shd.g_old_rec.grp_rlshp_cd,hr_api.g_varchar2)

533: p_object_version_number => p_object_version_number);
534: --
535: if (l_api_updating
536: and p_grp_rlshp_cd
537: <> nvl(ben_ddr_shd.g_old_rec.grp_rlshp_cd,hr_api.g_varchar2)
538: or not l_api_updating)
539: and p_grp_rlshp_cd is not null then
540: --
541: -- check if value of lookup falls within lookup type.

Line 620: l_api_updating := ben_ddr_shd.api_updating

616: Begin
617: --
618: hr_utility.set_location('Entering:'||l_proc, 5);
619: --
620: l_api_updating := ben_ddr_shd.api_updating
621: (p_dsgn_rqmt_id => p_dsgn_rqmt_id,
622: p_effective_date => p_effective_date,
623: p_object_version_number => p_object_version_number);
624: --

Line 978: (p_rec in ben_ddr_shd.g_rec_type,

974: -- ----------------------------------------------------------------------------
975: -- |---------------------------< insert_validate >----------------------------|
976: -- ----------------------------------------------------------------------------
977: Procedure insert_validate
978: (p_rec in ben_ddr_shd.g_rec_type,
979: p_effective_date in date,
980: p_datetrack_mode in varchar2,
981: p_validation_start_date in date,
982: p_validation_end_date in date) is

Line 1072: (p_rec in ben_ddr_shd.g_rec_type,

1068: -- ----------------------------------------------------------------------------
1069: -- |---------------------------< update_validate >----------------------------|
1070: -- ----------------------------------------------------------------------------
1071: Procedure update_validate
1072: (p_rec in ben_ddr_shd.g_rec_type,
1073: p_effective_date in date,
1074: p_datetrack_mode in varchar2,
1075: p_validation_start_date in date,
1076: p_validation_end_date in date) is

Line 1175: (p_rec in ben_ddr_shd.g_rec_type,

1171: -- ----------------------------------------------------------------------------
1172: -- |---------------------------< delete_validate >----------------------------|
1173: -- ----------------------------------------------------------------------------
1174: Procedure delete_validate
1175: (p_rec in ben_ddr_shd.g_rec_type,
1176: p_effective_date in date,
1177: p_datetrack_mode in varchar2,
1178: p_validation_start_date in date,
1179: p_validation_end_date in date) is