DBA Data[Home] [Help]

APPS.PAY_PUC_BUS dependencies on PAY_PUC_SHD

Line 186: (p_rec in pay_puc_shd.g_rec_type

182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure chk_non_updateable_args
186: (p_rec in pay_puc_shd.g_rec_type
187: ) IS
188: --
189: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
190: --

Line 196: IF NOT pay_puc_shd.api_updating

192: --
193: -- Only proceed with the validation if a row exists for the current
194: -- record in the HR Schema.
195: --
196: IF NOT pay_puc_shd.api_updating
197: (p_user_column_id => p_rec.user_column_id
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 207: nvl(pay_puc_shd.g_old_rec.business_group_id, hr_api.g_number) then

203: fnd_message.raise_error;
204: END IF;
205: --
206: if nvl(p_rec.business_group_id, hr_api.g_number) <>
207: nvl(pay_puc_shd.g_old_rec.business_group_id, hr_api.g_number) then
208: hr_api.argument_changed_error
209: (p_api_name => l_proc
210: ,p_argument => 'BUSINESS_GROUP_ID'
211: ,p_base_table => pay_puc_shd.g_tab_nam

Line 211: ,p_base_table => pay_puc_shd.g_tab_nam

207: nvl(pay_puc_shd.g_old_rec.business_group_id, hr_api.g_number) then
208: hr_api.argument_changed_error
209: (p_api_name => l_proc
210: ,p_argument => 'BUSINESS_GROUP_ID'
211: ,p_base_table => pay_puc_shd.g_tab_nam
212: );
213: end if;
214: --
215: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

Line 216: nvl(pay_puc_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

212: );
213: end if;
214: --
215: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
216: nvl(pay_puc_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'LEGISLATION_CODE'
220: ,p_base_table => pay_puc_shd.g_tab_nam

Line 220: ,p_base_table => pay_puc_shd.g_tab_nam

216: nvl(pay_puc_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'LEGISLATION_CODE'
220: ,p_base_table => pay_puc_shd.g_tab_nam
221: );
222: end if;
223: --
224: if nvl(p_rec.user_table_id, hr_api.g_number) <>

Line 225: pay_puc_shd.g_old_rec.user_table_id then

221: );
222: end if;
223: --
224: if nvl(p_rec.user_table_id, hr_api.g_number) <>
225: pay_puc_shd.g_old_rec.user_table_id then
226: hr_api.argument_changed_error
227: (p_api_name => l_proc
228: ,p_argument => 'USER_TABLE_ID'
229: ,p_base_table => pay_puc_shd.g_tab_nam

Line 229: ,p_base_table => pay_puc_shd.g_tab_nam

225: pay_puc_shd.g_old_rec.user_table_id then
226: hr_api.argument_changed_error
227: (p_api_name => l_proc
228: ,p_argument => 'USER_TABLE_ID'
229: ,p_base_table => pay_puc_shd.g_tab_nam
230: );
231: end if;
232: End chk_non_updateable_args;
233: --

Line 389: not pay_puc_shd.api_updating

385: if hr_multi_message.no_exclusive_error
386: (p_check_column1 => 'PAY_USER_COLUMNS.USER_TABLE_ID'
387: ,p_associated_column1 => 'PAY_USER_COLUMNS.USER_COLUMN_NAME'
388: ) and (
389: not pay_puc_shd.api_updating
390: (p_user_column_id => p_user_column_id
391: ,p_object_version_number => p_object_version_number
392: ) or
393: nvl(p_user_column_name, hr_api.g_varchar2) <>

Line 394: pay_puc_shd.g_old_rec.user_column_name

390: (p_user_column_id => p_user_column_id
391: ,p_object_version_number => p_object_version_number
392: ) or
393: nvl(p_user_column_name, hr_api.g_varchar2) <>
394: pay_puc_shd.g_old_rec.user_column_name
395: ) then
396: --
397: -- The name is mandatory.
398: --

Line 469: pay_puc_shd.api_updating

465: l_busgrpid number;
466: l_legcode varchar2(150);
467: begin
468: l_updating :=
469: pay_puc_shd.api_updating
470: (p_user_column_id => p_user_column_id
471: ,p_object_version_number => p_object_version_number
472: );
473: --

Line 476: nvl(pay_puc_shd.g_old_rec.formula_id, hr_api.g_number) then

472: );
473: --
474: if not l_updating or
475: nvl(p_formula_id, hr_api.g_number) <>
476: nvl(pay_puc_shd.g_old_rec.formula_id, hr_api.g_number) then
477: --
478: -- No need to warn and do anything further if no formula is to be
479: -- referenced.
480: --

Line 629: (p_rec in pay_puc_shd.g_rec_type

625: -- ----------------------------------------------------------------------------
626: -- |---------------------------< insert_validate >----------------------------|
627: -- ----------------------------------------------------------------------------
628: Procedure insert_validate
629: (p_rec in pay_puc_shd.g_rec_type
630: ) is
631: --
632: l_proc varchar2(72) := g_package||'insert_validate';
633: l_formula_warning boolean;

Line 652: ,p_associated_column1 => pay_puc_shd.g_tab_nam

648: -- Validate Important Attributes
649: --
650: hr_api.validate_bus_grp_id
651: (p_business_group_id => p_rec.business_group_id
652: ,p_associated_column1 => pay_puc_shd.g_tab_nam
653: || '.BUSINESS_GROUP_ID');
654: --
655: -- after validating the set of important attributes,
656: -- if Multiple Message Detection is enabled and at least

Line 708: (p_rec in pay_puc_shd.g_rec_type

704: -- ----------------------------------------------------------------------------
705: -- |---------------------------< update_validate >----------------------------|
706: -- ----------------------------------------------------------------------------
707: Procedure update_validate
708: (p_rec in pay_puc_shd.g_rec_type
709: ,p_formula_warning out nocopy boolean
710: ) is
711: --
712: l_proc varchar2(72) := g_package||'update_validate';

Line 731: ,p_associated_column1 => pay_puc_shd.g_tab_nam

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

Line 773: (p_rec in pay_puc_shd.g_rec_type

769: -- ----------------------------------------------------------------------------
770: -- |---------------------------< delete_validate >----------------------------|
771: -- ----------------------------------------------------------------------------
772: Procedure delete_validate
773: (p_rec in pay_puc_shd.g_rec_type
774: ) is
775: --
776: l_proc varchar2(72) := g_package||'delete_validate';
777: --

Line 783: ,pay_puc_shd.g_old_rec.business_group_id

779: hr_utility.set_location('Entering:'||l_proc, 5);
780: --
781: --
782: chk_startup_action(false
783: ,pay_puc_shd.g_old_rec.business_group_id
784: ,pay_puc_shd.g_old_rec.legislation_code
785: );
786: IF hr_startup_data_api_support.g_startup_mode
787: NOT IN ('GENERIC','STARTUP') THEN

Line 784: ,pay_puc_shd.g_old_rec.legislation_code

780: --
781: --
782: chk_startup_action(false
783: ,pay_puc_shd.g_old_rec.business_group_id
784: ,pay_puc_shd.g_old_rec.legislation_code
785: );
786: IF hr_startup_data_api_support.g_startup_mode
787: NOT IN ('GENERIC','STARTUP') THEN
788: --