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

Line 51: and nvl(p_popl_yr_perd_id,hr_api.g_number)

47: (p_popl_yr_perd_id => p_popl_yr_perd_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_popl_yr_perd_id,hr_api.g_number)
52: <> ben_cpy_shd.g_old_rec.popl_yr_perd_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 174: and (nvl(p_popl_yr_perd_id,hr_api.g_number)

170: (p_popl_yr_perd_id => p_popl_yr_perd_id,
171: p_object_version_number => p_object_version_number);
172: --
173: if (l_api_updating
174: and (nvl(p_popl_yr_perd_id,hr_api.g_number)
175: <> ben_cpy_shd.g_old_rec.popl_yr_perd_id
176: or nvl(p_pgm_id,hr_api.g_number)
177: <> ben_cpy_shd.g_old_rec.pgm_id
178: or nvl(p_pl_id,hr_api.g_number)

Line 176: or nvl(p_pgm_id,hr_api.g_number)

172: --
173: if (l_api_updating
174: and (nvl(p_popl_yr_perd_id,hr_api.g_number)
175: <> ben_cpy_shd.g_old_rec.popl_yr_perd_id
176: or nvl(p_pgm_id,hr_api.g_number)
177: <> ben_cpy_shd.g_old_rec.pgm_id
178: or nvl(p_pl_id,hr_api.g_number)
179: <> ben_cpy_shd.g_old_rec.pl_id
180: or nvl(p_yr_perd_id,hr_api.g_number)

Line 178: or nvl(p_pl_id,hr_api.g_number)

174: and (nvl(p_popl_yr_perd_id,hr_api.g_number)
175: <> ben_cpy_shd.g_old_rec.popl_yr_perd_id
176: or nvl(p_pgm_id,hr_api.g_number)
177: <> ben_cpy_shd.g_old_rec.pgm_id
178: or nvl(p_pl_id,hr_api.g_number)
179: <> ben_cpy_shd.g_old_rec.pl_id
180: or nvl(p_yr_perd_id,hr_api.g_number)
181: <> ben_cpy_shd.g_old_rec.yr_perd_id)
182: or not l_api_updating) then

Line 180: or nvl(p_yr_perd_id,hr_api.g_number)

176: or nvl(p_pgm_id,hr_api.g_number)
177: <> ben_cpy_shd.g_old_rec.pgm_id
178: or nvl(p_pl_id,hr_api.g_number)
179: <> ben_cpy_shd.g_old_rec.pl_id
180: or nvl(p_yr_perd_id,hr_api.g_number)
181: <> ben_cpy_shd.g_old_rec.yr_perd_id)
182: or not l_api_updating) then
183: --
184: -- check if an overlap occurs

Line 288: and nvl(p_pl_id,hr_api.g_number)

284: (p_popl_yr_perd_id => p_popl_yr_perd_id,
285: p_object_version_number => p_object_version_number);
286: --
287: if (l_api_updating
288: and nvl(p_pl_id,hr_api.g_number)
289: <> nvl(ben_cpy_shd.g_old_rec.pl_id,hr_api.g_number)
290: or not l_api_updating) then
291: --
292: -- check if pl_id value exists in ben_pl_f table

Line 289: <> nvl(ben_cpy_shd.g_old_rec.pl_id,hr_api.g_number)

285: p_object_version_number => p_object_version_number);
286: --
287: if (l_api_updating
288: and nvl(p_pl_id,hr_api.g_number)
289: <> nvl(ben_cpy_shd.g_old_rec.pl_id,hr_api.g_number)
290: or not l_api_updating) then
291: --
292: -- check if pl_id value exists in ben_pl_f table
293: --

Line 368: and nvl(p_pgm_id,hr_api.g_number)

364: (p_popl_yr_perd_id => p_popl_yr_perd_id,
365: p_object_version_number => p_object_version_number);
366: --
367: if (l_api_updating
368: and nvl(p_pgm_id,hr_api.g_number)
369: <> nvl(ben_cpy_shd.g_old_rec.pgm_id,hr_api.g_number)
370: or not l_api_updating) then
371: --
372: -- check if pgm_id value exists in ben_pgm_f table

Line 369: <> nvl(ben_cpy_shd.g_old_rec.pgm_id,hr_api.g_number)

365: p_object_version_number => p_object_version_number);
366: --
367: if (l_api_updating
368: and nvl(p_pgm_id,hr_api.g_number)
369: <> nvl(ben_cpy_shd.g_old_rec.pgm_id,hr_api.g_number)
370: or not l_api_updating) then
371: --
372: -- check if pgm_id value exists in ben_pgm_f table
373: --

Line 451: and nvl(p_yr_perd_id,hr_api.g_number)

447: fnd_message.set_name('BEN','BEN_94122_PLAN_YR_PERD_MANDTRY');
448: fnd_message.raise_error;
449: --
450: elsif (l_api_updating
451: and nvl(p_yr_perd_id,hr_api.g_number)
452: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
453: or not l_api_updating) then
454: --
455: -- check if yr_perd_id value exists in ben_yr_perd table

Line 452: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)

448: fnd_message.raise_error;
449: --
450: elsif (l_api_updating
451: and nvl(p_yr_perd_id,hr_api.g_number)
452: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
453: or not l_api_updating) then
454: --
455: -- check if yr_perd_id value exists in ben_yr_perd table
456: --

Line 587: and (nvl(p_yr_perd_id,hr_api.g_number)

583: -- if p_py_clms_thru_dt is not filled in then we need to tell user we
584: -- have one value but we need the other
585: --
586: if (l_api_updating
587: and (nvl(p_yr_perd_id,hr_api.g_number)
588: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
589: or nvl(p_py_clms_thru_dt,hr_api.g_date)
590: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
591: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)

Line 588: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)

584: -- have one value but we need the other
585: --
586: if (l_api_updating
587: and (nvl(p_yr_perd_id,hr_api.g_number)
588: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
589: or nvl(p_py_clms_thru_dt,hr_api.g_date)
590: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
591: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
592: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))

Line 589: or nvl(p_py_clms_thru_dt,hr_api.g_date)

585: --
586: if (l_api_updating
587: and (nvl(p_yr_perd_id,hr_api.g_number)
588: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
589: or nvl(p_py_clms_thru_dt,hr_api.g_date)
590: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
591: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
592: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))
593: or not l_api_updating) then

Line 590: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)

586: if (l_api_updating
587: and (nvl(p_yr_perd_id,hr_api.g_number)
588: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
589: or nvl(p_py_clms_thru_dt,hr_api.g_date)
590: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
591: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
592: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))
593: or not l_api_updating) then
594: --

Line 591: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)

587: and (nvl(p_yr_perd_id,hr_api.g_number)
588: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
589: or nvl(p_py_clms_thru_dt,hr_api.g_date)
590: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
591: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
592: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))
593: or not l_api_updating) then
594: --
595: -- OK we are updating or we are inserting so lets check if the values

Line 592: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))

588: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
589: or nvl(p_py_clms_thru_dt,hr_api.g_date)
590: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
591: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
592: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))
593: or not l_api_updating) then
594: --
595: -- OK we are updating or we are inserting so lets check if the values
596: -- of the dates are valid. They must both be null or both be not null

Line 722: and (nvl(p_yr_perd_id,hr_api.g_number)

718: -- if p_py_clms_thru_dt is not filled in then we need to tell user we
719: -- have one value but we need the other
720: --
721: if (l_api_updating
722: and (nvl(p_yr_perd_id,hr_api.g_number)
723: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
724: or nvl(p_py_clms_thru_dt,hr_api.g_date)
725: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
726: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)

Line 723: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)

719: -- have one value but we need the other
720: --
721: if (l_api_updating
722: and (nvl(p_yr_perd_id,hr_api.g_number)
723: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
724: or nvl(p_py_clms_thru_dt,hr_api.g_date)
725: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
726: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
727: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))

Line 724: or nvl(p_py_clms_thru_dt,hr_api.g_date)

720: --
721: if (l_api_updating
722: and (nvl(p_yr_perd_id,hr_api.g_number)
723: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
724: or nvl(p_py_clms_thru_dt,hr_api.g_date)
725: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
726: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
727: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))
728: or not l_api_updating) then

Line 725: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)

721: if (l_api_updating
722: and (nvl(p_yr_perd_id,hr_api.g_number)
723: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
724: or nvl(p_py_clms_thru_dt,hr_api.g_date)
725: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
726: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
727: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))
728: or not l_api_updating) then
729: --

Line 726: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)

722: and (nvl(p_yr_perd_id,hr_api.g_number)
723: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
724: or nvl(p_py_clms_thru_dt,hr_api.g_date)
725: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
726: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
727: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))
728: or not l_api_updating) then
729: --
730: -- OK we are updating or we are inserting so lets check if the values

Line 727: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))

723: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
724: or nvl(p_py_clms_thru_dt,hr_api.g_date)
725: <> nvl(ben_cpy_shd.g_old_rec.py_clms_thru_dt,hr_api.g_date)
726: or nvl(p_acpt_clm_rqsts_thru_dt,hr_api.g_date)
727: <> nvl(ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt,hr_api.g_date))
728: or not l_api_updating) then
729: --
730: -- OK we are updating or we are inserting so lets check if the values
731: -- of the dates are valid. They must both be null or both be not null

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

881: --
882: -- Call all supporting business operations
883: --
884: --
885: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
886: --
887: chk_popl_yr_perd_id
888: (p_popl_yr_perd_id => p_rec.popl_yr_perd_id,
889: p_object_version_number => p_rec.object_version_number);

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

944: --
945: -- Call all supporting business operations
946: --
947: --
948: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
949: --
950: chk_popl_yr_perd_id
951: (p_popl_yr_perd_id => p_rec.popl_yr_perd_id,
952: p_object_version_number => p_rec.object_version_number);

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

1036: hr_utility.set_location('Entering:'|| l_proc, 10);
1037: --
1038: -- Ensure that all the mandatory parameter are not null
1039: --
1040: hr_api.mandatory_arg_error(p_api_name => l_proc,
1041: p_argument => 'popl_yr_perd_id',
1042: p_argument_value => p_popl_yr_perd_id);
1043: --
1044: open csr_leg_code;