DBA Data[Home] [Help]

APPS.BEN_ERG_BUS dependencies on BEN_ERG_SHD

Line 49: l_api_updating := ben_erg_shd.api_updating

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

Line 56: <> ben_erg_shd.g_old_rec.ELIG_PERF_RTNG_PRTE_id) then

52: p_object_version_number => p_object_version_number);
53: --
54: if (l_api_updating
55: and nvl(p_ELIG_PERF_RTNG_PRTE_id,hr_api.g_number)
56: <> ben_erg_shd.g_old_rec.ELIG_PERF_RTNG_PRTE_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_erg_shd.constraint_error('BEN_ELIG_PERF_RTNG_PRTE_F_PK');

Line 60: ben_erg_shd.constraint_error('BEN_ELIG_PERF_RTNG_PRTE_F_PK');

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

Line 70: ben_erg_shd.constraint_error('BEN_ELIG_PERF_RTNG_PRTE_F_PK');

66: if p_ELIG_PERF_RTNG_PRTE_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_erg_shd.constraint_error('BEN_ELIG_PERF_RTNG_PRTE_F_PK');
71: --
72: end if;
73: --
74: end if;

Line 118: l_api_updating := ben_erg_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_erg_shd.api_updating
119: (p_ELIG_PERF_RTNG_PRTE_id => p_ELIG_PERF_RTNG_PRTE_id,
120: p_effective_date => p_effective_date,
121: p_object_version_number => p_object_version_number);
122: --

Line 125: <> nvl(ben_erg_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 191: l_api_updating := ben_erg_shd.api_updating

187: Begin
188: --
189: hr_utility.set_location('Entering:'||l_proc,5);
190: --
191: l_api_updating := ben_erg_shd.api_updating
192: (p_ELIG_PERF_RTNG_PRTE_id => p_ELIG_PERF_RTNG_PRTE_id,
193: p_effective_date => p_effective_date,
194: p_object_version_number => p_object_version_number);
195: --

Line 198: <> nvl(ben_erg_shd.g_old_rec.event_type,hr_api.g_varchar2)

194: p_object_version_number => p_object_version_number);
195: --
196: if (l_api_updating
197: and nvl(p_event_type,hr_api.g_varchar2)
198: <> nvl(ben_erg_shd.g_old_rec.event_type,hr_api.g_varchar2)
199: or not l_api_updating)
200: and p_event_type is not null
201: and p_event_type <> '-1' /* Bug 4031314 : Enter Event Type as -1, when user does not select it */
202: then

Line 269: l_api_updating := ben_erg_shd.api_updating

265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc,5);
268: --
269: l_api_updating := ben_erg_shd.api_updating
270: (p_ELIG_PERF_RTNG_PRTE_id => p_ELIG_PERF_RTNG_PRTE_id,
271: p_effective_date => p_effective_date,
272: p_object_version_number => p_object_version_number);
273: --

Line 276: <> nvl(ben_erg_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)

272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_perf_rtng_cd,hr_api.g_varchar2)
276: <> nvl(ben_erg_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)
277: or not l_api_updating)
278: and p_perf_rtng_cd is not null then
279: --
280: -- check if value of lookup falls within lookup type.

Line 642: (p_rec in ben_erg_shd.g_rec_type,

638: -- ----------------------------------------------------------------------------
639: -- |---------------------------< insert_validate >----------------------------|
640: -- ----------------------------------------------------------------------------
641: Procedure insert_validate
642: (p_rec in ben_erg_shd.g_rec_type,
643: p_effective_date in date,
644: p_datetrack_mode in varchar2,
645: p_validation_start_date in date,
646: p_validation_end_date in date) is

Line 703: (p_rec in ben_erg_shd.g_rec_type,

699: -- ----------------------------------------------------------------------------
700: -- |---------------------------< update_validate >----------------------------|
701: -- ----------------------------------------------------------------------------
702: Procedure update_validate
703: (p_rec in ben_erg_shd.g_rec_type,
704: p_effective_date in date,
705: p_datetrack_mode in varchar2,
706: p_validation_start_date in date,
707: p_validation_end_date in date) is

Line 772: (p_rec in ben_erg_shd.g_rec_type,

768: -- ----------------------------------------------------------------------------
769: -- |---------------------------< delete_validate >----------------------------|
770: -- ----------------------------------------------------------------------------
771: Procedure delete_validate
772: (p_rec in ben_erg_shd.g_rec_type,
773: p_effective_date in date,
774: p_datetrack_mode in varchar2,
775: p_validation_start_date in date,
776: p_validation_end_date in date) is