APPS.PAY_BAD_BUS dependencies on PAY_BAD_SHD

Line 232: nvl(pay_bad_shd.g_old_rec.attribute_name, hr_api.g_varchar2) <>

228: -- primary key value. For update it will be not null. For insert it will be
229: -- null, because pre_inset has not been called yet.
230: --
231: IF (((p_attribute_id is not null) and
232: nvl(pay_bad_shd.g_old_rec.attribute_name, hr_api.g_varchar2) <>
233: nvl(p_attribute_name, hr_api.g_varchar2))
234: or
235: (p_attribute_id is null)) then
236: --

Line 402: nvl(pay_bad_shd.g_old_rec.user_attribute_name, hr_api.g_varchar2) <>

398: -- primary key value. For update it will be not null. For insert it will be
399: -- null, because pre_inset has not been called yet.
400: --
401: IF (((p_attribute_id is not null) and
402: nvl(pay_bad_shd.g_old_rec.user_attribute_name, hr_api.g_varchar2) <>
403: nvl(p_user_attribute_name, hr_api.g_varchar2))
404: or
405: (p_attribute_id is null)) then
406: --

Line 739: ,p_rec in pay_bad_shd.g_rec_type

735: -- {End Of Comments}
736: -- ----------------------------------------------------------------------------
737: Procedure chk_non_updateable_args
738: (p_effective_date in date
739: ,p_rec in pay_bad_shd.g_rec_type
740: ) IS
741: --
742: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
743: l_error EXCEPTION;

Line 751: IF NOT pay_bad_shd.api_updating

747: --
748: -- Only proceed with the validation if a row exists for the current
749: -- record in the HR Schema.
750: --
751: IF NOT pay_bad_shd.api_updating
752: (p_attribute_id => p_rec.attribute_id
753: ) THEN
754: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
755: fnd_message.set_token('PROCEDURE ', l_proc);

Line 763: nvl(pay_bad_shd.g_old_rec.business_group_id, hr_api.g_number) then

759: --
760: hr_utility.set_location(l_proc, 10);
761: --
762: if nvl(p_rec.business_group_id, hr_api.g_number) <>
763: nvl(pay_bad_shd.g_old_rec.business_group_id, hr_api.g_number) then
764: l_argument := 'business_group_id';
765: raise l_error;
766: end if;
767: hr_utility.set_location(l_proc, 15);

Line 769: if p_rec.attribute_id <> pay_bad_shd.g_old_rec.attribute_id then

765: raise l_error;
766: end if;
767: hr_utility.set_location(l_proc, 15);
768: --
769: if p_rec.attribute_id <> pay_bad_shd.g_old_rec.attribute_id then
770: l_argument := 'attribute_id';
771: raise l_error;
772: end if;
773: hr_utility.set_location(l_proc, 20);

Line 775: if p_rec.legislation_code <> pay_bad_shd.g_old_rec.legislation_code then

771: raise l_error;
772: end if;
773: hr_utility.set_location(l_proc, 20);
774: --
775: if p_rec.legislation_code <> pay_bad_shd.g_old_rec.legislation_code then
776: l_argument := 'legislation_code';
777: raise l_error;
778: end if;
779: hr_utility.set_location(l_proc, 25);

Line 781: if p_rec.attribute_name <> pay_bad_shd.g_old_rec.attribute_name then

777: raise l_error;
778: end if;
779: hr_utility.set_location(l_proc, 25);
780: --
781: if p_rec.attribute_name <> pay_bad_shd.g_old_rec.attribute_name then
782: l_argument := 'attribute_name';
783: raise l_error;
784: end if;
785: hr_utility.set_location(l_proc, 30);

Line 787: if p_rec.alterable <> pay_bad_shd.g_old_rec.alterable then

783: raise l_error;
784: end if;
785: hr_utility.set_location(l_proc, 30);
786: --
787: if p_rec.alterable <> pay_bad_shd.g_old_rec.alterable then
788: l_argument := 'alterable';
789: raise l_error;
790: end if;
791: hr_utility.set_location(l_proc, 35);

Line 851: ,p_rec in pay_bad_shd.g_rec_type

847: -- |---------------------------< insert_validate >----------------------------|
848: -- ----------------------------------------------------------------------------
849: Procedure insert_validate
850: (p_effective_date in date
851: ,p_rec in pay_bad_shd.g_rec_type
852: ) is
853: --
854: l_proc varchar2(72) := g_package||'insert_validate';
855: --

Line 873: ,p_associated_column1 => pay_bad_shd.g_tab_nam

869: -- Validate Important Attributes
870: --
871: hr_api.validate_bus_grp_id
872: (p_business_group_id => p_rec.business_group_id
873: ,p_associated_column1 => pay_bad_shd.g_tab_nam
874: || '.BUSINESS_GROUP_ID');
875: --
876: -- after validating the set of important attributes,
877: -- if Multiple Message Detection is enabled and at least

Line 910: (p_rec in pay_bad_shd.g_rec_type

906: -- ----------------------------------------------------------------------------
907: -- |---------------------------< delete_validate >----------------------------|
908: -- ----------------------------------------------------------------------------
909: Procedure delete_validate
910: (p_rec in pay_bad_shd.g_rec_type
911: ) is
912: --
913: l_proc varchar2(72) := g_package||'delete_validate';
914: --

Line 919: ,pay_bad_shd.g_old_rec.business_group_id

915: Begin
916: hr_utility.set_location('Entering:'||l_proc, 5);
917: --
918: chk_startup_action(false
919: ,pay_bad_shd.g_old_rec.business_group_id
920: ,pay_bad_shd.g_old_rec.legislation_code
921: );
922: --
923: chk_for_child_rows

Line 920: ,pay_bad_shd.g_old_rec.legislation_code

916: hr_utility.set_location('Entering:'||l_proc, 5);
917: --
918: chk_startup_action(false
919: ,pay_bad_shd.g_old_rec.business_group_id
920: ,pay_bad_shd.g_old_rec.legislation_code
921: );
922: --
923: chk_for_child_rows
924: (p_attribute_id => p_rec.attribute_id

Line 925: ,p_business_group_id => pay_bad_shd.g_old_rec.business_group_id

921: );
922: --
923: chk_for_child_rows
924: (p_attribute_id => p_rec.attribute_id
925: ,p_business_group_id => pay_bad_shd.g_old_rec.business_group_id
926: ,p_legislation_code => pay_bad_shd.g_old_rec.legislation_code
927: );
928: --
929: hr_utility.set_location(l_proc, 10);

Line 926: ,p_legislation_code => pay_bad_shd.g_old_rec.legislation_code

922: --
923: chk_for_child_rows
924: (p_attribute_id => p_rec.attribute_id
925: ,p_business_group_id => pay_bad_shd.g_old_rec.business_group_id
926: ,p_legislation_code => pay_bad_shd.g_old_rec.legislation_code
927: );
928: --
929: hr_utility.set_location(l_proc, 10);
930: --