APPS.PAY_SBT_BUS dependencies on PAY_SBT_SHD

Line 44: (p_rec in pay_sbt_shd.g_rec_type

40: -- ----------------------------------------------------------------------------
41: -- |-----------------------< chk_non_updateable_args >------------------------|
42: -- ----------------------------------------------------------------------------
43: Procedure chk_non_updateable_args
44: (p_rec in pay_sbt_shd.g_rec_type
45: ) is
46: --
47: -- Cursor to disallow update if a balance has been generated from
48: -- this shadow balance.

Line 72: l_api_updating := pay_sbt_shd.api_updating

68: l_disallow varchar2(1);
69: --
70: Begin
71: hr_utility.set_location('Entering:'||l_proc, 5);
72: l_api_updating := pay_sbt_shd.api_updating
73: (p_balance_type_id => p_rec.balance_type_id
74: ,p_object_version_number => p_rec.object_version_number
75: );
76: if not l_api_updating then

Line 102: nvl(pay_sbt_shd.g_old_rec.template_id, hr_api.g_number)

98: --
99: -- p_template_id
100: --
101: if nvl(p_rec.template_id, hr_api.g_number) <>
102: nvl(pay_sbt_shd.g_old_rec.template_id, hr_api.g_number)
103: then
104: l_argument := 'p_template_id';
105: raise l_error;
106: end if;

Line 111: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)

107: --
108: -- p_balance_uom
109: --
110: if nvl(p_rec.balance_uom, hr_api.g_varchar2) <>
111: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)
112: then
113: --
114: -- Check to see if the update is allowed.
115: --

Line 129: nvl(pay_sbt_shd.g_old_rec.input_value_id, hr_api.g_number)

125: --
126: -- p_input_value_id
127: --
128: if nvl(p_rec.input_value_id, hr_api.g_number) <>
129: nvl(pay_sbt_shd.g_old_rec.input_value_id, hr_api.g_number)
130: then
131: l_argument := 'input_value_id';
132: raise l_error;
133: end if;

Line 231: l_api_updating := pay_sbt_shd.api_updating

227: l_api_updating boolean;
228: --
229: Begin
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: l_api_updating := pay_sbt_shd.api_updating
232: (p_balance_type_id => p_balance_type_id
233: ,p_object_version_number => p_object_version_number
234: );
235: if (l_api_updating and nvl(p_balance_name, hr_api.g_varchar2) <>

Line 236: nvl(pay_sbt_shd.g_old_rec.balance_name, hr_api.g_varchar2)) or

232: (p_balance_type_id => p_balance_type_id
233: ,p_object_version_number => p_object_version_number
234: );
235: if (l_api_updating and nvl(p_balance_name, hr_api.g_varchar2) <>
236: nvl(pay_sbt_shd.g_old_rec.balance_name, hr_api.g_varchar2)) or
237: not l_api_updating
238: then
239: --
240: -- The name cannot be null if the template type is 'U'.

Line 318: l_api_updating := pay_sbt_shd.api_updating

314: l_api_updating boolean;
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: l_api_updating := pay_sbt_shd.api_updating
319: (p_balance_type_id => p_balance_type_id
320: ,p_object_version_number => p_object_version_number
321: );
322: if (l_api_updating and

Line 324: nvl(pay_sbt_shd.g_old_rec.assignment_remuneration_flag,

320: ,p_object_version_number => p_object_version_number
321: );
322: if (l_api_updating and
323: nvl(p_assignment_remuneration_flag, hr_api.g_varchar2) <>
324: nvl(pay_sbt_shd.g_old_rec.assignment_remuneration_flag,
325: hr_api.g_varchar2)) or
326: not l_api_updating
327: then
328: --

Line 379: l_api_updating := pay_sbt_shd.api_updating

375: and upper(siv.uom) = upper(p_balance_uom);
376: --
377: Begin
378: hr_utility.set_location('Entering:'||l_proc, 5);
379: l_api_updating := pay_sbt_shd.api_updating
380: (p_balance_type_id => p_balance_type_id
381: ,p_object_version_number => p_object_version_number
382: );
383: if (l_api_updating and nvl(p_balance_uom, hr_api.g_varchar2) <>

Line 384: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) or

380: (p_balance_type_id => p_balance_type_id
381: ,p_object_version_number => p_object_version_number
382: );
383: if (l_api_updating and nvl(p_balance_uom, hr_api.g_varchar2) <>
384: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) or
385: not l_api_updating
386: then
387: --
388: -- Check that the core object type is not null.

Line 413: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) and

409: end if;
410: end if;
411: --
412: if (l_api_updating and nvl(p_balance_uom, hr_api.g_varchar2) <>
413: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) and
414: (p_input_value_id is not null) then
415: --
416: -- Check that the UOMs are compatible
417: --

Line 455: l_api_updating := pay_sbt_shd.api_updating

451: l_valid varchar2(1);
452: --
453: Begin
454: hr_utility.set_location('Entering:'||l_proc, 5);
455: l_api_updating := pay_sbt_shd.api_updating
456: (p_balance_type_id => p_balance_type_id
457: ,p_object_version_number => p_object_version_number
458: );
459: if (l_api_updating and nvl(p_currency_code, hr_api.g_varchar2) <>

Line 460: nvl(pay_sbt_shd.g_old_rec.currency_code, hr_api.g_varchar2)) or

456: (p_balance_type_id => p_balance_type_id
457: ,p_object_version_number => p_object_version_number
458: );
459: if (l_api_updating and nvl(p_currency_code, hr_api.g_varchar2) <>
460: nvl(pay_sbt_shd.g_old_rec.currency_code, hr_api.g_varchar2)) or
461: not l_api_updating
462: then
463: if p_currency_code is not null then
464: open csr_valid_currency_code;

Line 501: l_api_updating := pay_sbt_shd.api_updating

497: l_valid varchar2(1);
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: l_api_updating := pay_sbt_shd.api_updating
502: (p_balance_type_id => p_balance_type_id
503: ,p_object_version_number => p_object_version_number
504: );
505: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 506: nvl(pay_sbt_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

502: (p_balance_type_id => p_balance_type_id
503: ,p_object_version_number => p_object_version_number
504: );
505: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
506: nvl(pay_sbt_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
507: not l_api_updating
508: then
509: if p_exclusion_rule_id is not null then
510: open csr_exclusion_rule_id_valid;

Line 553: l_api_updating := pay_sbt_shd.api_updating

549: ;
550: Begin
551: hr_utility.set_location('Entering: '||l_proc, 5);
552: --
553: l_api_updating := pay_sbt_shd.api_updating
554: (p_balance_type_id => p_balance_type_id
555: ,p_object_version_number => p_object_version_number
556: );
557:

Line 559: nvl(pay_sbt_shd.g_old_rec.base_balance_type_id, hr_api.g_number)) or

555: ,p_object_version_number => p_object_version_number
556: );
557:
558: if (l_api_updating and nvl(p_base_balance_type_id, hr_api.g_number) <>
559: nvl(pay_sbt_shd.g_old_rec.base_balance_type_id, hr_api.g_number)) or
560: not l_api_updating
561: then
562: --
563: -- Only one of the base_balance_name and base_balance_type_id may be

Line 782: ,p_rec in pay_sbt_shd.g_rec_type

778: -- |---------------------------< insert_validate >----------------------------|
779: -- ----------------------------------------------------------------------------
780: Procedure insert_validate
781: (p_effective_date in date
782: ,p_rec in pay_sbt_shd.g_rec_type
783: ) is
784: --
785: l_proc varchar2(72) := g_package||'insert_validate';
786: l_business_group_id number;

Line 861: ,p_rec in pay_sbt_shd.g_rec_type

857: -- |---------------------------< update_validate >----------------------------|
858: -- ----------------------------------------------------------------------------
859: Procedure update_validate
860: (p_effective_date in date
861: ,p_rec in pay_sbt_shd.g_rec_type
862: ) is
863: --
864: l_proc varchar2(72) := g_package||'update_validate';
865: l_business_group_id number;

Line 932: Procedure delete_validate(p_rec in pay_sbt_shd.g_rec_type) is

928: --
929: -- ----------------------------------------------------------------------------
930: -- |---------------------------< delete_validate >----------------------------|
931: -- ----------------------------------------------------------------------------
932: Procedure delete_validate(p_rec in pay_sbt_shd.g_rec_type) is
933: --
934: l_proc varchar2(72) := g_package||'delete_validate';
935: --
936: Begin