DBA Data[Home] [Help]

APPS.PAY_SPR_BUS dependencies on PAY_SPR_SHD

Line 278: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'

274: -- does not already contain an error associated with the
275: -- below columns.
276: --
277: IF hr_multi_message.no_exclusive_error
278: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
279: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
280: ,p_check_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID'
281: ,p_associated_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID')
282: THEN

Line 279: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'

275: -- below columns.
276: --
277: IF hr_multi_message.no_exclusive_error
278: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
279: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
280: ,p_check_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID'
281: ,p_associated_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID')
282: THEN
283:

Line 280: ,p_check_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID'

276: --
277: IF hr_multi_message.no_exclusive_error
278: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
279: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
280: ,p_check_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID'
281: ,p_associated_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID')
282: THEN
283:
284: hr_utility.set_location(l_proc, 20);

Line 281: ,p_associated_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID')

277: IF hr_multi_message.no_exclusive_error
278: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
279: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
280: ,p_check_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID'
281: ,p_associated_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID')
282: THEN
283:
284: hr_utility.set_location(l_proc, 20);
285:

Line 353: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'

349: -- does not already contain an error associated with the
350: -- below columns.
351: --
352: IF hr_multi_message.no_exclusive_error
353: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
354: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID')
355: THEN
356:
357: hr_utility.set_location(l_proc, 20);

Line 354: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID')

350: -- below columns.
351: --
352: IF hr_multi_message.no_exclusive_error
353: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
354: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID')
355: THEN
356:
357: hr_utility.set_location(l_proc, 20);
358:

Line 470: ,p_rec in pay_spr_shd.g_rec_type

466: -- {End Of Comments}
467: -- ----------------------------------------------------------------------------
468: Procedure chk_non_updateable_args
469: (p_effective_date in date
470: ,p_rec in pay_spr_shd.g_rec_type
471: ) IS
472: --
473: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
474: --

Line 480: IF NOT pay_spr_shd.api_updating

476: --
477: -- Only proceed with the validation if a row exists for the current
478: -- record in the HR Schema.
479: --
480: IF NOT pay_spr_shd.api_updating
481: (p_security_profile_id => p_rec.security_profile_id
482: ,p_payroll_id => p_rec.payroll_id
483: ,p_object_version_number => p_rec.object_version_number
484: ) THEN

Line 498: ,p_rec in pay_spr_shd.g_rec_type

494: -- |---------------------------< insert_validate >----------------------------|
495: -- ----------------------------------------------------------------------------
496: Procedure insert_validate
497: (p_effective_date in date
498: ,p_rec in pay_spr_shd.g_rec_type
499: ) is
500: --
501: l_proc varchar2(72) := g_package||'insert_validate';
502: --

Line 511: ,p_associated_column1 => pay_spr_shd.g_tab_nam

507: -- Call all supporting business operations
508: --
509: hr_api.validate_bus_grp_id
510: (p_business_group_id => p_rec.business_group_id
511: ,p_associated_column1 => pay_spr_shd.g_tab_nam
512: || '.BUSINESS_GROUP_ID');
513:
514: -- After validating the set of important attributes,
515: -- if Multiple Message detection is enabled and at least

Line 542: (p_rec in pay_spr_shd.g_rec_type

538: -- ----------------------------------------------------------------------------
539: -- |---------------------------< delete_validate >----------------------------|
540: -- ----------------------------------------------------------------------------
541: Procedure delete_validate
542: (p_rec in pay_spr_shd.g_rec_type
543: ) is
544: --
545: l_proc varchar2(72) := g_package||'delete_validate';
546: --