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_CLF_BUS dependencies on BEN_CLF_SHD

Line 46: l_api_updating := ben_clf_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_clf_shd.api_updating
47: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_clf_shd.g_old_rec.comp_lvl_fctr_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
52: <> ben_clf_shd.g_old_rec.comp_lvl_fctr_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_PK');

Line 56: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_PK');

52: <> ben_clf_shd.g_old_rec.comp_lvl_fctr_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_PK');

62: if p_comp_lvl_fctr_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_PK');
67: --
68: end if;
69: --
70: end if;

Line 121: l_api_updating := ben_clf_shd.api_updating

117: Begin
118: --
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: l_api_updating := ben_clf_shd.api_updating
122: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
123: p_object_version_number => p_object_version_number);
124: --
125: if (l_api_updating

Line 127: <> ben_clf_shd.g_old_rec.defined_balance_id

123: p_object_version_number => p_object_version_number);
124: --
125: if (l_api_updating
126: and nvl(p_defined_balance_id,hr_api.g_number)
127: <> ben_clf_shd.g_old_rec.defined_balance_id
128: or not l_api_updating)
129: and p_defined_balance_id is not null then
130: --
131: -- check if value of defined_balance_id is valid.

Line 140: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_FK2');

136: if c1%notfound then
137: --
138: close c1;
139: --
140: ben_clf_shd.constraint_error('BEN_COMP_LVL_FCTR_FK2');
141: --
142: end if;
143: --
144: close c1;

Line 207: l_api_updating := ben_clf_shd.api_updating

203: Begin
204: --
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: l_api_updating := ben_clf_shd.api_updating
208: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
209: p_object_version_number => p_object_version_number);
210: --
211: if (l_api_updating

Line 213: <> ben_clf_shd.g_old_rec.rndg_rl

209: p_object_version_number => p_object_version_number);
210: --
211: if (l_api_updating
212: and nvl(p_rndg_rl,hr_api.g_number)
213: <> ben_clf_shd.g_old_rec.rndg_rl
214: or not l_api_updating)
215: and p_rndg_rl is not null then
216: --
217: -- check if value of formula rule is valid.

Line 296: l_api_updating := ben_clf_shd.api_updating

292: Begin
293: --
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: l_api_updating := ben_clf_shd.api_updating
297: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
298: p_object_version_number => p_object_version_number);
299: --
300: if (l_api_updating

Line 302: <> nvl(ben_clf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

298: p_object_version_number => p_object_version_number);
299: --
300: if (l_api_updating
301: and p_rndg_cd
302: <> nvl(ben_clf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
303: or not l_api_updating)
304: and p_rndg_cd is not null then
305: --
306: -- check if value of lookup falls within lookup type.

Line 382: l_api_updating := ben_clf_shd.api_updating

378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: l_api_updating := ben_clf_shd.api_updating
383: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
384: p_object_version_number => p_object_version_number);
385: --
386: if (l_api_updating

Line 388: <> ben_clf_shd.g_old_rec.comp_lvl_det_rl

384: p_object_version_number => p_object_version_number);
385: --
386: if (l_api_updating
387: and nvl(p_comp_lvl_det_rl,hr_api.g_number)
388: <> ben_clf_shd.g_old_rec.comp_lvl_det_rl
389: or not l_api_updating)
390: and p_comp_lvl_det_rl is not null then
391: --
392: -- check if value of formula rule is valid.

Line 473: l_api_updating := ben_clf_shd.api_updating

469: Begin
470: --
471: hr_utility.set_location('Entering:'||l_proc, 5);
472: --
473: l_api_updating := ben_clf_shd.api_updating
474: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
475: p_object_version_number => p_object_version_number);
476: --
477: if (l_api_updating

Line 479: <> nvl(ben_clf_shd.g_old_rec.no_mx_comp_flag,hr_api.g_varchar2)

475: p_object_version_number => p_object_version_number);
476: --
477: if (l_api_updating
478: and p_no_mx_comp_flag
479: <> nvl(ben_clf_shd.g_old_rec.no_mx_comp_flag,hr_api.g_varchar2)
480: or not l_api_updating)
481: and p_no_mx_comp_flag is not null then
482: --
483: -- check if value of lookup falls within lookup type.

Line 541: l_api_updating := ben_clf_shd.api_updating

537: Begin
538: --
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: l_api_updating := ben_clf_shd.api_updating
542: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
543: p_object_version_number => p_object_version_number);
544: --
545: if (l_api_updating

Line 547: <> nvl(ben_clf_shd.g_old_rec.no_mn_comp_flag,hr_api.g_varchar2)

543: p_object_version_number => p_object_version_number);
544: --
545: if (l_api_updating
546: and p_no_mn_comp_flag
547: <> nvl(ben_clf_shd.g_old_rec.no_mn_comp_flag,hr_api.g_varchar2)
548: or not l_api_updating)
549: and p_no_mn_comp_flag is not null then
550: --
551: -- check if value of lookup falls within lookup type.

Line 609: l_api_updating := ben_clf_shd.api_updating

605: Begin
606: --
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: --
609: l_api_updating := ben_clf_shd.api_updating
610: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
611: p_object_version_number => p_object_version_number);
612: --
613: if (l_api_updating

Line 615: <> nvl(ben_clf_shd.g_old_rec.comp_src_cd,hr_api.g_varchar2)

611: p_object_version_number => p_object_version_number);
612: --
613: if (l_api_updating
614: and p_comp_src_cd
615: <> nvl(ben_clf_shd.g_old_rec.comp_src_cd,hr_api.g_varchar2)
616: or not l_api_updating)
617: and p_comp_src_cd is not null then
618: --
619: -- check if value of lookup falls within lookup type.

Line 685: l_api_updating := ben_clf_shd.api_updating

681: Begin
682: --
683: hr_utility.set_location('Entering:'||l_proc, 5);
684: --
685: l_api_updating := ben_clf_shd.api_updating
686: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
687: p_object_version_number => p_object_version_number);
688: --
689: if (l_api_updating

Line 691: <> nvl(ben_clf_shd.g_old_rec.comp_lvl_uom,hr_api.g_varchar2)

687: p_object_version_number => p_object_version_number);
688: --
689: if (l_api_updating
690: and p_comp_lvl_uom
691: <> nvl(ben_clf_shd.g_old_rec.comp_lvl_uom,hr_api.g_varchar2)
692: or not l_api_updating)
693: and p_comp_lvl_uom is not null then
694: --
695: -- check if value of lookup falls within fnd_currencies.

Line 765: l_api_updating := ben_clf_shd.api_updating

761: Begin
762: --
763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: l_api_updating := ben_clf_shd.api_updating
766: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
767: p_object_version_number => p_object_version_number);
768: --
769: if (l_api_updating

Line 771: <> nvl(ben_clf_shd.g_old_rec.comp_lvl_det_cd,hr_api.g_varchar2)

767: p_object_version_number => p_object_version_number);
768: --
769: if (l_api_updating
770: and p_comp_lvl_det_cd
771: <> nvl(ben_clf_shd.g_old_rec.comp_lvl_det_cd,hr_api.g_varchar2)
772: or not l_api_updating)
773: and p_comp_lvl_det_cd is not null then
774: --
775: -- check if value of lookup falls within lookup type.

Line 836: l_api_updating := ben_clf_shd.api_updating

832: Begin
833: --
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: l_api_updating := ben_clf_shd.api_updating
837: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
838: p_object_version_number => p_object_version_number);
839: --
840: if (l_api_updating

Line 842: <> nvl(ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd,hr_api.g_varchar2)

838: p_object_version_number => p_object_version_number);
839: --
840: if (l_api_updating
841: and p_sttd_sal_prdcty_cd
842: <> nvl(ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd,hr_api.g_varchar2)
843: or not l_api_updating)
844: and p_sttd_sal_prdcty_cd is not null then
845: --
846: -- check if value of lookup falls within lookup type.

Line 905: l_api_updating := ben_clf_shd.api_updating

901: Begin
902: --
903: hr_utility.set_location('Entering:'||l_proc, 5);
904: --
905: l_api_updating := ben_clf_shd.api_updating
906: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
907: p_object_version_number => p_object_version_number);
908: --
909: if (l_api_updating

Line 911: <> nvl(ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd,hr_api.g_varchar2)

907: p_object_version_number => p_object_version_number);
908: --
909: if (l_api_updating
910: and p_comp_alt_val_to_use_cd
911: <> nvl(ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd,hr_api.g_varchar2)
912: or not l_api_updating)
913: and p_comp_alt_val_to_use_cd is not null then
914: --
915: -- check if value of lookup falls within lookup type.

Line 991: l_api_updating := ben_clf_shd.api_updating

987: Begin
988: --
989: hr_utility.set_location('Entering:'||l_proc, 5);
990: --
991: l_api_updating := ben_clf_shd.api_updating
992: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
993: p_object_version_number => p_object_version_number);
994: --
995: if (l_api_updating

Line 997: <> ben_clf_shd.g_old_rec.comp_calc_rl

993: p_object_version_number => p_object_version_number);
994: --
995: if (l_api_updating
996: and nvl(p_comp_calc_rl,hr_api.g_number)
997: <> ben_clf_shd.g_old_rec.comp_calc_rl
998: or not l_api_updating)
999: and p_comp_calc_rl is not null then
1000: --
1001: -- check if value of formula rule is valid.

Line 1078: l_api_updating := ben_clf_shd.api_updating

1074: Begin
1075: --
1076: hr_utility.set_location('Entering:'||l_proc, 5);
1077: --
1078: l_api_updating := ben_clf_shd.api_updating
1079: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
1080: -- p_effective_date => p_effective_date,
1081: p_object_version_number => p_object_version_number);
1082: --

Line 1085: <> ben_clf_shd.g_old_rec.name

1081: p_object_version_number => p_object_version_number);
1082: --
1083: if (l_api_updating
1084: and nvl(p_name,hr_api.g_varchar2)
1085: <> ben_clf_shd.g_old_rec.name
1086: or not l_api_updating)
1087: and p_name is not null then
1088: --
1089: -- check if name already used.

Line 1190: Procedure chk_date_range(p_clf_rec in ben_clf_shd.g_rec_type) is

1186: --
1187: -- Access Status
1188: -- Internal table handler use only.
1189: --
1190: Procedure chk_date_range(p_clf_rec in ben_clf_shd.g_rec_type) is
1191: --
1192: l_proc varchar2(72) := g_package || 'chk_date_range';
1193: l_start_year varchar2(4) := nvl(p_clf_rec.start_year,'2000');
1194: l_end_year varchar2(4) := nvl(p_clf_rec.end_year,'2000');

Line 1487: Procedure insert_validate(p_rec in ben_clf_shd.g_rec_type

1483:
1484: -- ----------------------------------------------------------------------------
1485: -- |---------------------------< insert_validate >----------------------------|
1486: -- ----------------------------------------------------------------------------
1487: Procedure insert_validate(p_rec in ben_clf_shd.g_rec_type
1488: ,p_effective_date in date) is
1489: --
1490: l_proc varchar2(72) := g_package||'insert_validate';
1491: --

Line 1622: Procedure update_validate(p_rec in ben_clf_shd.g_rec_type

1618: --
1619: -- ----------------------------------------------------------------------------
1620: -- |---------------------------< update_validate >----------------------------|
1621: -- ----------------------------------------------------------------------------
1622: Procedure update_validate(p_rec in ben_clf_shd.g_rec_type
1623: ,p_effective_date in date) is
1624: --
1625: l_proc varchar2(72) := g_package||'update_validate';
1626: --

Line 1759: Procedure delete_validate(p_rec in ben_clf_shd.g_rec_type

1755: --
1756: -- ----------------------------------------------------------------------------
1757: -- |---------------------------< delete_validate >----------------------------|
1758: -- ----------------------------------------------------------------------------
1759: Procedure delete_validate(p_rec in ben_clf_shd.g_rec_type
1760: ,p_effective_date in date) is
1761: --
1762: l_proc varchar2(72) := g_package||'delete_validate';
1763: --