DBA Data[Home] [Help]

APPS.PAY_TFU_BUS dependencies on PAY_TFU_SHD

Line 46: ,p_rec in pay_tfu_shd.g_rec_type

42: -- {End Of Comments}
43: -- ----------------------------------------------------------------------------
44: Procedure chk_non_updateable_args
45: (p_effective_date in date
46: ,p_rec in pay_tfu_shd.g_rec_type
47: ) IS
48: --
49: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
50: l_argument varchar2(30);

Line 58: IF NOT pay_tfu_shd.api_updating

54: --
55: -- Only proceed with the validation if a row exists for the current
56: -- record in the HR Schema.
57: --
58: IF NOT pay_tfu_shd.api_updating
59: (p_template_ff_usage_id => p_rec.template_ff_usage_id
60: ,p_object_version_number => p_rec.object_version_number
61: ) THEN
62: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 71: nvl(pay_tfu_shd.g_old_rec.template_id, hr_api.g_number)

67: --
68: -- p_template_id
69: --
70: if nvl(p_rec.template_id, hr_api.g_number) <>
71: nvl(pay_tfu_shd.g_old_rec.template_id, hr_api.g_number)
72: then
73: l_argument := 'p_template_id';
74: raise l_error;
75: end if;

Line 118: l_api_updating := pay_tfu_shd.api_updating

114: l_proc varchar2(72) := g_package||'chk_unique';
115: l_exists varchar2(1);
116: --
117: Begin
118: l_api_updating := pay_tfu_shd.api_updating
119: (p_template_ff_usage_id => p_template_ff_usage_id
120: ,p_object_version_number => p_object_version_number
121: );
122: if l_api_updating and

Line 125: nvl(pay_tfu_shd.g_old_rec.object_id, hr_api.g_number) or

121: );
122: if l_api_updating and
123: (
124: nvl(p_object_id, hr_api.g_number) <>
125: nvl(pay_tfu_shd.g_old_rec.object_id, hr_api.g_number) or
126: nvl(p_formula_id, hr_api.g_number) <>
127: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)
128: ) or
129: not l_api_updating then

Line 127: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)

123: (
124: nvl(p_object_id, hr_api.g_number) <>
125: nvl(pay_tfu_shd.g_old_rec.object_id, hr_api.g_number) or
126: nvl(p_formula_id, hr_api.g_number) <>
127: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)
128: ) or
129: not l_api_updating then
130: open csr_uniqueness_chk
131: (p_template_ff_usage_id => nvl(p_template_ff_usage_id, hr_api.g_number)

Line 255: l_api_updating := pay_tfu_shd.api_updating

251: ,p_argument => 'exclusion_rule_id'
252: ,p_argument_value => p_exclusion_rule_id
253: );
254: --
255: l_api_updating := pay_tfu_shd.api_updating
256: (p_template_ff_usage_id => p_template_ff_usage_id
257: ,p_object_version_number => p_object_version_number
258: );
259: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 260: nvl(pay_tfu_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

256: (p_template_ff_usage_id => p_template_ff_usage_id
257: ,p_object_version_number => p_object_version_number
258: );
259: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
260: nvl(pay_tfu_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
261: not l_api_updating
262: then
263: if p_exclusion_rule_id is not null then
264: open csr_exclusion_rule_id_valid;

Line 313: l_api_updating := pay_tfu_shd.api_updating

309: l_api_updating boolean;
310: l_valid varchar2(1);
311: --
312: Begin
313: l_api_updating := pay_tfu_shd.api_updating
314: (p_template_ff_usage_id => p_template_ff_usage_id
315: ,p_object_version_number => p_object_version_number
316: );
317: if (l_api_updating and nvl(p_formula_id, hr_api.g_number) <>

Line 318: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)) or

314: (p_template_ff_usage_id => p_template_ff_usage_id
315: ,p_object_version_number => p_object_version_number
316: );
317: if (l_api_updating and nvl(p_formula_id, hr_api.g_number) <>
318: nvl(pay_tfu_shd.g_old_rec.formula_id, hr_api.g_number)) or
319: not l_api_updating
320: then
321: if p_formula_id is not null then
322: open csr_formula_valid;

Line 338: ,p_rec in pay_tfu_shd.g_rec_type

334: -- |---------------------------< insert_validate >----------------------------|
335: -- ----------------------------------------------------------------------------
336: Procedure insert_validate
337: (p_effective_date in date
338: ,p_rec in pay_tfu_shd.g_rec_type
339: ) is
340: --
341: l_proc varchar2(72) := g_package||'insert_validate';
342: l_leg_code varchar2(30);

Line 390: ,p_rec in pay_tfu_shd.g_rec_type

386: -- |---------------------------< update_validate >----------------------------|
387: -- ----------------------------------------------------------------------------
388: Procedure update_validate
389: (p_effective_date in date
390: ,p_rec in pay_tfu_shd.g_rec_type
391: ) is
392: --
393: l_proc varchar2(72) := g_package||'update_validate';
394: --

Line 449: (p_rec in pay_tfu_shd.g_rec_type

445: -- ----------------------------------------------------------------------------
446: -- |---------------------------< delete_validate >----------------------------|
447: -- ----------------------------------------------------------------------------
448: Procedure delete_validate
449: (p_rec in pay_tfu_shd.g_rec_type
450: ) is
451: --
452: l_proc varchar2(72) := g_package||'delete_validate';
453: --