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

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

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

Line 167: <> nvl(ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd,hr_api.g_varchar2)

163: p_object_version_number => p_object_version_number);
164: --
165: if (l_api_updating
166: and p_prmry_care_prvdr_typ_cd
167: <> nvl(ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd,hr_api.g_varchar2)
168: or not l_api_updating) then
169: --
170: -- check if value of lookup falls within lookup type.
171: --

Line 182: if hr_api.not_exists_in_hr_lookups

178: and bper.pl_id = bpp.pl_id
179: and p_effective_date between bper.effective_start_date and bper.effective_end_date;
180:
181: If l_pcp_rpstry_flag = 'N' then
182: if hr_api.not_exists_in_hr_lookups
183: (p_lookup_type => 'BEN_PRMRY_CARE_PRVDR_TYP',
184: p_lookup_code => p_prmry_care_prvdr_typ_cd,
185: p_effective_date => p_effective_date) then
186: --

Line 198: if hr_api.not_exists_in_hr_lookups

194: end if;
195: --
196:
197: Elsif l_pcp_rpstry_flag = 'Y' then -- else condition changed to check for repository flag = 'Y' and not 'N'
198: if hr_api.not_exists_in_hr_lookups
199: (p_lookup_type => 'BEN_PCP_SPCLTY',
200: p_lookup_code => p_prmry_care_prvdr_typ_cd,
201: p_effective_date => p_effective_date) then
202: --

Line 244: <> nvl(ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd,hr_api.g_varchar2)

240: p_object_version_number => p_object_version_number);
241: --
242: if (l_api_updating
243: and p_prmry_care_prvdr_typ_cd
244: <> nvl(ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd,hr_api.g_varchar2)
245: or not l_api_updating) then
246: --
247: -- check if value of lookup falls within lookup type.
248: --

Line 250: if hr_api.not_exists_in_hr_lookups

246: --
247: -- check if value of lookup falls within lookup type.
248: --
249: --
250: if hr_api.not_exists_in_hr_lookups
251: (p_lookup_type => 'BEN_PRMRY_CARE_PRVDR_TYP',
252: p_lookup_code => p_prmry_care_prvdr_typ_cd,
253: p_effective_date => p_effective_date) then
254: --

Line 304: WHERE prmry_care_prvdr_id <> nvl(p_prmry_care_prvdr_id, hr_api.g_number)

300:
301: CURSOR c1 IS
302: SELECT name
303: FROM ben_prmry_care_prvdr_f
304: WHERE prmry_care_prvdr_id <> nvl(p_prmry_care_prvdr_id, hr_api.g_number)
305: AND prmry_care_prvdr_typ_cd = p_prmry_care_prvdr_typ_cd
306: AND prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
307: AND effective_end_date >= p_validation_start_date
308: AND effective_start_date <= p_validation_end_date ;

Line 324: and nvl(p_prmry_care_prvdr_typ_cd,hr_api.g_varchar2)

320: p_effective_date => p_effective_date,
321: p_object_version_number => p_object_version_number);
322:
323: if (l_api_updating
324: and nvl(p_prmry_care_prvdr_typ_cd,hr_api.g_varchar2)
325: <> ben_ppr_shd.g_old_rec.prmry_care_prvdr_typ_cd
326: or not l_api_updating) then
327:
328: if p_prtt_enrt_rslt_id is not null then

Line 769: (p_elig_cvrd_dpnt_id in number default hr_api.g_number,

765: --
766: -- {End Of Comments}
767: -- ----------------------------------------------------------------------------
768: Procedure dt_update_validate
769: (p_elig_cvrd_dpnt_id in number default hr_api.g_number,
770: p_prtt_enrt_rslt_id in number default hr_api.g_number,
771: p_datetrack_mode in varchar2,
772: p_validation_start_date in date,
773: p_validation_end_date in date) Is

Line 770: p_prtt_enrt_rslt_id in number default hr_api.g_number,

766: -- {End Of Comments}
767: -- ----------------------------------------------------------------------------
768: Procedure dt_update_validate
769: (p_elig_cvrd_dpnt_id in number default hr_api.g_number,
770: p_prtt_enrt_rslt_id in number default hr_api.g_number,
771: p_datetrack_mode in varchar2,
772: p_validation_start_date in date,
773: p_validation_end_date in date) Is
774: --

Line 784: hr_api.mandatory_arg_error

780: hr_utility.set_location('Entering:'||l_proc, 5);
781: --
782: -- Ensure that the p_datetrack_mode argument is not null
783: --
784: hr_api.mandatory_arg_error
785: (p_api_name => l_proc,
786: p_argument => 'datetrack_mode',
787: p_argument_value => p_datetrack_mode);
788: --

Line 796: hr_api.mandatory_arg_error

792: --
793: --
794: -- Ensure the arguments are not null
795: --
796: hr_api.mandatory_arg_error
797: (p_api_name => l_proc,
798: p_argument => 'validation_start_date',
799: p_argument_value => p_validation_start_date);
800: --

Line 801: hr_api.mandatory_arg_error

797: (p_api_name => l_proc,
798: p_argument => 'validation_start_date',
799: p_argument_value => p_validation_start_date);
800: --
801: hr_api.mandatory_arg_error
802: (p_api_name => l_proc,
803: p_argument => 'validation_end_date',
804: p_argument_value => p_validation_end_date);
805: --

Line 806: If ((nvl(p_elig_cvrd_dpnt_id, hr_api.g_number) <> hr_api.g_number) and

802: (p_api_name => l_proc,
803: p_argument => 'validation_end_date',
804: p_argument_value => p_validation_end_date);
805: --
806: If ((nvl(p_elig_cvrd_dpnt_id, hr_api.g_number) <> hr_api.g_number) and
807: NOT (dt_api.check_min_max_dates
808: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',
809: p_base_key_column => 'elig_cvrd_dpnt_id',
810: p_base_key_value => p_elig_cvrd_dpnt_id,

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

812: p_to_date => p_validation_end_date))) Then
813: l_table_name := 'ben_elig_cvrd_dpnt_f';
814: Raise l_integrity_error;
815: End If;
816: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
817: NOT (dt_api.check_min_max_dates
818: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
819: p_base_key_column => 'prtt_enrt_rslt_id',
820: p_base_key_value => p_prtt_enrt_rslt_id,

Line 899: hr_api.mandatory_arg_error

895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: -- Ensure that the p_datetrack_mode argument is not null
898: --
899: hr_api.mandatory_arg_error
900: (p_api_name => l_proc,
901: p_argument => 'datetrack_mode',
902: p_argument_value => p_datetrack_mode);
903: --

Line 913: hr_api.mandatory_arg_error

909: --
910: --
911: -- Ensure the arguments are not null
912: --
913: hr_api.mandatory_arg_error
914: (p_api_name => l_proc,
915: p_argument => 'validation_start_date',
916: p_argument_value => p_validation_start_date);
917: --

Line 918: hr_api.mandatory_arg_error

914: (p_api_name => l_proc,
915: p_argument => 'validation_start_date',
916: p_argument_value => p_validation_start_date);
917: --
918: hr_api.mandatory_arg_error
919: (p_api_name => l_proc,
920: p_argument => 'validation_end_date',
921: p_argument_value => p_validation_end_date);
922: --

Line 923: hr_api.mandatory_arg_error

919: (p_api_name => l_proc,
920: p_argument => 'validation_end_date',
921: p_argument_value => p_validation_end_date);
922: --
923: hr_api.mandatory_arg_error
924: (p_api_name => l_proc,
925: p_argument => 'prmry_care_prvdr_id',
926: p_argument_value => p_prmry_care_prvdr_id);
927: --

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

966: --
967: -- Call all supporting business operations
968: --
969: --
970: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
971: --
972: chk_prmry_care_prvdr_id
973: (p_prmry_care_prvdr_id => p_rec.prmry_care_prvdr_id,
974: p_effective_date => p_effective_date,

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

1038: --
1039: -- Call all supporting business operations
1040: --
1041: --
1042: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1043: --
1044: chk_prmry_care_prvdr_id
1045: (p_prmry_care_prvdr_id => p_rec.prmry_care_prvdr_id,
1046: p_effective_date => p_effective_date,

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

1155: hr_utility.set_location('Entering:'|| l_proc, 10);
1156: --
1157: -- Ensure that all the mandatory parameter are not null
1158: --
1159: hr_api.mandatory_arg_error(p_api_name => l_proc,
1160: p_argument => 'prmry_care_prvdr_id',
1161: p_argument_value => p_prmry_care_prvdr_id);
1162: --
1163: open csr_leg_code;