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

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

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

Line 124: <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_prmry_cntngnt_cd
124: <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'BEN_PRMRY_CNTNGNT',
132: p_lookup_code => p_prmry_cntngnt_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 469: and b.pl_bnf_id <> nvl(p_pl_bnf_id, hr_api.g_number)

465: from ben_pl_bnf_f b
466: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
467: and b.business_group_id + 0 = p_business_group_id
468: and b.prmry_cntngnt_cd = p_prmry_cntngnt_cd
469: and b.pl_bnf_id <> nvl(p_pl_bnf_id, hr_api.g_number)
470: and p_validation_start_date <= b.effective_end_date
471: and p_validation_end_date >= b.effective_start_date
472: ;
473: --

Line 485: and nvl(p_pct_dsgd_num, hr_api.g_number)

481: p_object_version_number => p_object_version_number);
482: --
483: if p_pct_dsgd_num is not null then
484: if (l_api_updating
485: and nvl(p_pct_dsgd_num, hr_api.g_number)
486: <> nvl(ben_pbn_shd.g_old_rec.pct_dsgd_num, hr_api.g_number)
487: or not l_api_updating) then
488: --
489: -- check if sum of pct_dsgd_num is less or = 100

Line 486: <> nvl(ben_pbn_shd.g_old_rec.pct_dsgd_num, hr_api.g_number)

482: --
483: if p_pct_dsgd_num is not null then
484: if (l_api_updating
485: and nvl(p_pct_dsgd_num, hr_api.g_number)
486: <> nvl(ben_pbn_shd.g_old_rec.pct_dsgd_num, hr_api.g_number)
487: or not l_api_updating) then
488: --
489: -- check if sum of pct_dsgd_num is less or = 100
490: --

Line 570: and b.pl_bnf_id <> nvl(p_pl_bnf_id, hr_api.g_number)

566: from ben_pl_bnf_f b
567: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
568: and b.business_group_id + 0 = p_business_group_id
569: and b.prmry_cntngnt_cd = p_prmry_cntngnt_cd
570: and b.pl_bnf_id <> nvl(p_pl_bnf_id, hr_api.g_number)
571: and p_validation_start_date <=b.effective_end_date
572: and p_validation_end_date >= b.effective_start_date
573: ;
574: --

Line 586: and nvl(p_amt_dsgd_val,hr_api.g_number)

582: p_object_version_number => p_object_version_number);
583: --
584: if p_amt_dsgd_val is not null then
585: if (l_api_updating
586: and nvl(p_amt_dsgd_val,hr_api.g_number)
587: <> nvl(ben_pbn_shd.g_old_rec.amt_dsgd_val, hr_api.g_number)
588: or not l_api_updating) then
589: --
590: -- check if sum of amt_dsgd_val is less or = bnft_amt value on ben_prtt_enrt_rslt_f table

Line 587: <> nvl(ben_pbn_shd.g_old_rec.amt_dsgd_val, hr_api.g_number)

583: --
584: if p_amt_dsgd_val is not null then
585: if (l_api_updating
586: and nvl(p_amt_dsgd_val,hr_api.g_number)
587: <> nvl(ben_pbn_shd.g_old_rec.amt_dsgd_val, hr_api.g_number)
588: or not l_api_updating) then
589: --
590: -- check if sum of amt_dsgd_val is less or = bnft_amt value on ben_prtt_enrt_rslt_f table
591: --

Line 686: <> nvl(ben_pbn_shd.g_old_rec.amt_dsgd_uom,hr_api.g_varchar2)

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

Line 775: and pbn.pl_bnf_id <> nvl(p_pl_bnf_id, hr_api.g_number)

771: pil.business_group_id(+)=pbn.business_group_id
772: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
773: or pil.per_in_ler_stat_cd is null )
774: and pbn.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
775: and pbn.pl_bnf_id <> nvl(p_pl_bnf_id, hr_api.g_number)
776: and pbn.business_group_id + 0 = p_business_group_id
777: and p_validation_start_date <= pbn.effective_end_date
778: and p_validation_end_date >= pbn.effective_start_date
779: ;

Line 802: and nvl(p_bnf_person_id,hr_api.g_number)

798: p_object_version_number => p_object_version_number);
799: --
800: if p_bnf_person_id is not null then
801: if (l_api_updating
802: and nvl(p_bnf_person_id,hr_api.g_number)
803: <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
804: or not l_api_updating) then
805: --
806: -- check if bnf_person_id value exists in per_all_people_f table

Line 803: <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)

799: --
800: if p_bnf_person_id is not null then
801: if (l_api_updating
802: and nvl(p_bnf_person_id,hr_api.g_number)
803: <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
804: or not l_api_updating) then
805: --
806: -- check if bnf_person_id value exists in per_all_people_f table
807: --

Line 910: and nvl(p_ttee_person_id,hr_api.g_number)

906: p_object_version_number => p_object_version_number);
907: --
908: if p_ttee_person_id is not null then
909: if (l_api_updating
910: and nvl(p_ttee_person_id,hr_api.g_number)
911: <> nvl(ben_pbn_shd.g_old_rec.ttee_person_id, hr_api.g_number)
912: or not l_api_updating) then
913: --
914: -- check if ttee_person_id value exists in per_all_people_f table

Line 911: <> nvl(ben_pbn_shd.g_old_rec.ttee_person_id, hr_api.g_number)

907: --
908: if p_ttee_person_id is not null then
909: if (l_api_updating
910: and nvl(p_ttee_person_id,hr_api.g_number)
911: <> nvl(ben_pbn_shd.g_old_rec.ttee_person_id, hr_api.g_number)
912: or not l_api_updating) then
913: --
914: -- check if ttee_person_id value exists in per_all_people_f table
915: --

Line 1684: and nvl(p_organization_id,hr_api.g_number)

1680: p_object_version_number => p_object_version_number);
1681: --
1682: if p_organization_id is not null then
1683: if (l_api_updating
1684: and nvl(p_organization_id,hr_api.g_number)
1685: <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1686: or not l_api_updating) then
1687: --
1688: -- check if organization_id value exists in hr_all_organization_units table

Line 1685: <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)

1681: --
1682: if p_organization_id is not null then
1683: if (l_api_updating
1684: and nvl(p_organization_id,hr_api.g_number)
1685: <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1686: or not l_api_updating) then
1687: --
1688: -- check if organization_id value exists in hr_all_organization_units table
1689: --

Line 1769: and pbn.pl_bnf_id <> nvl(p_pl_bnf_id,hr_api.g_number)

1765: and pil.business_group_id (+) = pbn.business_group_id
1766: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1767: or pil.per_in_ler_stat_cd is null )
1768: and pbn.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1769: and pbn.pl_bnf_id <> nvl(p_pl_bnf_id,hr_api.g_number)
1770: and pbn.business_group_id = p_business_group_id
1771: and pbn.prmry_cntngnt_cd <> p_prmry_cntngnt_cd
1772: and p_effective_date between pbn.effective_start_date and (pbn.effective_end_date -1);
1773:

Line 1785: and (nvl(p_organization_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)

1781: p_effective_date => p_effective_date,
1782: p_object_version_number => p_object_version_number);
1783: --
1784: if (l_api_updating
1785: and (nvl(p_organization_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1786: or nvl(p_bnf_person_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
1787: or nvl(p_prmry_cntngnt_cd,hr_api.g_varchar2) <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd, hr_api.g_varchar2))
1788: or not l_api_updating) then
1789: --

Line 1786: or nvl(p_bnf_person_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)

1782: p_object_version_number => p_object_version_number);
1783: --
1784: if (l_api_updating
1785: and (nvl(p_organization_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1786: or nvl(p_bnf_person_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
1787: or nvl(p_prmry_cntngnt_cd,hr_api.g_varchar2) <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd, hr_api.g_varchar2))
1788: or not l_api_updating) then
1789: --
1790: -- check if person/organization has already been designated as a

Line 1787: or nvl(p_prmry_cntngnt_cd,hr_api.g_varchar2) <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd, hr_api.g_varchar2))

1783: --
1784: if (l_api_updating
1785: and (nvl(p_organization_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1786: or nvl(p_bnf_person_id,hr_api.g_number) <> nvl(ben_pbn_shd.g_old_rec.bnf_person_id, hr_api.g_number)
1787: or nvl(p_prmry_cntngnt_cd,hr_api.g_varchar2) <> nvl(ben_pbn_shd.g_old_rec.prmry_cntngnt_cd, hr_api.g_varchar2))
1788: or not l_api_updating) then
1789: --
1790: -- check if person/organization has already been designated as a
1791: -- bnf with a different prmry_cntngnt_cd

Line 1851: (p_per_in_ler_id in number default hr_api.g_number,

1847: --
1848: -- {End Of Comments}
1849: -- ----------------------------------------------------------------------------
1850: Procedure dt_update_validate
1851: (p_per_in_ler_id in number default hr_api.g_number,
1852: p_prtt_enrt_rslt_id in number default hr_api.g_number,
1853: p_datetrack_mode in varchar2,
1854: p_validation_start_date in date,
1855: p_validation_end_date in date) Is

Line 1852: p_prtt_enrt_rslt_id in number default hr_api.g_number,

1848: -- {End Of Comments}
1849: -- ----------------------------------------------------------------------------
1850: Procedure dt_update_validate
1851: (p_per_in_ler_id in number default hr_api.g_number,
1852: p_prtt_enrt_rslt_id in number default hr_api.g_number,
1853: p_datetrack_mode in varchar2,
1854: p_validation_start_date in date,
1855: p_validation_end_date in date) Is
1856: --

Line 1866: hr_api.mandatory_arg_error

1862: hr_utility.set_location('Entering:'||l_proc, 5);
1863: --
1864: -- Ensure that the p_datetrack_mode argument is not null
1865: --
1866: hr_api.mandatory_arg_error
1867: (p_api_name => l_proc,
1868: p_argument => 'datetrack_mode',
1869: p_argument_value => p_datetrack_mode);
1870: --

Line 1878: hr_api.mandatory_arg_error

1874: --
1875: --
1876: -- Ensure the arguments are not null
1877: --
1878: hr_api.mandatory_arg_error
1879: (p_api_name => l_proc,
1880: p_argument => 'validation_start_date',
1881: p_argument_value => p_validation_start_date);
1882: --

Line 1883: hr_api.mandatory_arg_error

1879: (p_api_name => l_proc,
1880: p_argument => 'validation_start_date',
1881: p_argument_value => p_validation_start_date);
1882: --
1883: hr_api.mandatory_arg_error
1884: (p_api_name => l_proc,
1885: p_argument => 'validation_end_date',
1886: p_argument_value => p_validation_end_date);
1887: --

Line 1888: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and

1884: (p_api_name => l_proc,
1885: p_argument => 'validation_end_date',
1886: p_argument_value => p_validation_end_date);
1887: --
1888: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
1889: NOT (dt_api.check_min_max_dates
1890: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
1891: p_base_key_column => 'prtt_enrt_rslt_id',
1892: p_base_key_value => p_prtt_enrt_rslt_id,

Line 1974: hr_api.mandatory_arg_error

1970: hr_utility.set_location('Entering:'||l_proc, 5);
1971: --
1972: -- Ensure that the p_datetrack_mode argument is not null
1973: --
1974: hr_api.mandatory_arg_error
1975: (p_api_name => l_proc,
1976: p_argument => 'datetrack_mode',
1977: p_argument_value => p_datetrack_mode);
1978: --

Line 1988: hr_api.mandatory_arg_error

1984: --
1985: --
1986: -- Ensure the arguments are not null
1987: --
1988: hr_api.mandatory_arg_error
1989: (p_api_name => l_proc,
1990: p_argument => 'validation_start_date',
1991: p_argument_value => p_validation_start_date);
1992: --

Line 1993: hr_api.mandatory_arg_error

1989: (p_api_name => l_proc,
1990: p_argument => 'validation_start_date',
1991: p_argument_value => p_validation_start_date);
1992: --
1993: hr_api.mandatory_arg_error
1994: (p_api_name => l_proc,
1995: p_argument => 'validation_end_date',
1996: p_argument_value => p_validation_end_date);
1997: --

Line 1998: hr_api.mandatory_arg_error

1994: (p_api_name => l_proc,
1995: p_argument => 'validation_end_date',
1996: p_argument_value => p_validation_end_date);
1997: --
1998: hr_api.mandatory_arg_error
1999: (p_api_name => l_proc,
2000: p_argument => 'pl_bnf_id',
2001: p_argument_value => p_pl_bnf_id);
2002: --

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

2050: --
2051: -- Call all supporting business operations
2052: --
2053: --
2054: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2055: --
2056: chk_pl_bnf_id
2057: (p_pl_bnf_id => p_rec.pl_bnf_id,
2058: p_effective_date => p_effective_date,

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

2193: --
2194: -- Call all supporting business operations
2195: --
2196: --
2197: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2198: --
2199:
2200: chk_pl_bnf_id
2201: (p_pl_bnf_id => p_rec.pl_bnf_id,

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

2385: hr_utility.set_location('Entering:'|| l_proc, 10);
2386: --
2387: -- Ensure that all the mandatory parameter are not null
2388: --
2389: hr_api.mandatory_arg_error(p_api_name => l_proc,
2390: p_argument => 'pl_bnf_id',
2391: p_argument_value => p_pl_bnf_id);
2392: --
2393: open csr_leg_code;