DBA Data[Home] [Help]

APPS.BEN_BBP_BUS dependencies on BEN_BBP_SHD

Line 46: l_api_updating := ben_bbp_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_bbp_shd.api_updating
47: (p_batch_parameter_id => p_batch_parameter_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_bbp_shd.g_old_rec.batch_parameter_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_batch_parameter_id,hr_api.g_number)
52: <> ben_bbp_shd.g_old_rec.batch_parameter_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_bbp_shd.constraint_error('BEN_BATCH_PARAMETER_PK');

Line 56: ben_bbp_shd.constraint_error('BEN_BATCH_PARAMETER_PK');

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

Line 66: ben_bbp_shd.constraint_error('BEN_BATCH_PARAMETER_PK');

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

Line 114: l_api_updating := ben_bbp_shd.api_updating

110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := ben_bbp_shd.api_updating
115: (p_batch_parameter_id => p_batch_parameter_id,
116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating

Line 120: <> nvl(ben_bbp_shd.g_old_rec.batch_exe_cd,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_batch_exe_cd
120: <> nvl(ben_bbp_shd.g_old_rec.batch_exe_cd,hr_api.g_varchar2)
121: or not l_api_updating)
122: and p_batch_exe_cd is not null then
123: --
124: -- check if value of lookup falls within lookup type.

Line 185: l_api_updating := ben_bbp_shd.api_updating

181: Begin
182: --
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: l_api_updating := ben_bbp_shd.api_updating
186: (p_batch_parameter_id => p_batch_parameter_id,
187: p_object_version_number => p_object_version_number);
188: --
189: if (l_api_updating

Line 191: <> nvl(ben_bbp_shd.g_old_rec.thread_cnt_num,hr_api.g_number)

187: p_object_version_number => p_object_version_number);
188: --
189: if (l_api_updating
190: and p_thread_cnt_num
191: <> nvl(ben_bbp_shd.g_old_rec.thread_cnt_num,hr_api.g_number)
192: or not l_api_updating)
193: and p_thread_cnt_num is not null then
194: --
195: -- check if thread count between 1 and 80.

Line 210: <> nvl(ben_bbp_shd.g_old_rec.max_err_num,hr_api.g_number)

206: end if;
207: --
208: if (l_api_updating
209: and p_max_err_num
210: <> nvl(ben_bbp_shd.g_old_rec.max_err_num,hr_api.g_number)
211: or not l_api_updating)
212: and p_max_err_num is not null then
213: --
214: -- check if thread count between 1 and 80.

Line 229: <> nvl(ben_bbp_shd.g_old_rec.chunk_size,hr_api.g_number)

225: end if;
226: --
227: if (l_api_updating
228: and p_chunk_size
229: <> nvl(ben_bbp_shd.g_old_rec.chunk_size,hr_api.g_number)
230: or not l_api_updating)
231: and p_chunk_size is not null then
232: --
233: -- check if thread count between 1 and 80.

Line 297: l_api_updating := ben_bbp_shd.api_updating

293: Begin
294: --
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: l_api_updating := ben_bbp_shd.api_updating
298: (p_batch_parameter_id => p_batch_parameter_id,
299: p_object_version_number => p_object_version_number);
300: --
301: if (l_api_updating

Line 303: <> nvl(ben_bbp_shd.g_old_rec.batch_exe_cd,hr_api.g_varchar2)

299: p_object_version_number => p_object_version_number);
300: --
301: if (l_api_updating
302: and p_batch_exe_cd
303: <> nvl(ben_bbp_shd.g_old_rec.batch_exe_cd,hr_api.g_varchar2)
304: or not l_api_updating)
305: and p_batch_exe_cd is not null then
306: --
307: open c1;

Line 329: Procedure insert_validate(p_rec in ben_bbp_shd.g_rec_type

325: --
326: -- ----------------------------------------------------------------------------
327: -- |---------------------------< insert_validate >----------------------------|
328: -- ----------------------------------------------------------------------------
329: Procedure insert_validate(p_rec in ben_bbp_shd.g_rec_type
330: ,p_effective_date in date) is
331: --
332: l_proc varchar2(72) := g_package||'insert_validate';
333: --

Line 371: Procedure update_validate(p_rec in ben_bbp_shd.g_rec_type

367: --
368: -- ----------------------------------------------------------------------------
369: -- |---------------------------< update_validate >----------------------------|
370: -- ----------------------------------------------------------------------------
371: Procedure update_validate(p_rec in ben_bbp_shd.g_rec_type
372: ,p_effective_date in date) is
373: --
374: l_proc varchar2(72) := g_package||'update_validate';
375: --

Line 413: Procedure delete_validate(p_rec in ben_bbp_shd.g_rec_type

409: --
410: -- ----------------------------------------------------------------------------
411: -- |---------------------------< delete_validate >----------------------------|
412: -- ----------------------------------------------------------------------------
413: Procedure delete_validate(p_rec in ben_bbp_shd.g_rec_type
414: ,p_effective_date in date) is
415: --
416: l_proc varchar2(72) := g_package||'delete_validate';
417: --