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_BPR_BUS dependencies on HR_API

Line 54: and nvl(p_bnft_pool_rlovr_rqmt_id,hr_api.g_number)

50: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_bnft_pool_rlovr_rqmt_id,hr_api.g_number)
55: <> ben_bpr_shd.g_old_rec.bnft_pool_rlovr_rqmt_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 373: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)

369: p_object_version_number => p_object_version_number);
370: --
371: if (l_api_updating
372: and
373: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
374: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
375: nvl(p_pct_rndg_rl,hr_api.g_number)
376: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
377: or not l_api_updating) then

Line 374: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or

370: --
371: if (l_api_updating
372: and
373: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
374: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
375: nvl(p_pct_rndg_rl,hr_api.g_number)
376: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
377: or not l_api_updating) then
378: --

Line 375: nvl(p_pct_rndg_rl,hr_api.g_number)

371: if (l_api_updating
372: and
373: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
374: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
375: nvl(p_pct_rndg_rl,hr_api.g_number)
376: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
377: or not l_api_updating) then
378: --
379: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then

Line 376: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))

372: and
373: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
374: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
375: nvl(p_pct_rndg_rl,hr_api.g_number)
376: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
377: or not l_api_updating) then
378: --
379: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
380: --

Line 386: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then

382: fnd_message.raise_error;
383: --
384: end if;
385: --
386: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
387: --
388: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
389: fnd_message.raise_error;
390: --

Line 449: (nvl(p_val_rndg_cd,hr_api.g_varchar2)

445: p_object_version_number => p_object_version_number);
446: --
447: if (l_api_updating
448: and
449: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
450: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
451: nvl(p_val_rndg_rl,hr_api.g_number)
452: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
453: or not l_api_updating) then

Line 450: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or

446: --
447: if (l_api_updating
448: and
449: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
450: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
451: nvl(p_val_rndg_rl,hr_api.g_number)
452: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
453: or not l_api_updating) then
454: --

Line 451: nvl(p_val_rndg_rl,hr_api.g_number)

447: if (l_api_updating
448: and
449: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
450: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
451: nvl(p_val_rndg_rl,hr_api.g_number)
452: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
453: or not l_api_updating) then
454: --
455: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then

Line 452: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_rl,hr_api.g_number))

448: and
449: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
450: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
451: nvl(p_val_rndg_rl,hr_api.g_number)
452: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
453: or not l_api_updating) then
454: --
455: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
456: --

Line 462: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then

458: fnd_message.raise_error;
459: --
460: end if;
461: --
462: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
463: --
464: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
465: fnd_message.raise_error;
466: --

Line 520: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2)

516: p_object_version_number => p_object_version_number);
517: --
518: if (l_api_updating
519: and p_pct_rndg_cd
520: <> nvl(ben_bpr_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2)
521: or not l_api_updating)
522: and p_pct_rndg_cd is not null then
523: --
524: -- check if value of lookup falls within lookup type.

Line 526: if hr_api.not_exists_in_hr_lookups

522: and p_pct_rndg_cd is not null then
523: --
524: -- check if value of lookup falls within lookup type.
525: --
526: if hr_api.not_exists_in_hr_lookups
527: (p_lookup_type => 'BEN_RNDG',
528: p_lookup_code => p_pct_rndg_cd,
529: p_effective_date => p_effective_date) then
530: --

Line 607: and nvl(p_val_rndg_rl,hr_api.g_number)

603: p_effective_date => p_effective_date,
604: p_object_version_number => p_object_version_number);
605: --
606: if (l_api_updating
607: and nvl(p_val_rndg_rl,hr_api.g_number)
608: <> ben_bpr_shd.g_old_rec.val_rndg_rl
609: or not l_api_updating)
610: and p_val_rndg_rl is not null then
611: --

Line 686: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2)

682: p_object_version_number => p_object_version_number);
683: --
684: if (l_api_updating
685: and p_val_rndg_cd
686: <> nvl(ben_bpr_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2)
687: or not l_api_updating)
688: and p_val_rndg_cd is not null then
689: --
690: -- check if value of lookup falls within lookup type.

Line 692: if hr_api.not_exists_in_hr_lookups

688: and p_val_rndg_cd is not null then
689: --
690: -- check if value of lookup falls within lookup type.
691: --
692: if hr_api.not_exists_in_hr_lookups
693: (p_lookup_type => 'BEN_RNDG',
694: p_lookup_code => p_val_rndg_cd,
695: p_effective_date => p_effective_date) then
696: --

Line 757: <> nvl(ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag,hr_api.g_varchar2)

753: p_object_version_number => p_object_version_number);
754: --
755: if (l_api_updating
756: and p_no_mx_rlovr_val_dfnd_flag
757: <> nvl(ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag,hr_api.g_varchar2)
758: or not l_api_updating) then
759: --
760: -- check if value of lookup falls within lookup type.
761: --

Line 763: if hr_api.not_exists_in_hr_lookups

759: --
760: -- check if value of lookup falls within lookup type.
761: --
762: --
763: if hr_api.not_exists_in_hr_lookups
764: (p_lookup_type => 'YES_NO',
765: p_lookup_code => p_no_mx_rlovr_val_dfnd_flag,
766: p_effective_date => p_effective_date) then
767: --

Line 842: and nvl(p_rlovr_val_rl,hr_api.g_number)

838: p_effective_date => p_effective_date,
839: p_object_version_number => p_object_version_number);
840: --
841: if (l_api_updating
842: and nvl(p_rlovr_val_rl,hr_api.g_number)
843: <> ben_bpr_shd.g_old_rec.rlovr_val_rl
844: or not l_api_updating)
845: and p_rlovr_val_rl is not null then
846: --

Line 922: <> nvl(ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag,hr_api.g_varchar2)

918: p_object_version_number => p_object_version_number);
919: --
920: if (l_api_updating
921: and p_no_mn_rlovr_val_dfnd_flag
922: <> nvl(ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag,hr_api.g_varchar2)
923: or not l_api_updating) then
924: --
925: -- check if value of lookup falls within lookup type.
926: --

Line 928: if hr_api.not_exists_in_hr_lookups

924: --
925: -- check if value of lookup falls within lookup type.
926: --
927: --
928: if hr_api.not_exists_in_hr_lookups
929: (p_lookup_type => 'YES_NO',
930: p_lookup_code => p_no_mn_rlovr_val_dfnd_flag,
931: p_effective_date => p_effective_date) then
932: --

Line 991: <> nvl(ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag,hr_api.g_varchar2)

987: p_object_version_number => p_object_version_number);
988: --
989: if (l_api_updating
990: and p_no_mx_rlovr_pct_dfnd_flag
991: <> nvl(ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag,hr_api.g_varchar2)
992: or not l_api_updating) then
993: --
994: -- check if value of lookup falls within lookup type.
995: --

Line 997: if hr_api.not_exists_in_hr_lookups

993: --
994: -- check if value of lookup falls within lookup type.
995: --
996: --
997: if hr_api.not_exists_in_hr_lookups
998: (p_lookup_type => 'YES_NO',
999: p_lookup_code => p_no_mx_rlovr_pct_dfnd_flag,
1000: p_effective_date => p_effective_date) then
1001: --

Line 1060: <> nvl(ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag,hr_api.g_varchar2)

1056: p_object_version_number => p_object_version_number);
1057: --
1058: if (l_api_updating
1059: and p_no_mn_rlovr_pct_dfnd_flag
1060: <> nvl(ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag,hr_api.g_varchar2)
1061: or not l_api_updating) then
1062: --
1063: -- check if value of lookup falls within lookup type.
1064: --

Line 1066: if hr_api.not_exists_in_hr_lookups

1062: --
1063: -- check if value of lookup falls within lookup type.
1064: --
1065: --
1066: if hr_api.not_exists_in_hr_lookups
1067: (p_lookup_type => 'YES_NO',
1068: p_lookup_code => p_no_mn_rlovr_pct_dfnd_flag,
1069: p_effective_date => p_effective_date) then
1070: --

Line 1131: <> nvl(ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd,hr_api.g_varchar2)

1127: --
1128: hr_utility.set_location('p_crs_rlovr_procg_cd:'||p_crs_rlovr_procg_cd, 5);
1129: if (l_api_updating
1130: and p_crs_rlovr_procg_cd
1131: <> nvl(ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd,hr_api.g_varchar2)
1132: or not l_api_updating)
1133: and p_crs_rlovr_procg_cd is not null then
1134: --
1135: -- check if value of lookup falls within lookup type.

Line 1138: if hr_api.not_exists_in_hr_lookups

1134: --
1135: -- check if value of lookup falls within lookup type.
1136: --
1137: --
1138: if hr_api.not_exists_in_hr_lookups
1139: (p_lookup_type => 'BEN_CRS_RLOVR_PROCG',
1140: p_lookup_code => p_crs_rlovr_procg_cd,
1141: p_effective_date => p_effective_date) then
1142: --

Line 1219: and nvl(p_pct_rndg_rl,hr_api.g_number)

1215: p_effective_date => p_effective_date,
1216: p_object_version_number => p_object_version_number);
1217: --
1218: if (l_api_updating
1219: and nvl(p_pct_rndg_rl,hr_api.g_number)
1220: <> ben_bpr_shd.g_old_rec.pct_rndg_rl
1221: or not l_api_updating)
1222: and p_pct_rndg_rl is not null then
1223: --

Line 1314: and nvl(p_prtt_elig_rlovr_rl,hr_api.g_number)

1310: p_effective_date => p_effective_date,
1311: p_object_version_number => p_object_version_number);
1312: --
1313: if (l_api_updating
1314: and nvl(p_prtt_elig_rlovr_rl,hr_api.g_number)
1315: <> ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
1316: or not l_api_updating)
1317: and p_prtt_elig_rlovr_rl is not null then
1318: --

Line 1356: (p_acty_base_rt_id in number default hr_api.g_number,

1352: -- ----------------------------------------------------------------------------
1353: -- |--------------------------< chk_abr_dups >--------------------------|
1354: -- ----------------------------------------------------------------------------
1355: Procedure chk_abr_dups
1356: (p_acty_base_rt_id in number default hr_api.g_number,
1357: p_bnft_prvdr_pool_id in number default hr_api.g_number,
1358: p_bnft_pool_rlovr_rqmt_id in number default hr_api.g_number,
1359: p_effective_date in date
1360: ) Is

Line 1357: p_bnft_prvdr_pool_id in number default hr_api.g_number,

1353: -- |--------------------------< chk_abr_dups >--------------------------|
1354: -- ----------------------------------------------------------------------------
1355: Procedure chk_abr_dups
1356: (p_acty_base_rt_id in number default hr_api.g_number,
1357: p_bnft_prvdr_pool_id in number default hr_api.g_number,
1358: p_bnft_pool_rlovr_rqmt_id in number default hr_api.g_number,
1359: p_effective_date in date
1360: ) Is
1361:

Line 1358: p_bnft_pool_rlovr_rqmt_id in number default hr_api.g_number,

1354: -- ----------------------------------------------------------------------------
1355: Procedure chk_abr_dups
1356: (p_acty_base_rt_id in number default hr_api.g_number,
1357: p_bnft_prvdr_pool_id in number default hr_api.g_number,
1358: p_bnft_pool_rlovr_rqmt_id in number default hr_api.g_number,
1359: p_effective_date in date
1360: ) Is
1361:
1362: l_proc varchar2(72) := g_package||'chk_abr_dups';

Line 1424: (p_acty_base_rt_id in number default hr_api.g_number,

1420: --
1421: -- {End Of Comments}
1422: -- ----------------------------------------------------------------------------
1423: Procedure dt_update_validate
1424: (p_acty_base_rt_id in number default hr_api.g_number,
1425: p_bnft_prvdr_pool_id in number default hr_api.g_number,
1426: p_datetrack_mode in varchar2,
1427: p_validation_start_date in date,
1428: p_validation_end_date in date) Is

Line 1425: p_bnft_prvdr_pool_id in number default hr_api.g_number,

1421: -- {End Of Comments}
1422: -- ----------------------------------------------------------------------------
1423: Procedure dt_update_validate
1424: (p_acty_base_rt_id in number default hr_api.g_number,
1425: p_bnft_prvdr_pool_id in number default hr_api.g_number,
1426: p_datetrack_mode in varchar2,
1427: p_validation_start_date in date,
1428: p_validation_end_date in date) Is
1429: --

Line 1439: hr_api.mandatory_arg_error

1435: hr_utility.set_location('Entering:'||l_proc, 5);
1436: --
1437: -- Ensure that the p_datetrack_mode argument is not null
1438: --
1439: hr_api.mandatory_arg_error
1440: (p_api_name => l_proc,
1441: p_argument => 'datetrack_mode',
1442: p_argument_value => p_datetrack_mode);
1443: --

Line 1451: hr_api.mandatory_arg_error

1447: --
1448: --
1449: -- Ensure the arguments are not null
1450: --
1451: hr_api.mandatory_arg_error
1452: (p_api_name => l_proc,
1453: p_argument => 'validation_start_date',
1454: p_argument_value => p_validation_start_date);
1455: --

Line 1456: hr_api.mandatory_arg_error

1452: (p_api_name => l_proc,
1453: p_argument => 'validation_start_date',
1454: p_argument_value => p_validation_start_date);
1455: --
1456: hr_api.mandatory_arg_error
1457: (p_api_name => l_proc,
1458: p_argument => 'validation_end_date',
1459: p_argument_value => p_validation_end_date);
1460: --

Line 1461: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

1457: (p_api_name => l_proc,
1458: p_argument => 'validation_end_date',
1459: p_argument_value => p_validation_end_date);
1460: --
1461: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
1462: NOT (dt_api.check_min_max_dates
1463: (p_base_table_name => 'ben_acty_base_rt_f',
1464: p_base_key_column => 'acty_base_rt_id',
1465: p_base_key_value => p_acty_base_rt_id,

Line 1471: If ((nvl(p_bnft_prvdr_pool_id, hr_api.g_number) <> hr_api.g_number) and

1467: p_to_date => p_validation_end_date))) Then
1468: l_table_name := 'ben_acty_base_rt_f';
1469: Raise l_integrity_error;
1470: End If;
1471: If ((nvl(p_bnft_prvdr_pool_id, hr_api.g_number) <> hr_api.g_number) and
1472: NOT (dt_api.check_min_max_dates
1473: (p_base_table_name => 'ben_bnft_prvdr_pool_f',
1474: p_base_key_column => 'bnft_prvdr_pool_id',
1475: p_base_key_value => p_bnft_prvdr_pool_id,

Line 1554: hr_api.mandatory_arg_error

1550: hr_utility.set_location('Entering:'||l_proc, 5);
1551: --
1552: -- Ensure that the p_datetrack_mode argument is not null
1553: --
1554: hr_api.mandatory_arg_error
1555: (p_api_name => l_proc,
1556: p_argument => 'datetrack_mode',
1557: p_argument_value => p_datetrack_mode);
1558: --

Line 1568: hr_api.mandatory_arg_error

1564: --
1565: --
1566: -- Ensure the arguments are not null
1567: --
1568: hr_api.mandatory_arg_error
1569: (p_api_name => l_proc,
1570: p_argument => 'validation_start_date',
1571: p_argument_value => p_validation_start_date);
1572: --

Line 1573: hr_api.mandatory_arg_error

1569: (p_api_name => l_proc,
1570: p_argument => 'validation_start_date',
1571: p_argument_value => p_validation_start_date);
1572: --
1573: hr_api.mandatory_arg_error
1574: (p_api_name => l_proc,
1575: p_argument => 'validation_end_date',
1576: p_argument_value => p_validation_end_date);
1577: --

Line 1578: hr_api.mandatory_arg_error

1574: (p_api_name => l_proc,
1575: p_argument => 'validation_end_date',
1576: p_argument_value => p_validation_end_date);
1577: --
1578: hr_api.mandatory_arg_error
1579: (p_api_name => l_proc,
1580: p_argument => 'bnft_pool_rlovr_rqmt_id',
1581: p_argument_value => p_bnft_pool_rlovr_rqmt_id);
1582: --

Line 1625: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1621: --
1622: -- Call all supporting business operations
1623: --
1624: --
1625: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1626: --
1627: chk_bnft_pool_rlovr_rqmt_id
1628: (p_bnft_pool_rlovr_rqmt_id => p_rec.bnft_pool_rlovr_rqmt_id,
1629: p_effective_date => p_effective_date,

Line 1765: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1761: --
1762: -- Call all supporting business operations
1763: --
1764: --
1765: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1766: --
1767: chk_bnft_pool_rlovr_rqmt_id
1768: (p_bnft_pool_rlovr_rqmt_id => p_rec.bnft_pool_rlovr_rqmt_id,
1769: p_effective_date => p_effective_date,

Line 1951: hr_api.mandatory_arg_error(p_api_name => l_proc,

1947: hr_utility.set_location('Entering:'|| l_proc, 10);
1948: --
1949: -- Ensure that all the mandatory parameter are not null
1950: --
1951: hr_api.mandatory_arg_error(p_api_name => l_proc,
1952: p_argument => 'bnft_pool_rlovr_rqmt_id',
1953: p_argument_value => p_bnft_pool_rlovr_rqmt_id);
1954: --
1955: open csr_leg_code;