DBA Data[Home] [Help]

APPS.PAY_RFM_BUS dependencies on PAY_RFM_SHD

Line 113: pay_rfm_shd.constraint_error

109: if csr_unique_id%found then
110:
111: close csr_unique_id;
112:
113: pay_rfm_shd.constraint_error
114: (p_constraint_name => 'PAY_REPORT_FORMAT_MAPPINGS_PK');
115:
116: end if ;
117:

Line 539: ,p_rec in pay_rfm_shd.g_rec_type

535: -- {End Of Comments}
536: -- ----------------------------------------------------------------------------
537: Procedure chk_non_updateable_args
538: (p_effective_date in date
539: ,p_rec in pay_rfm_shd.g_rec_type
540: ) IS
541: --
542: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
543: --

Line 549: IF NOT pay_rfm_shd.api_updating

545: --
546: -- Only proceed with the validation if a row exists for the current
547: -- record in the HR Schema.
548: --
549: IF NOT pay_rfm_shd.api_updating
550: (p_report_format_mapping_id => p_rec.report_format_mapping_id
551: ,p_effective_date => p_effective_date
552: ,p_object_version_number => p_rec.object_version_number
553: ) THEN

Line 562: nvl(pay_rfm_shd.g_old_rec.business_group_id, hr_api.g_number) then

558: END IF;
559: --
560: --
561: if nvl(p_rec.business_group_id, hr_api.g_number) <>
562: nvl(pay_rfm_shd.g_old_rec.business_group_id, hr_api.g_number) then
563: hr_api.argument_changed_error
564: (p_api_name => l_proc
565: ,p_argument => 'BUSINESS_GROUP_ID'
566: ,p_base_table => pay_rfm_shd.g_tab_nam

Line 566: ,p_base_table => pay_rfm_shd.g_tab_nam

562: nvl(pay_rfm_shd.g_old_rec.business_group_id, hr_api.g_number) then
563: hr_api.argument_changed_error
564: (p_api_name => l_proc
565: ,p_argument => 'BUSINESS_GROUP_ID'
566: ,p_base_table => pay_rfm_shd.g_tab_nam
567: );
568: end if;
569: --
570: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

Line 571: nvl(pay_rfm_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

567: );
568: end if;
569: --
570: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
571: nvl(pay_rfm_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
572: hr_api.argument_changed_error
573: (p_api_name => l_proc
574: ,p_argument => 'LEGISLATION_CODE'
575: ,p_base_table => pay_rfm_shd.g_tab_nam

Line 575: ,p_base_table => pay_rfm_shd.g_tab_nam

571: nvl(pay_rfm_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
572: hr_api.argument_changed_error
573: (p_api_name => l_proc
574: ,p_argument => 'LEGISLATION_CODE'
575: ,p_base_table => pay_rfm_shd.g_tab_nam
576: );
577: end if;
578: --
579: if nvl(p_rec.report_type, hr_api.g_varchar2) <>

Line 580: pay_rfm_shd.g_old_rec.report_type then

576: );
577: end if;
578: --
579: if nvl(p_rec.report_type, hr_api.g_varchar2) <>
580: pay_rfm_shd.g_old_rec.report_type then
581: hr_api.argument_changed_error
582: (p_api_name => l_proc
583: ,p_argument => 'REPORT_TYPE'
584: ,p_base_table => pay_rfm_shd.g_tab_nam

Line 584: ,p_base_table => pay_rfm_shd.g_tab_nam

580: pay_rfm_shd.g_old_rec.report_type then
581: hr_api.argument_changed_error
582: (p_api_name => l_proc
583: ,p_argument => 'REPORT_TYPE'
584: ,p_base_table => pay_rfm_shd.g_tab_nam
585: );
586: end if;
587: --
588: if nvl(p_rec.report_qualifier, hr_api.g_varchar2) <>

Line 589: pay_rfm_shd.g_old_rec.report_qualifier then

585: );
586: end if;
587: --
588: if nvl(p_rec.report_qualifier, hr_api.g_varchar2) <>
589: pay_rfm_shd.g_old_rec.report_qualifier then
590: hr_api.argument_changed_error
591: (p_api_name => l_proc
592: ,p_argument => 'REPORT_QUALIFIER'
593: ,p_base_table => pay_rfm_shd.g_tab_nam

Line 593: ,p_base_table => pay_rfm_shd.g_tab_nam

589: pay_rfm_shd.g_old_rec.report_qualifier then
590: hr_api.argument_changed_error
591: (p_api_name => l_proc
592: ,p_argument => 'REPORT_QUALIFIER'
593: ,p_base_table => pay_rfm_shd.g_tab_nam
594: );
595: end if;
596: --
597: if nvl(p_rec.report_category, hr_api.g_varchar2) <>

Line 598: pay_rfm_shd.g_old_rec.report_category then

594: );
595: end if;
596: --
597: if nvl(p_rec.report_category, hr_api.g_varchar2) <>
598: pay_rfm_shd.g_old_rec.report_category then
599: hr_api.argument_changed_error
600: (p_api_name => l_proc
601: ,p_argument => 'REPORT_CATEGORY'
602: ,p_base_table => pay_rfm_shd.g_tab_nam

Line 602: ,p_base_table => pay_rfm_shd.g_tab_nam

598: pay_rfm_shd.g_old_rec.report_category then
599: hr_api.argument_changed_error
600: (p_api_name => l_proc
601: ,p_argument => 'REPORT_CATEGORY'
602: ,p_base_table => pay_rfm_shd.g_tab_nam
603: );
604: end if;
605: --
606: End chk_non_updateable_args;

Line 831: (p_rec in pay_rfm_shd.g_rec_type

827: -- ----------------------------------------------------------------------------
828: -- |---------------------------< insert_validate >----------------------------|
829: -- ----------------------------------------------------------------------------
830: Procedure insert_validate
831: (p_rec in pay_rfm_shd.g_rec_type
832: ,p_effective_date in date
833: ,p_datetrack_mode in varchar2
834: ,p_validation_start_date in date
835: ,p_validation_end_date in date

Line 858: ,p_associated_column1 => pay_rfm_shd.g_tab_nam

854: -- Validate Important Attributes
855: --
856: hr_api.validate_bus_grp_id
857: (p_business_group_id => p_rec.business_group_id
858: ,p_associated_column1 => pay_rfm_shd.g_tab_nam
859: || '.BUSINESS_GROUP_ID');
860: --
861: -- after validating the set of important attributes,
862: -- if Multiple Message Detection is enabled and at least

Line 897: (p_rec in pay_rfm_shd.g_rec_type

893: -- ----------------------------------------------------------------------------
894: -- |---------------------------< update_validate >----------------------------|
895: -- ----------------------------------------------------------------------------
896: Procedure update_validate
897: (p_rec in pay_rfm_shd.g_rec_type
898: ,p_effective_date in date
899: ,p_datetrack_mode in varchar2
900: ,p_validation_start_date in date
901: ,p_validation_end_date in date

Line 923: ,p_associated_column1 => pay_rfm_shd.g_tab_nam

919: -- Validate Important Attributes
920: --
921: hr_api.validate_bus_grp_id
922: (p_business_group_id => p_rec.business_group_id
923: ,p_associated_column1 => pay_rfm_shd.g_tab_nam
924: || '.BUSINESS_GROUP_ID');
925: --
926: -- After validating the set of important attributes,
927: -- if Multiple Message Detection is enabled and at least

Line 962: (p_rec in pay_rfm_shd.g_rec_type

958: -- ----------------------------------------------------------------------------
959: -- |---------------------------< delete_validate >----------------------------|
960: -- ----------------------------------------------------------------------------
961: Procedure delete_validate
962: (p_rec in pay_rfm_shd.g_rec_type
963: ,p_effective_date in date
964: ,p_datetrack_mode in varchar2
965: ,p_validation_start_date in date
966: ,p_validation_end_date in date

Line 976: ,pay_rfm_shd.g_old_rec.business_group_id

972: hr_utility.set_location('Entering:'||l_proc, 5);
973: --
974: --
975: chk_startup_action(false
976: ,pay_rfm_shd.g_old_rec.business_group_id
977: ,pay_rfm_shd.g_old_rec.legislation_code
978: );
979: IF hr_startup_data_api_support.g_startup_mode
980: NOT IN ('GENERIC','STARTUP') THEN

Line 977: ,pay_rfm_shd.g_old_rec.legislation_code

973: --
974: --
975: chk_startup_action(false
976: ,pay_rfm_shd.g_old_rec.business_group_id
977: ,pay_rfm_shd.g_old_rec.legislation_code
978: );
979: IF hr_startup_data_api_support.g_startup_mode
980: NOT IN ('GENERIC','STARTUP') THEN
981: --