DBA Data[Home] [Help]

APPS.PAY_PBA_BUS dependencies on PAY_PBA_SHD

Line 359: nvl(pay_pba_shd.g_old_rec.attribute_id, hr_api.g_number) <>

355: -- primary key value. For update it will be not null. For insert it will be
356: -- null, because pre_inset has not been called yet.
357: --
358: IF (((p_balance_attribute_id is not null) and
359: nvl(pay_pba_shd.g_old_rec.attribute_id, hr_api.g_number) <>
360: nvl(p_attribute_id, hr_api.g_number))
361: or
362: (p_balance_attribute_id is null)) then
363: --

Line 515: nvl(pay_pba_shd.g_old_rec.defined_balance_id, hr_api.g_number) <>

511: --
512: -- Only execute the cursor if absolutely necessary.
513: --
514: IF (((p_balance_attribute_id is not null) and
515: nvl(pay_pba_shd.g_old_rec.defined_balance_id, hr_api.g_number) <>
516: nvl(p_defined_balance_id, hr_api.g_number))
517: or
518: (p_balance_attribute_id is null)) then
519: --

Line 610: (p_rec in pay_pba_shd.g_rec_type

606: --
607: -- {End Of Comments}
608: -- ----------------------------------------------------------------------------
609: Procedure chk_non_updateable_args
610: (p_rec in pay_pba_shd.g_rec_type
611: ) IS
612: --
613: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
614: l_error EXCEPTION;

Line 622: IF NOT pay_pba_shd.api_updating

618: --
619: -- Only proceed with the validation if a row exists for the current
620: -- record in the HR Schema.
621: --
622: IF NOT pay_pba_shd.api_updating
623: (p_balance_attribute_id => p_rec.balance_attribute_id
624: ) THEN
625: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
626: fnd_message.set_token('PROCEDURE ', l_proc);

Line 632: nvl(pay_pba_shd.g_old_rec.business_group_id, hr_api.g_number) then

628: fnd_message.raise_error;
629: END IF;
630: --
631: if nvl(p_rec.business_group_id, hr_api.g_number) <>
632: nvl(pay_pba_shd.g_old_rec.business_group_id, hr_api.g_number) then
633: l_argument := 'business_group_id';
634: raise l_error;
635: end if;
636: hr_utility.set_location(l_proc, 15);

Line 638: if p_rec.balance_attribute_id <> pay_pba_shd.g_old_rec.balance_attribute_id

634: raise l_error;
635: end if;
636: hr_utility.set_location(l_proc, 15);
637: --
638: if p_rec.balance_attribute_id <> pay_pba_shd.g_old_rec.balance_attribute_id
639: then
640: l_argument := 'balance_attribute_id';
641: raise l_error;
642: end if;

Line 645: if p_rec.attribute_id <> pay_pba_shd.g_old_rec.attribute_id

641: raise l_error;
642: end if;
643: hr_utility.set_location(l_proc, 20);
644: --
645: if p_rec.attribute_id <> pay_pba_shd.g_old_rec.attribute_id
646: then
647: l_argument := 'attribute_id';
648: raise l_error;
649: end if;

Line 652: if p_rec.legislation_code <> pay_pba_shd.g_old_rec.legislation_code then

648: raise l_error;
649: end if;
650: hr_utility.set_location(l_proc, 25);
651: --
652: if p_rec.legislation_code <> pay_pba_shd.g_old_rec.legislation_code then
653: l_argument := 'legislation_code';
654: raise l_error;
655: end if;
656: hr_utility.set_location(l_proc, 30);

Line 658: if p_rec.defined_balance_id <> pay_pba_shd.g_old_rec.defined_balance_id then

654: raise l_error;
655: end if;
656: hr_utility.set_location(l_proc, 30);
657: --
658: if p_rec.defined_balance_id <> pay_pba_shd.g_old_rec.defined_balance_id then
659: l_argument := 'defined_balance_id';
660: raise l_error;
661: end if;
662: hr_utility.set_location(l_proc, 35);

Line 712: (p_rec in pay_pba_shd.g_rec_type

708: -- ----------------------------------------------------------------------------
709: -- |---------------------------< insert_validate >----------------------------|
710: -- ----------------------------------------------------------------------------
711: Procedure insert_validate
712: (p_rec in pay_pba_shd.g_rec_type
713: ) is
714: --
715: l_proc varchar2(72) := g_package||'insert_validate';
716: --

Line 734: ,p_associated_column1 => pay_pba_shd.g_tab_nam

730: -- Validate Important Attributes
731: --
732: hr_api.validate_bus_grp_id
733: (p_business_group_id => p_rec.business_group_id
734: ,p_associated_column1 => pay_pba_shd.g_tab_nam
735: || '.BUSINESS_GROUP_ID');
736: --
737: -- after validating the set of important attributes,
738: -- if Multiple Message Detection is enabled and at least

Line 781: (p_rec in pay_pba_shd.g_rec_type

777: -- ----------------------------------------------------------------------------
778: -- |---------------------------< delete_validate >----------------------------|
779: -- ----------------------------------------------------------------------------
780: Procedure delete_validate
781: (p_rec in pay_pba_shd.g_rec_type
782: ) is
783: --
784: l_proc varchar2(72) := g_package||'delete_validate';
785: --

Line 793: ,pay_pba_shd.g_old_rec.business_group_id

789: -- NB. need to use g_old_rec, as p_rec is not pupulated with all the columns
790: -- for delete mode.
791: --
792: chk_startup_action(false
793: ,pay_pba_shd.g_old_rec.business_group_id
794: ,pay_pba_shd.g_old_rec.legislation_code
795: );
796: IF hr_startup_data_api_support.g_startup_mode
797: NOT IN ('GENERIC','STARTUP') THEN

Line 794: ,pay_pba_shd.g_old_rec.legislation_code

790: -- for delete mode.
791: --
792: chk_startup_action(false
793: ,pay_pba_shd.g_old_rec.business_group_id
794: ,pay_pba_shd.g_old_rec.legislation_code
795: );
796: IF hr_startup_data_api_support.g_startup_mode
797: NOT IN ('GENERIC','STARTUP') THEN
798: --

Line 813: ,p_attribute_id => pay_pba_shd.g_old_rec.attribute_id

809: -- Call all supporting business operations
810: --
811: if not pay_pba_bus.chk_alterable
812: (p_balance_attribute_id => p_rec.balance_attribute_id
813: ,p_attribute_id => pay_pba_shd.g_old_rec.attribute_id
814: ,p_business_group_id => pay_pba_shd.g_old_rec.business_group_id
815: ,p_legislation_code => pay_pba_shd.g_old_rec.legislation_code
816: ) then
817: hr_utility.set_message(801, 'PAY_34250_DEL_NOT_ALLOWED_ALT');

Line 814: ,p_business_group_id => pay_pba_shd.g_old_rec.business_group_id

810: --
811: if not pay_pba_bus.chk_alterable
812: (p_balance_attribute_id => p_rec.balance_attribute_id
813: ,p_attribute_id => pay_pba_shd.g_old_rec.attribute_id
814: ,p_business_group_id => pay_pba_shd.g_old_rec.business_group_id
815: ,p_legislation_code => pay_pba_shd.g_old_rec.legislation_code
816: ) then
817: hr_utility.set_message(801, 'PAY_34250_DEL_NOT_ALLOWED_ALT');
818: hr_utility.raise_error;

Line 815: ,p_legislation_code => pay_pba_shd.g_old_rec.legislation_code

811: if not pay_pba_bus.chk_alterable
812: (p_balance_attribute_id => p_rec.balance_attribute_id
813: ,p_attribute_id => pay_pba_shd.g_old_rec.attribute_id
814: ,p_business_group_id => pay_pba_shd.g_old_rec.business_group_id
815: ,p_legislation_code => pay_pba_shd.g_old_rec.legislation_code
816: ) then
817: hr_utility.set_message(801, 'PAY_34250_DEL_NOT_ALLOWED_ALT');
818: hr_utility.raise_error;
819: end if;