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_XCC_BUS dependencies on BEN_XCC_SHD

Line 155: l_api_updating := ben_xcc_shd.api_updating

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

Line 161: <> ben_xcc_shd.g_old_rec.ext_crit_cmbn_id) then

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

Line 165: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_PK');

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

Line 175: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_PK');

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

Line 227: l_api_updating := ben_xcc_shd.api_updating

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

Line 233: <> nvl(ben_xcc_shd.g_old_rec.ext_crit_val_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_val_id,hr_api.g_number)
233: <> nvl(ben_xcc_shd.g_old_rec.ext_crit_val_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_crit_val_id value exists in ben_ext_crit_val table
237: --

Line 248: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_FK1');

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

Line 299: l_api_updating := ben_xcc_shd.api_updating

295: Begin
296: --
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: l_api_updating := ben_xcc_shd.api_updating
300: (p_ext_crit_cmbn_id => p_ext_crit_cmbn_id,
301: p_object_version_number => p_object_version_number);
302: --
303: if (l_api_updating

Line 305: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)

301: p_object_version_number => p_object_version_number);
302: --
303: if (l_api_updating
304: and p_oper_cd
305: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
306: or not l_api_updating) then
307: --
308: -- check if value of lookup falls within lookup type.
309: --

Line 387: l_api_updating := ben_xcc_shd.api_updating

383: Begin
384: --
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: l_api_updating := ben_xcc_shd.api_updating
388: (p_ext_crit_cmbn_id => p_ext_crit_cmbn_id,
389: p_object_version_number => p_object_version_number);
390: --
391: if (l_api_updating

Line 393: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)

389: p_object_version_number => p_object_version_number);
390: --
391: if (l_api_updating
392: and p_crit_typ_cd
393: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)
394: or not l_api_updating) then
395: --
396: -- check if value of lookup falls within lookup type.
397: --

Line 486: l_api_updating := ben_xcc_shd.api_updating

482: Begin
483: --
484: hr_utility.set_location('Entering:'||l_proc, 5);
485: --
486: l_api_updating := ben_xcc_shd.api_updating
487: (p_ext_crit_cmbn_id => p_ext_crit_cmbn_id,
488: p_object_version_number => p_object_version_number);
489: --
490: if (l_api_updating

Line 492: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)

488: p_object_version_number => p_object_version_number);
489: --
490: if (l_api_updating
491: and (p_oper_cd
492: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
493: or p_crit_typ_cd
494: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd, hr_api.g_varchar2)
495: )
496: or not l_api_updating) then

Line 494: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd, hr_api.g_varchar2)

490: if (l_api_updating
491: and (p_oper_cd
492: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
493: or p_crit_typ_cd
494: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd, hr_api.g_varchar2)
495: )
496: or not l_api_updating) then
497: --
498: -- check if criteria is date then operator is '=' or 'between'

Line 575: l_api_updating := ben_xcc_shd.api_updating

571: Begin
572: --
573: hr_utility.set_location('Entering:'||l_proc, 5);
574: --
575: l_api_updating := ben_xcc_shd.api_updating
576: (p_ext_crit_cmbn_id => p_ext_crit_cmbn_id,
577: p_object_version_number => p_object_version_number);
578: --
579: if (l_api_updating

Line 581: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)

577: p_object_version_number => p_object_version_number);
578: --
579: if (l_api_updating
580: and (p_oper_cd
581: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
582: or
583: p_crit_typ_cd
584: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)
585: )

Line 584: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)

580: and (p_oper_cd
581: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2)
582: or
583: p_crit_typ_cd
584: <> nvl(ben_xcc_shd.g_old_rec.crit_typ_cd,hr_api.g_varchar2)
585: )
586: or not l_api_updating) then
587: --
588: -- check if criteria is change event then operator is '=' or '<>'

Line 678: l_api_updating := ben_xcc_shd.api_updating

674: Begin
675: --
676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: l_api_updating := ben_xcc_shd.api_updating
679: (p_ext_crit_cmbn_id => p_ext_crit_cmbn_id,
680: p_object_version_number => p_object_version_number);
681: --
682: if (l_api_updating

Line 684: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))

680: p_object_version_number => p_object_version_number);
681: --
682: if (l_api_updating
683: and ((p_oper_cd
684: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
685: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
686: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
687: ))
688: or not l_api_updating then

Line 685: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))

681: --
682: if (l_api_updating
683: and ((p_oper_cd
684: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
685: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
686: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
687: ))
688: or not l_api_updating then
689: --

Line 686: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))

682: if (l_api_updating
683: and ((p_oper_cd
684: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
685: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
686: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
687: ))
688: or not l_api_updating then
689: --
690: -- check if operator is between then val_1 and val_2 are not null

Line 751: l_api_updating := ben_xcc_shd.api_updating

747: Begin
748: --
749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: l_api_updating := ben_xcc_shd.api_updating
752: (p_ext_crit_cmbn_id => p_ext_crit_cmbn_id,
753: p_object_version_number => p_object_version_number);
754: --
755: if (l_api_updating

Line 757: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))

753: p_object_version_number => p_object_version_number);
754: --
755: if (l_api_updating
756: and ((p_oper_cd
757: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
758: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
759: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
760: ))
761: or not l_api_updating then

Line 758: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))

754: --
755: if (l_api_updating
756: and ((p_oper_cd
757: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
758: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
759: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
760: ))
761: or not l_api_updating then
762: --

Line 759: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))

755: if (l_api_updating
756: and ((p_oper_cd
757: <> nvl(ben_xcc_shd.g_old_rec.oper_cd,hr_api.g_varchar2))
758: or (p_val_1 <> nvl(ben_xcc_shd.g_old_rec.val_1, hr_api.g_varchar2))
759: or (p_val_2 <> nvl(ben_xcc_shd.g_old_rec.val_2, hr_api.g_varchar2))
760: ))
761: or not l_api_updating then
762: --
763: -- check if operator is between then val_1 and val_2 are not null

Line 783: Procedure insert_validate(p_rec in ben_xcc_shd.g_rec_type

779: --
780: -- ----------------------------------------------------------------------------
781: -- |---------------------------< insert_validate >----------------------------|
782: -- ----------------------------------------------------------------------------
783: Procedure insert_validate(p_rec in ben_xcc_shd.g_rec_type
784: ,p_effective_date in date) is
785: --
786: l_proc varchar2(72) := g_package||'insert_validate';
787: --

Line 860: Procedure update_validate(p_rec in ben_xcc_shd.g_rec_type

856: --
857: -- ----------------------------------------------------------------------------
858: -- |---------------------------< update_validate >----------------------------|
859: -- ----------------------------------------------------------------------------
860: Procedure update_validate(p_rec in ben_xcc_shd.g_rec_type
861: ,p_effective_date in date) is
862: --
863: l_proc varchar2(72) := g_package||'update_validate';
864: --

Line 938: Procedure delete_validate(p_rec in ben_xcc_shd.g_rec_type

934: --
935: -- ----------------------------------------------------------------------------
936: -- |---------------------------< delete_validate >----------------------------|
937: -- ----------------------------------------------------------------------------
938: Procedure delete_validate(p_rec in ben_xcc_shd.g_rec_type
939: ,p_effective_date in date) is
940: --
941: l_proc varchar2(72) := g_package||'delete_validate';
942: --

Line 949: ,ben_xcc_shd.g_old_rec.business_group_id

945: --
946: -- Call all supporting business operations
947: --
948: chk_startup_action(False
949: ,ben_xcc_shd.g_old_rec.business_group_id
950: ,ben_xcc_shd.g_old_rec.legislation_code);
951: hr_utility.set_location(' Leaving:'||l_proc, 10);
952: End delete_validate;
953: --

Line 950: ,ben_xcc_shd.g_old_rec.legislation_code);

946: -- Call all supporting business operations
947: --
948: chk_startup_action(False
949: ,ben_xcc_shd.g_old_rec.business_group_id
950: ,ben_xcc_shd.g_old_rec.legislation_code);
951: hr_utility.set_location(' Leaving:'||l_proc, 10);
952: End delete_validate;
953: --
954: --