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_XCT_BUS dependencies on BEN_XCT_SHD

Line 155: l_api_updating := ben_xct_shd.api_updating

151: Begin
152: --
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: l_api_updating := ben_xct_shd.api_updating
156: (p_ext_crit_typ_id => p_ext_crit_typ_id,
157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating

Line 161: <> ben_xct_shd.g_old_rec.ext_crit_typ_id) then

157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating
160: and nvl(p_ext_crit_typ_id,hr_api.g_number)
161: <> ben_xct_shd.g_old_rec.ext_crit_typ_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_PK');

Line 165: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_PK');

161: <> ben_xct_shd.g_old_rec.ext_crit_typ_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_PK');
166: --
167: elsif not l_api_updating then
168: --
169: -- check if PK is null

Line 175: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_PK');

171: if p_ext_crit_typ_id is not null then
172: --
173: -- raise error as PK is not null
174: --
175: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_PK');
176: --
177: end if;
178: --
179: end if;

Line 227: l_api_updating := ben_xct_shd.api_updating

223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc,5);
226: --
227: l_api_updating := ben_xct_shd.api_updating
228: (p_ext_crit_typ_id => p_ext_crit_typ_id,
229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating

Line 233: <> nvl(ben_xct_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)

229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating
232: and nvl(p_ext_crit_prfl_id,hr_api.g_number)
233: <> nvl(ben_xct_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_crit_prfl_id value exists in ben_ext_crit_prfl table
237: --

Line 248: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_FK1');

244: --
245: -- raise error as FK does not relate to PK in ben_ext_crit_prfl
246: -- table.
247: --
248: ben_xct_shd.constraint_error('BEN_EXT_CRIT_TYP_FK1');
249: --
250: end if;
251: --
252: close c1;

Line 299: l_api_updating := ben_xct_shd.api_updating

295: Begin
296: --
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: l_api_updating := ben_xct_shd.api_updating
300: (p_ext_crit_typ_id => p_ext_crit_typ_id,
301: p_object_version_number => p_object_version_number);
302: --
303: if p_crit_typ_cd is null then

Line 310: <> nvl(ben_xct_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)

306: end if;
307: --
308: if (l_api_updating
309: and p_crit_typ_cd
310: <> nvl(ben_xct_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)
311: or not l_api_updating)
312: and p_crit_typ_cd is not null then
313: --
314: -- check if value of lookup falls within lookup type.

Line 403: l_api_updating := ben_xct_shd.api_updating

399: Begin
400: --
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: l_api_updating := ben_xct_shd.api_updating
404: (p_ext_crit_typ_id => p_ext_crit_typ_id,
405: p_object_version_number => p_object_version_number);
406: --
407: -- on perform this edit if updating, and if value has changed.

Line 410: <> nvl(ben_xct_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)) then

406: --
407: -- on perform this edit if updating, and if value has changed.
408: --
409: if (l_api_updating and p_crit_typ_cd
410: <> nvl(ben_xct_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)) then
411: --
412: -- error if child records exist
413: --
414: open c1;

Line 527: l_api_updating := ben_xct_shd.api_updating

523: --
524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: --
527: l_api_updating := ben_xct_shd.api_updating
528: (p_ext_crit_typ_id => p_ext_crit_typ_id,
529: p_object_version_number => p_object_version_number);
530: --
531: -- ensure that excld_flag is not null

Line 542: <> nvl(ben_xct_shd.g_old_rec.excld_flag, hr_api.g_varchar2)

538: -- ensure that the excld_flag has a valid value
539: --
540: if (l_api_updating
541: and p_excld_flag
542: <> nvl(ben_xct_shd.g_old_rec.excld_flag, hr_api.g_varchar2)
543: or not l_api_updating)
544: and p_excld_flag is not null then
545: --
546: -- check if the value is present for the lookup type

Line 588: Procedure insert_validate(p_rec in ben_xct_shd.g_rec_type

584: --
585: -- ----------------------------------------------------------------------------
586: -- |---------------------------< insert_validate >----------------------------|
587: -- ----------------------------------------------------------------------------
588: Procedure insert_validate(p_rec in ben_xct_shd.g_rec_type
589: ,p_effective_date in date) is
590: --
591: l_proc varchar2(72) := g_package||'insert_validate';
592: --

Line 642: Procedure update_validate(p_rec in ben_xct_shd.g_rec_type

638: --
639: -- ----------------------------------------------------------------------------
640: -- |---------------------------< update_validate >----------------------------|
641: -- ----------------------------------------------------------------------------
642: Procedure update_validate(p_rec in ben_xct_shd.g_rec_type
643: ,p_effective_date in date) is
644: --
645: l_proc varchar2(72) := g_package||'update_validate';
646: --

Line 702: Procedure delete_validate(p_rec in ben_xct_shd.g_rec_type

698: --
699: -- ----------------------------------------------------------------------------
700: -- |---------------------------< delete_validate >----------------------------|
701: -- ----------------------------------------------------------------------------
702: Procedure delete_validate(p_rec in ben_xct_shd.g_rec_type
703: ,p_effective_date in date) is
704: --
705: l_proc varchar2(72) := g_package||'delete_validate';
706: --

Line 713: ,ben_xct_shd.g_old_rec.business_group_id

709: --
710: -- Call all supporting business operations
711: --
712: chk_startup_action(False
713: ,ben_xct_shd.g_old_rec.business_group_id
714: ,ben_xct_shd.g_old_rec.legislation_code);
715: --
716: hr_utility.set_location(' Leaving:'||l_proc, 10);
717: End delete_validate;

Line 714: ,ben_xct_shd.g_old_rec.legislation_code);

710: -- Call all supporting business operations
711: --
712: chk_startup_action(False
713: ,ben_xct_shd.g_old_rec.business_group_id
714: ,ben_xct_shd.g_old_rec.legislation_code);
715: --
716: hr_utility.set_location(' Leaving:'||l_proc, 10);
717: End delete_validate;
718: --