DBA Data[Home] [Help]

APPS.PAY_SDB_BUS dependencies on PAY_SDB_SHD

Line 14: (p_rec in pay_sdb_shd.g_rec_type

10: -- ----------------------------------------------------------------------------
11: -- |-----------------------< chk_non_updateable_args >------------------------|
12: -- ----------------------------------------------------------------------------
13: Procedure chk_non_updateable_args
14: (p_rec in pay_sdb_shd.g_rec_type
15: ) is
16: --
17: -- Cursor to disallow update if a core defined balance has been
18: -- generated from this shadow defined balance.

Line 35: l_api_updating := pay_sdb_shd.api_updating

31: l_disallow varchar2(1);
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: l_api_updating := pay_sdb_shd.api_updating
36: (p_defined_balance_id => p_rec.defined_balance_id
37: ,p_object_version_number => p_rec.object_version_number
38: );
39: if not l_api_updating then

Line 63: nvl(pay_sdb_shd.g_old_rec.balance_type_id, hr_api.g_number)

59: --
60: -- p_balance_type_id
61: --
62: if nvl(p_rec.balance_type_id, hr_api.g_number) <>
63: nvl(pay_sdb_shd.g_old_rec.balance_type_id, hr_api.g_number)
64: then
65: hr_utility.set_location(l_proc, 25);
66: l_argument := 'p_balance_type_id';
67: raise l_error;

Line 107: l_api_updating := pay_sdb_shd.api_updating

103: l_valid varchar2(1);
104: --
105: Begin
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: l_api_updating := pay_sdb_shd.api_updating
108: (p_defined_balance_id => p_defined_balance_id
109: ,p_object_version_number => p_object_version_number
110: );
111: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 112: nvl(pay_sdb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

108: (p_defined_balance_id => p_defined_balance_id
109: ,p_object_version_number => p_object_version_number
110: );
111: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
112: nvl(pay_sdb_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
113: not l_api_updating
114: then
115: if p_exclusion_rule_id is not null then
116: open csr_exclusion_rule_id_valid;

Line 195: l_api_updating := pay_sdb_shd.api_updating

191: l_exists varchar2(1);
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: l_api_updating := pay_sdb_shd.api_updating
196: (p_defined_balance_id => p_defined_balance_id
197: ,p_object_version_number => p_object_version_number
198: );
199: if (l_api_updating and nvl(p_dimension_name, hr_api.g_varchar2)

Line 200: <> nvl(pay_sdb_shd.g_old_rec.dimension_name, hr_api.g_varchar2))

196: (p_defined_balance_id => p_defined_balance_id
197: ,p_object_version_number => p_object_version_number
198: );
199: if (l_api_updating and nvl(p_dimension_name, hr_api.g_varchar2)
200: <> nvl(pay_sdb_shd.g_old_rec.dimension_name, hr_api.g_varchar2))
201: or not l_api_updating
202: then
203: --
204: -- Check that the balance dimension is not null.

Line 241: l_api_updating := pay_sdb_shd.api_updating

237: l_api_updating boolean;
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: l_api_updating := pay_sdb_shd.api_updating
242: (p_defined_balance_id => p_defined_balance_id
243: ,p_object_version_number => p_object_version_number
244: );
245: if (l_api_updating and

Line 247: nvl(pay_sdb_shd.g_old_rec.force_latest_balance_flag, hr_api.g_varchar2))

243: ,p_object_version_number => p_object_version_number
244: );
245: if (l_api_updating and
246: nvl(p_force_latest_balance_flag, hr_api.g_varchar2) <>
247: nvl(pay_sdb_shd.g_old_rec.force_latest_balance_flag, hr_api.g_varchar2))
248: or not l_api_updating
249: then
250: if p_force_latest_balance_flag is not null then
251: --

Line 285: l_api_updating := pay_sdb_shd.api_updating

281: l_api_updating boolean;
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: l_api_updating := pay_sdb_shd.api_updating
286: (p_defined_balance_id => p_defined_balance_id
287: ,p_object_version_number => p_object_version_number
288: );
289: if (l_api_updating and

Line 291: nvl(pay_sdb_shd.g_old_rec.grossup_allowed_flag, hr_api.g_varchar2))

287: ,p_object_version_number => p_object_version_number
288: );
289: if (l_api_updating and
290: nvl(p_grossup_allowed_flag, hr_api.g_varchar2) <>
291: nvl(pay_sdb_shd.g_old_rec.grossup_allowed_flag, hr_api.g_varchar2))
292: or not l_api_updating
293: then
294: if p_grossup_allowed_flag is not null then
295: --

Line 373: ,p_rec in pay_sdb_shd.g_rec_type

369: -- |---------------------------< insert_validate >----------------------------|
370: -- ----------------------------------------------------------------------------
371: Procedure insert_validate
372: (p_effective_date in date
373: ,p_rec in pay_sdb_shd.g_rec_type
374: ) is
375: --
376: l_proc varchar2(72) := g_package||'insert_validate';
377: --

Line 420: ,p_rec in pay_sdb_shd.g_rec_type

416: -- |---------------------------< update_validate >----------------------------|
417: -- ----------------------------------------------------------------------------
418: Procedure update_validate
419: (p_effective_date in date
420: ,p_rec in pay_sdb_shd.g_rec_type
421: ) is
422: --
423: l_proc varchar2(72) := g_package||'update_validate';
424: --

Line 466: Procedure delete_validate(p_rec in pay_sdb_shd.g_rec_type) is

462: --
463: -- ----------------------------------------------------------------------------
464: -- |---------------------------< delete_validate >----------------------------|
465: -- ----------------------------------------------------------------------------
466: Procedure delete_validate(p_rec in pay_sdb_shd.g_rec_type) is
467: --
468: l_proc varchar2(72) := g_package||'delete_validate';
469: --
470: Begin