DBA Data[Home] [Help]

APPS.PAY_RFI_BUS dependencies on PAY_RFI_SHD

Line 349: ,p_rec in pay_rfi_shd.g_rec_type

345: -- {End Of Comments}
346: -- ----------------------------------------------------------------------------
347: Procedure chk_non_updateable_args
348: (p_effective_date in date
349: ,p_rec in pay_rfi_shd.g_rec_type
350: ) IS
351: --
352: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
353: --

Line 359: IF NOT pay_rfi_shd.api_updating

355: --
356: -- Only proceed with the validation if a row exists for the current
357: -- record in the HR Schema.
358: --
359: IF NOT pay_rfi_shd.api_updating
360: (p_report_format_item_id => p_rec.report_format_item_id
361: ,p_effective_date => p_effective_date
362: ,p_object_version_number => p_rec.object_version_number
363: ) THEN

Line 372: pay_rfi_shd.g_old_rec.report_type then

368: END IF;
369: --
370: --
371: if nvl(p_rec.report_type, hr_api.g_varchar2) <>
372: pay_rfi_shd.g_old_rec.report_type then
373: hr_api.argument_changed_error
374: (p_api_name => l_proc
375: ,p_argument => 'REPORT_TYPE'
376: ,p_base_table => pay_rfi_shd.g_tab_nam

Line 376: ,p_base_table => pay_rfi_shd.g_tab_nam

372: pay_rfi_shd.g_old_rec.report_type then
373: hr_api.argument_changed_error
374: (p_api_name => l_proc
375: ,p_argument => 'REPORT_TYPE'
376: ,p_base_table => pay_rfi_shd.g_tab_nam
377: );
378: end if;
379: --
380: if nvl(p_rec.report_qualifier, hr_api.g_varchar2) <>

Line 381: pay_rfi_shd.g_old_rec.report_qualifier then

377: );
378: end if;
379: --
380: if nvl(p_rec.report_qualifier, hr_api.g_varchar2) <>
381: pay_rfi_shd.g_old_rec.report_qualifier then
382: hr_api.argument_changed_error
383: (p_api_name => l_proc
384: ,p_argument => 'REPORT_QUALIFIER'
385: ,p_base_table => pay_rfi_shd.g_tab_nam

Line 385: ,p_base_table => pay_rfi_shd.g_tab_nam

381: pay_rfi_shd.g_old_rec.report_qualifier then
382: hr_api.argument_changed_error
383: (p_api_name => l_proc
384: ,p_argument => 'REPORT_QUALIFIER'
385: ,p_base_table => pay_rfi_shd.g_tab_nam
386: );
387: end if;
388: --
389: if nvl(p_rec.report_category, hr_api.g_varchar2) <>

Line 390: pay_rfi_shd.g_old_rec.report_category then

386: );
387: end if;
388: --
389: if nvl(p_rec.report_category, hr_api.g_varchar2) <>
390: pay_rfi_shd.g_old_rec.report_category then
391: hr_api.argument_changed_error
392: (p_api_name => l_proc
393: ,p_argument => 'REPORT_CATEGORY'
394: ,p_base_table => pay_rfi_shd.g_tab_nam

Line 394: ,p_base_table => pay_rfi_shd.g_tab_nam

390: pay_rfi_shd.g_old_rec.report_category then
391: hr_api.argument_changed_error
392: (p_api_name => l_proc
393: ,p_argument => 'REPORT_CATEGORY'
394: ,p_base_table => pay_rfi_shd.g_tab_nam
395: );
396: end if;
397: --
398: if nvl(p_rec.user_entity_id, hr_api.g_number) <>

Line 399: pay_rfi_shd.g_old_rec.user_entity_id then

395: );
396: end if;
397: --
398: if nvl(p_rec.user_entity_id, hr_api.g_number) <>
399: pay_rfi_shd.g_old_rec.user_entity_id then
400: hr_api.argument_changed_error
401: (p_api_name => l_proc
402: ,p_argument => 'USER_ENTITY_ID'
403: ,p_base_table => pay_rfi_shd.g_tab_nam

Line 403: ,p_base_table => pay_rfi_shd.g_tab_nam

399: pay_rfi_shd.g_old_rec.user_entity_id then
400: hr_api.argument_changed_error
401: (p_api_name => l_proc
402: ,p_argument => 'USER_ENTITY_ID'
403: ,p_base_table => pay_rfi_shd.g_tab_nam
404: );
405: end if;
406: --
407: End chk_non_updateable_args;

Line 483: (p_associated_column1 => pay_rfi_shd.g_tab_nam || '.REPORT_FORMAT_MAPPING

479: ,p_to_date => p_validation_end_date))) Then
480: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
481: fnd_message.set_token('TABLE_NAME','report format mappings');
482: hr_multi_message.add
483: (p_associated_column1 => pay_rfi_shd.g_tab_nam || '.REPORT_FORMAT_MAPPING
484: _ID');
485: End If;
486: --
487: Exception

Line 601: (p_rec in pay_rfi_shd.g_rec_type

597: -- ----------------------------------------------------------------------------
598: -- |---------------------------< insert_validate >----------------------------|
599: -- ----------------------------------------------------------------------------
600: Procedure insert_validate
601: (p_rec in pay_rfi_shd.g_rec_type
602: ,p_effective_date in date
603: ,p_datetrack_mode in varchar2
604: ,p_validation_start_date in date
605: ,p_validation_end_date in date

Line 646: (p_rec in pay_rfi_shd.g_rec_type

642: -- ----------------------------------------------------------------------------
643: -- |---------------------------< update_validate >----------------------------|
644: -- ----------------------------------------------------------------------------
645: Procedure update_validate
646: (p_rec in pay_rfi_shd.g_rec_type
647: ,p_effective_date in date
648: ,p_datetrack_mode in varchar2
649: ,p_validation_start_date in date
650: ,p_validation_end_date in date

Line 689: (p_rec in pay_rfi_shd.g_rec_type

685: -- ----------------------------------------------------------------------------
686: -- |---------------------------< delete_validate >----------------------------|
687: -- ----------------------------------------------------------------------------
688: Procedure delete_validate
689: (p_rec in pay_rfi_shd.g_rec_type
690: ,p_effective_date in date
691: ,p_datetrack_mode in varchar2
692: ,p_validation_start_date in date
693: ,p_validation_end_date in date

Line 745: pay_rfi_shd.constraint_error

741: if csr_unique_id%found then
742:
743: close csr_unique_id;
744:
745: pay_rfi_shd.constraint_error
746: (p_constraint_name => 'PAY_REPORT_FORMAT_ITEMS_PK');
747:
748: end if ;
749: