DBA Data[Home] [Help]

APPS.PAY_PBD_BUS dependencies on PAY_PBD_SHD

Line 250: nvl(pay_pbd_shd.g_old_rec.attribute_id, hr_api.g_varchar2) <>

246: -- primary key value. For update it will be not null. For insert it will be
247: -- null, because pre_inset has not been called yet.
248: --
249: IF (((p_bal_attribute_default_id is not null) and
250: nvl(pay_pbd_shd.g_old_rec.attribute_id, hr_api.g_varchar2) <>
251: nvl(p_attribute_id, hr_api.g_varchar2))
252: or
253: (p_bal_attribute_default_id is null)) then
254: --

Line 412: nvl(pay_pbd_shd.g_old_rec.balance_category_id, hr_api.g_varchar2) <>

408: -- primary key value. For update it will be not null. For insert it will be
409: -- null, because pre_inset has not been called yet.
410: --
411: IF (((p_bal_attribute_default_id is not null) and
412: nvl(pay_pbd_shd.g_old_rec.balance_category_id, hr_api.g_varchar2) <>
413: nvl(p_balance_category_id, hr_api.g_varchar2))
414: or
415: (p_bal_attribute_default_id is null)) then
416: --

Line 575: nvl(pay_pbd_shd.g_old_rec.balance_dimension_id, hr_api.g_varchar2) <>

571: -- primary key value. For update it will be not null. For insert it will be
572: -- null, because pre_inset has not been called yet.
573: --
574: IF (((p_bal_attribute_default_id is not null) and
575: nvl(pay_pbd_shd.g_old_rec.balance_dimension_id, hr_api.g_varchar2) <>
576: nvl(p_balance_dimension_id, hr_api.g_varchar2))
577: or
578: (p_bal_attribute_default_id is null)) then
579: --

Line 667: (p_rec in pay_pbd_shd.g_rec_type

663: --
664: -- {End Of Comments}
665: -- ----------------------------------------------------------------------------
666: Procedure chk_non_updateable_args
667: (p_rec in pay_pbd_shd.g_rec_type
668: ) IS
669: --
670: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
671: l_error EXCEPTION;

Line 679: IF NOT pay_pbd_shd.api_updating

675: --
676: -- Only proceed with the validation if a row exists for the current
677: -- record in the HR Schema.
678: --
679: IF NOT pay_pbd_shd.api_updating
680: (p_bal_attribute_default_id => p_rec.bal_attribute_default_id
681: ) THEN
682: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
683: fnd_message.set_token('PROCEDURE ', l_proc);

Line 689: nvl(pay_pbd_shd.g_old_rec.business_group_id, hr_api.g_number) then

685: fnd_message.raise_error;
686: END IF;
687: --
688: if nvl(p_rec.business_group_id, hr_api.g_number) <>
689: nvl(pay_pbd_shd.g_old_rec.business_group_id, hr_api.g_number) then
690: l_argument := 'business_group_id';
691: raise l_error;
692: end if;
693: hr_utility.set_location(l_proc, 15);

Line 695: if p_rec.balance_category_id <> pay_pbd_shd.g_old_rec.balance_category_id then

691: raise l_error;
692: end if;
693: hr_utility.set_location(l_proc, 15);
694: --
695: if p_rec.balance_category_id <> pay_pbd_shd.g_old_rec.balance_category_id then
696: l_argument := 'balance_category_id';
697: raise l_error;
698: end if;
699: hr_utility.set_location(l_proc, 20);

Line 701: if p_rec.legislation_code <> pay_pbd_shd.g_old_rec.legislation_code then

697: raise l_error;
698: end if;
699: hr_utility.set_location(l_proc, 20);
700: --
701: if p_rec.legislation_code <> pay_pbd_shd.g_old_rec.legislation_code then
702: l_argument := 'legislation_code';
703: raise l_error;
704: end if;
705: hr_utility.set_location(l_proc, 25);

Line 708: pay_pbd_shd.g_old_rec.bal_attribute_default_id then

704: end if;
705: hr_utility.set_location(l_proc, 25);
706: --
707: if p_rec.bal_attribute_default_id <>
708: pay_pbd_shd.g_old_rec.bal_attribute_default_id then
709: l_argument := 'bal_attribute_default_id';
710: raise l_error;
711: end if;
712: hr_utility.set_location(l_proc, 30);

Line 714: if p_rec.attribute_id <> pay_pbd_shd.g_old_rec.attribute_id then

710: raise l_error;
711: end if;
712: hr_utility.set_location(l_proc, 30);
713: --
714: if p_rec.attribute_id <> pay_pbd_shd.g_old_rec.attribute_id then
715: l_argument := 'attribute_id';
716: raise l_error;
717: end if;
718: hr_utility.set_location(l_proc, 35);

Line 720: if p_rec.balance_dimension_id <> pay_pbd_shd.g_old_rec.balance_dimension_id

716: raise l_error;
717: end if;
718: hr_utility.set_location(l_proc, 35);
719: --
720: if p_rec.balance_dimension_id <> pay_pbd_shd.g_old_rec.balance_dimension_id
721: then
722: l_argument := 'balance_dimension_id';
723: raise l_error;
724: end if;

Line 775: (p_rec in pay_pbd_shd.g_rec_type

771: -- ----------------------------------------------------------------------------
772: -- |---------------------------< insert_validate >----------------------------|
773: -- ----------------------------------------------------------------------------
774: Procedure insert_validate
775: (p_rec in pay_pbd_shd.g_rec_type
776: ) is
777: --
778: l_proc varchar2(72) := g_package||'insert_validate';
779: --

Line 797: ,p_associated_column1 => pay_pbd_shd.g_tab_nam

793: -- Validate Important Attributes
794: --
795: hr_api.validate_bus_grp_id
796: (p_business_group_id => p_rec.business_group_id
797: ,p_associated_column1 => pay_pbd_shd.g_tab_nam
798: || '.BUSINESS_GROUP_ID');
799: --
800: -- after validating the set of important attributes,
801: -- if Multiple Message Detection is enabled and at least

Line 840: (p_rec in pay_pbd_shd.g_rec_type

836: -- ----------------------------------------------------------------------------
837: -- |---------------------------< delete_validate >----------------------------|
838: -- ----------------------------------------------------------------------------
839: Procedure delete_validate
840: (p_rec in pay_pbd_shd.g_rec_type
841: ) is
842: --
843: l_proc varchar2(72) := g_package||'delete_validate';
844: --

Line 852: ,pay_pbd_shd.g_old_rec.business_group_id

848: -- NB. need to use g_old_rec, as p_rec is not pupulated with all the columns
849: -- for delete mode.
850: --
851: chk_startup_action(false
852: ,pay_pbd_shd.g_old_rec.business_group_id
853: ,pay_pbd_shd.g_old_rec.legislation_code
854: );
855: IF hr_startup_data_api_support.g_startup_mode
856: NOT IN ('GENERIC','STARTUP') THEN

Line 853: ,pay_pbd_shd.g_old_rec.legislation_code

849: -- for delete mode.
850: --
851: chk_startup_action(false
852: ,pay_pbd_shd.g_old_rec.business_group_id
853: ,pay_pbd_shd.g_old_rec.legislation_code
854: );
855: IF hr_startup_data_api_support.g_startup_mode
856: NOT IN ('GENERIC','STARTUP') THEN
857: --