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_CGP_BUS dependencies on BEN_CGP_SHD

Line 48: l_api_updating := ben_cgp_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_cgp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_cntng_prtn_elig_prfl_id => p_cntng_prtn_elig_prfl_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_cgp_shd.g_old_rec.cntng_prtn_elig_prfl_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_cntng_prtn_elig_prfl_id,hr_api.g_number)
55: <> ben_cgp_shd.g_old_rec.cntng_prtn_elig_prfl_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_cgp_shd.constraint_error('BEN_CNTNG_PRTN_PK');

Line 59: ben_cgp_shd.constraint_error('BEN_CNTNG_PRTN_PK');

55: <> ben_cgp_shd.g_old_rec.cntng_prtn_elig_prfl_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_cgp_shd.constraint_error('BEN_CNTNG_PRTN_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_cgp_shd.constraint_error('BEN_CNTNG_PRTN_PK');

65: if p_cntng_prtn_elig_prfl_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_cgp_shd.constraint_error('BEN_CNTNG_PRTN_PK');
70: --
71: end if;
72: --
73: end if;

Line 134: l_api_updating := ben_cgp_shd.api_updating

130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_cgp_shd.api_updating
135: (p_cntng_prtn_elig_prfl_id => p_cntng_prtn_elig_prfl_id,
136: p_effective_date => p_effective_date,
137: p_object_version_number => p_object_version_number);
138: --

Line 141: <> ben_cgp_shd.g_old_rec.cntng_frmr_prtt_dsge_rl

137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and nvl(p_cntng_frmr_prtt_dsge_rl,hr_api.g_number)
141: <> ben_cgp_shd.g_old_rec.cntng_frmr_prtt_dsge_rl
142: or not l_api_updating)
143: and p_cntng_frmr_prtt_dsge_rl is not null then
144: --
145: -- check if value of formula rule is valid.

Line 219: l_api_updating := ben_cgp_shd.api_updating

215: Begin
216: --
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: l_api_updating := ben_cgp_shd.api_updating
220: (p_cntng_prtn_elig_prfl_id => p_cntng_prtn_elig_prfl_id,
221: p_effective_date => p_effective_date,
222: p_object_version_number => p_object_version_number);
223: --

Line 226: <> ben_cgp_shd.g_old_rec.cntng_frmr_prtt_rl

222: p_object_version_number => p_object_version_number);
223: --
224: if (l_api_updating
225: and nvl(p_cntng_frmr_prtt_rl,hr_api.g_number)
226: <> ben_cgp_shd.g_old_rec.cntng_frmr_prtt_rl
227: or not l_api_updating)
228: and p_cntng_frmr_prtt_rl is not null then
229: --
230: -- check if value of formula rule is valid.

Line 295: l_api_updating := ben_cgp_shd.api_updating

291: Begin
292: --
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: l_api_updating := ben_cgp_shd.api_updating
296: (p_cntng_prtn_elig_prfl_id => p_cntng_prtn_elig_prfl_id,
297: p_effective_date => p_effective_date,
298: p_object_version_number => p_object_version_number);
299: --

Line 302: <> nvl(ben_cgp_shd.g_old_rec.dsge_must_be_redsgd_flag,hr_api.g_varchar2)

298: p_object_version_number => p_object_version_number);
299: --
300: if (l_api_updating
301: and p_dsge_must_be_redsgd_flag
302: <> nvl(ben_cgp_shd.g_old_rec.dsge_must_be_redsgd_flag,hr_api.g_varchar2)
303: or not l_api_updating) then
304: --
305: -- check if value of lookup falls within lookup type.
306: --

Line 382: l_api_updating := ben_cgp_shd.api_updating

378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: l_api_updating := ben_cgp_shd.api_updating
383: (p_cntng_prtn_elig_prfl_id => p_cntng_prtn_elig_prfl_id,
384: p_effective_date => p_effective_date,
385: p_object_version_number => p_object_version_number);
386: --

Line 389: <> ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl

385: p_object_version_number => p_object_version_number);
386: --
387: if (l_api_updating
388: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)
389: <> ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl
390: or not l_api_updating)
391: and p_pymt_must_be_rcvd_rl is not null then
392: --
393: -- check if value of formula rule is valid.

Line 461: l_api_updating := ben_cgp_shd.api_updating

457: Begin
458: --
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: l_api_updating := ben_cgp_shd.api_updating
462: (p_cntng_prtn_elig_prfl_id => p_cntng_prtn_elig_prfl_id,
463: p_effective_date => p_effective_date,
464: p_object_version_number => p_object_version_number);
465: --

Line 468: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom,hr_api.g_varchar2)

464: p_object_version_number => p_object_version_number);
465: --
466: if (l_api_updating
467: and p_pymt_must_be_rcvd_uom
468: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom,hr_api.g_varchar2)
469: or not l_api_updating) then
470: --
471: -- check if value of lookup falls within lookup type.
472: --

Line 541: l_api_updating := ben_cgp_shd.api_updating

537: Begin
538: --
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: l_api_updating := ben_cgp_shd.api_updating
542: (p_cntng_prtn_elig_prfl_id => p_cntng_prtn_elig_prfl_id,
543: p_effective_date => p_effective_date,
544: p_object_version_number => p_object_version_number);
545: --

Line 548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or

544: p_object_version_number => p_object_version_number);
545: --
546: if (l_api_updating
547: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)
548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or
549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)
550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or
551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)
552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)

Line 550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or

546: if (l_api_updating
547: and nvl(p_pymt_must_be_rcvd_rl,hr_api.g_number)
548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or
549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)
550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or
551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)
552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)
553: or not l_api_updating) then
554: --

Line 552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)

548: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_rl, hr_api.g_number) or
549: nvl(p_pymt_must_be_rcvd_num,hr_api.g_number)
550: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_num, hr_api.g_number) or
551: nvl(p_pymt_must_be_rcvd_uom,hr_api.g_varchar2)
552: <> nvl(ben_cgp_shd.g_old_rec.pymt_must_be_rcvd_uom, hr_api.g_varchar2)
553: or not l_api_updating) then
554: --
555: if (p_pymt_must_be_rcvd_num is not null and p_pymt_must_be_rcvd_uom is null) then
556: -- num without uom - raise error

Line 795: (p_rec in ben_cgp_shd.g_rec_type,

791: -- ----------------------------------------------------------------------------
792: -- |---------------------------< insert_validate >----------------------------|
793: -- ----------------------------------------------------------------------------
794: Procedure insert_validate
795: (p_rec in ben_cgp_shd.g_rec_type,
796: p_effective_date in date,
797: p_datetrack_mode in varchar2,
798: p_validation_start_date in date,
799: p_validation_end_date in date) is

Line 864: (p_rec in ben_cgp_shd.g_rec_type,

860: -- ----------------------------------------------------------------------------
861: -- |---------------------------< update_validate >----------------------------|
862: -- ----------------------------------------------------------------------------
863: Procedure update_validate
864: (p_rec in ben_cgp_shd.g_rec_type,
865: p_effective_date in date,
866: p_datetrack_mode in varchar2,
867: p_validation_start_date in date,
868: p_validation_end_date in date) is

Line 943: (p_rec in ben_cgp_shd.g_rec_type,

939: -- ----------------------------------------------------------------------------
940: -- |---------------------------< delete_validate >----------------------------|
941: -- ----------------------------------------------------------------------------
942: Procedure delete_validate
943: (p_rec in ben_cgp_shd.g_rec_type,
944: p_effective_date in date,
945: p_datetrack_mode in varchar2,
946: p_validation_start_date in date,
947: p_validation_end_date in date) is