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_XER_BUS dependencies on BEN_XER_SHD

Line 107: l_api_updating := ben_xer_shd.api_updating

103: Begin
104: --
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: l_api_updating := ben_xer_shd.api_updating
108: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
109: p_object_version_number => p_object_version_number);
110: --
111: if (l_api_updating

Line 113: <> ben_xer_shd.g_old_rec.ext_data_elmt_in_rcd_id) then

109: p_object_version_number => p_object_version_number);
110: --
111: if (l_api_updating
112: and nvl(p_ext_data_elmt_in_rcd_id,hr_api.g_number)
113: <> ben_xer_shd.g_old_rec.ext_data_elmt_in_rcd_id) then
114: --
115: -- raise error as PK has changed
116: --
117: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_PK');

Line 117: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_PK');

113: <> ben_xer_shd.g_old_rec.ext_data_elmt_in_rcd_id) then
114: --
115: -- raise error as PK has changed
116: --
117: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_PK');
118: --
119: elsif not l_api_updating then
120: --
121: -- check if PK is null

Line 127: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_PK');

123: if p_ext_data_elmt_in_rcd_id is not null then
124: --
125: -- raise error as PK is not null
126: --
127: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_PK');
128: --
129: end if;
130: --
131: end if;

Line 179: l_api_updating := ben_xer_shd.api_updating

175: Begin
176: --
177: hr_utility.set_location('Entering:'||l_proc,5);
178: --
179: l_api_updating := ben_xer_shd.api_updating
180: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
181: p_object_version_number => p_object_version_number);
182: --
183: if (l_api_updating

Line 185: <> nvl(ben_xer_shd.g_old_rec.ext_rcd_id,hr_api.g_number)

181: p_object_version_number => p_object_version_number);
182: --
183: if (l_api_updating
184: and nvl(p_ext_rcd_id,hr_api.g_number)
185: <> nvl(ben_xer_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
186: or not l_api_updating) then
187: --
188: -- check if ext_rcd_id value exists in ben_ext_rcd table
189: --

Line 200: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_FK2');

196: --
197: -- raise error as FK does not relate to PK in ben_ext_rcd
198: -- table.
199: --
200: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_FK2');
201: --
202: end if;
203: --
204: close c1;

Line 254: l_api_updating := ben_xer_shd.api_updating

250: Begin
251: --
252: hr_utility.set_location('Entering:'||l_proc,5);
253: --
254: l_api_updating := ben_xer_shd.api_updating
255: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
256: p_object_version_number => p_object_version_number);
257: --
258: if (l_api_updating

Line 260: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)

256: p_object_version_number => p_object_version_number);
257: --
258: if (l_api_updating
259: and nvl(p_ext_data_elmt_id,hr_api.g_number)
260: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
261: or not l_api_updating) then
262: --
263: -- check if ext_data_elmt_id value exists in ben_ext_data_elmt table
264: --

Line 275: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_FK1');

271: --
272: -- raise error as FK does not relate to PK in ben_ext_data_elmt
273: -- table.
274: --
275: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_FK1');
276: --
277: end if;
278: --
279: close c1;

Line 491: l_api_updating := ben_xer_shd.api_updating

487: Begin
488: --
489: hr_utility.set_location('Entering:'||l_proc, 5);
490: --
491: l_api_updating := ben_xer_shd.api_updating
492: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
493: p_object_version_number => p_object_version_number);
494: --
495: if (l_api_updating

Line 497: <> nvl(ben_xer_shd.g_old_rec.sprs_cd,hr_api.g_varchar2)

493: p_object_version_number => p_object_version_number);
494: --
495: if (l_api_updating
496: and p_sprs_cd
497: <> nvl(ben_xer_shd.g_old_rec.sprs_cd,hr_api.g_varchar2)
498: or not l_api_updating)
499: and p_sprs_cd is not null then
500: --
501: -- check if value of lookup falls within lookup type.

Line 582: l_api_updating := ben_xer_shd.api_updating

578: Begin
579: --
580: hr_utility.set_location('Entering:'||l_proc, 5);
581: --
582: l_api_updating := ben_xer_shd.api_updating
583: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
584: p_object_version_number => p_object_version_number);
585: --
586: if (l_api_updating

Line 588: <> nvl(ben_xer_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

584: p_object_version_number => p_object_version_number);
585: --
586: if (l_api_updating
587: and p_rqd_flag
588: <> nvl(ben_xer_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
589: or not l_api_updating) then
590: --
591: -- check if value of lookup falls within lookup type.
592: --

Line 672: l_api_updating := ben_xer_shd.api_updating

668: Begin
669: --
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: l_api_updating := ben_xer_shd.api_updating
673: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
674: p_object_version_number => p_object_version_number);
675: --
676: if (l_api_updating

Line 678: <> nvl(ben_xer_shd.g_old_rec.any_or_all_cd,hr_api.g_varchar2)

674: p_object_version_number => p_object_version_number);
675: --
676: if (l_api_updating
677: and p_any_or_all_cd
678: <> nvl(ben_xer_shd.g_old_rec.any_or_all_cd,hr_api.g_varchar2)
679: or not l_api_updating)
680: and p_any_or_all_cd is not null then
681: --
682: -- check if value of lookup falls within lookup type.

Line 760: l_api_updating := ben_xer_shd.api_updating

756: Begin
757: --
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: l_api_updating := ben_xer_shd.api_updating
761: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
762: p_object_version_number => p_object_version_number);
763: --
764: if (l_api_updating

Line 766: <> nvl(ben_xer_shd.g_old_rec.hide_flag,hr_api.g_varchar2)

762: p_object_version_number => p_object_version_number);
763: --
764: if (l_api_updating
765: and p_hide_flag
766: <> nvl(ben_xer_shd.g_old_rec.hide_flag,hr_api.g_varchar2)
767: or not l_api_updating) then
768: --
769: -- check if value of lookup falls within lookup type.
770: --

Line 900: l_api_updating := ben_xer_shd.api_updating

896: Begin
897: --
898: hr_utility.set_location('Entering:'||l_proc, 5);
899: --
900: l_api_updating := ben_xer_shd.api_updating
901: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
902: p_object_version_number => p_object_version_number);
903: --
904: if (l_api_updating

Line 906: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)

902: p_object_version_number => p_object_version_number);
903: --
904: if (l_api_updating
905: and p_ext_data_elmt_id
906: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
907: or not l_api_updating)
908: and p_ext_data_elmt_id is not null then
909: --
910: open c1;

Line 1106: Procedure insert_validate(p_rec in ben_xer_shd.g_rec_type

1102: -- ----------------------------------------------------------------------------
1103: -- ----------------------------------------------------------------------------
1104: -- |---------------------------< insert_validate >----------------------------|
1105: -- ----------------------------------------------------------------------------
1106: Procedure insert_validate(p_rec in ben_xer_shd.g_rec_type
1107: ,p_effective_date in date) is
1108: --
1109: l_proc varchar2(72) := g_package||'insert_validate';
1110: --

Line 1196: Procedure update_validate(p_rec in ben_xer_shd.g_rec_type

1192: --
1193: -- ----------------------------------------------------------------------------
1194: -- |---------------------------< update_validate >----------------------------|
1195: -- ----------------------------------------------------------------------------
1196: Procedure update_validate(p_rec in ben_xer_shd.g_rec_type
1197: ,p_effective_date in date) is
1198: --
1199: l_proc varchar2(72) := g_package||'update_validate';
1200: --

Line 1286: Procedure delete_validate(p_rec in ben_xer_shd.g_rec_type

1282: --
1283: -- ----------------------------------------------------------------------------
1284: -- |---------------------------< delete_validate >----------------------------|
1285: -- ----------------------------------------------------------------------------
1286: Procedure delete_validate(p_rec in ben_xer_shd.g_rec_type
1287: ,p_effective_date in date) is
1288: --
1289: l_proc varchar2(72) := g_package||'delete_validate';
1290: --

Line 1300: ,ben_xer_shd.g_old_rec.business_group_id

1296: --bug 2804169 -- check if child records exist
1297: chk_child_recs ( p_rec.ext_data_elmt_in_rcd_id);
1298: --
1299: chk_startup_action(False
1300: ,ben_xer_shd.g_old_rec.business_group_id
1301: ,ben_xer_shd.g_old_rec.legislation_code);
1302: --
1303: hr_utility.set_location(' Leaving:'||l_proc, 10);
1304: End delete_validate;

Line 1301: ,ben_xer_shd.g_old_rec.legislation_code);

1297: chk_child_recs ( p_rec.ext_data_elmt_in_rcd_id);
1298: --
1299: chk_startup_action(False
1300: ,ben_xer_shd.g_old_rec.business_group_id
1301: ,ben_xer_shd.g_old_rec.legislation_code);
1302: --
1303: hr_utility.set_location(' Leaving:'||l_proc, 10);
1304: End delete_validate;
1305: --