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 BEN_CPY_SHD

Line 46: l_api_updating := ben_cpy_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_cpy_shd.api_updating
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

Line 52: <> ben_cpy_shd.g_old_rec.popl_yr_perd_id) then

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: --
56: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_PK');

Line 56: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_PK');

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

Line 66: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_PK');

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

Line 169: l_api_updating := ben_cpy_shd.api_updating

165: Begin
166: --
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: l_api_updating := ben_cpy_shd.api_updating
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

Line 175: <> ben_cpy_shd.g_old_rec.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)
179: <> ben_cpy_shd.g_old_rec.pl_id

Line 177: <> ben_cpy_shd.g_old_rec.pgm_id

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)
181: <> ben_cpy_shd.g_old_rec.yr_perd_id)

Line 179: <> ben_cpy_shd.g_old_rec.pl_id

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
183: --

Line 181: <> ben_cpy_shd.g_old_rec.yr_perd_id)

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
185: --

Line 283: l_api_updating := ben_cpy_shd.api_updating

279: Begin
280: --
281: hr_utility.set_location('Entering:'||l_proc,5);
282: --
283: l_api_updating := ben_cpy_shd.api_updating
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

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 304: ben_cpy_shd.constraint_error('DATETRACK-ERROR');

300: --
301: -- raise error as FK does not relate to PK in ben_pl_f
302: -- table.
303: --
304: ben_cpy_shd.constraint_error('DATETRACK-ERROR');
305: --
306: end if;
307: --
308: close c1;

Line 363: l_api_updating := ben_cpy_shd.api_updating

359: Begin
360: --
361: hr_utility.set_location('Entering:'||l_proc,5);
362: --
363: l_api_updating := ben_cpy_shd.api_updating
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

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 384: ben_cpy_shd.constraint_error('DATETRACK-ERROR');

380: --
381: -- raise error as FK does not relate to PK in ben_pgm_f
382: -- table.
383: --
384: ben_cpy_shd.constraint_error('DATETRACK-ERROR');
385: --
386: end if;
387: --
388: close c1;

Line 440: l_api_updating := ben_cpy_shd.api_updating

436: Begin
437: --
438: hr_utility.set_location('Entering:'||l_proc,5);
439: --
440: l_api_updating := ben_cpy_shd.api_updating
441: (p_popl_yr_perd_id => p_popl_yr_perd_id,
442: p_object_version_number => p_object_version_number);
443: --
444: --Bug 3985729

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 467: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');

463: --
464: -- raise error as FK does not relate to PK in ben_yr_perd
465: -- table.
466: --
467: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');
468: --
469: end if;
470: --
471: close c1;

Line 579: l_api_updating := ben_cpy_shd.api_updating

575: Begin
576: --
577: hr_utility.set_location('Entering:'||l_proc,5);
578: --
579: l_api_updating := ben_cpy_shd.api_updating
580: (p_popl_yr_perd_id => p_popl_yr_perd_id,
581: p_object_version_number => p_object_version_number);
582: --
583: -- if p_py_clms_thru_dt is not filled in then we need to tell user we

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 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 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 631: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');

627: --
628: -- raise error as FK does not relate to PK in ben_yr_perd
629: -- table.
630: --
631: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');
632: --
633: end if;
634: --
635: -- compare acpt_clm_rqsts_dt to be sure it is greater or equal to

Line 714: l_api_updating := ben_cpy_shd.api_updating

710: Begin
711: --
712: hr_utility.set_location('Entering:'||l_proc,5);
713: --
714: l_api_updating := ben_cpy_shd.api_updating
715: (p_popl_yr_perd_id => p_popl_yr_perd_id,
716: p_object_version_number => p_object_version_number);
717: --
718: -- if p_py_clms_thru_dt is not filled in then we need to tell user we

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 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 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 749: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');

745: --
746: -- raise error as FK does not relate to PK in ben_yr_perd
747: -- table.
748: --
749: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');
750: --
751: end if;
752: --
753: -- compare py_clms_dt to be sure it is on or before (less than)

Line 788: if p_py_clms_thru_dt < ben_cpy_shd.g_old_rec.py_clms_thru_dt then

784: end if;
785: --
786: end if;
787: --
788: if p_py_clms_thru_dt < ben_cpy_shd.g_old_rec.py_clms_thru_dt then
789: --
790: open c_claims (ben_cpy_shd.g_old_rec.pl_id);
791: fetch c_claims into l_claims;
792: if c_claims%found then

Line 790: open c_claims (ben_cpy_shd.g_old_rec.pl_id);

786: end if;
787: --
788: if p_py_clms_thru_dt < ben_cpy_shd.g_old_rec.py_clms_thru_dt then
789: --
790: open c_claims (ben_cpy_shd.g_old_rec.pl_id);
791: fetch c_claims into l_claims;
792: if c_claims%found then
793: --
794: close c_claims;

Line 875: Procedure insert_validate(p_rec in ben_cpy_shd.g_rec_type) is

871: --
872: -- ----------------------------------------------------------------------------
873: -- |---------------------------< insert_validate >----------------------------|
874: -- ----------------------------------------------------------------------------
875: Procedure insert_validate(p_rec in ben_cpy_shd.g_rec_type) is
876: --
877: l_proc varchar2(72) := g_package||'insert_validate';
878: --
879: Begin

Line 938: Procedure update_validate(p_rec in ben_cpy_shd.g_rec_type) is

934: --
935: -- ----------------------------------------------------------------------------
936: -- |---------------------------< update_validate >----------------------------|
937: -- ----------------------------------------------------------------------------
938: Procedure update_validate(p_rec in ben_cpy_shd.g_rec_type) is
939: --
940: l_proc varchar2(72) := g_package||'update_validate';
941: --
942: Begin

Line 1001: Procedure delete_validate(p_rec in ben_cpy_shd.g_rec_type) is

997: --
998: -- ----------------------------------------------------------------------------
999: -- |---------------------------< delete_validate >----------------------------|
1000: -- ----------------------------------------------------------------------------
1001: Procedure delete_validate(p_rec in ben_cpy_shd.g_rec_type) is
1002: --
1003: l_proc varchar2(72) := g_package||'delete_validate';
1004: --
1005: Begin