DBA Data[Home] [Help]

APPS.AME_ATR_BUS dependencies on AME_ATR_SHD

Line 462: ,p_rec in ame_atr_shd.g_rec_type

458: -- {End Of Comments}
459: -- ----------------------------------------------------------------------------
460: Procedure chk_non_updateable_args
461: (p_effective_date in date
462: ,p_rec in ame_atr_shd.g_rec_type
463: ) IS
464: --
465: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
466: --

Line 472: IF NOT ame_atr_shd.api_updating

468: --
469: -- Only proceed with the validation if a row exists for the current
470: -- record in the HR Schema.
471: --
472: IF NOT ame_atr_shd.api_updating
473: (p_attribute_id => p_rec.attribute_id
474: ,p_effective_date => p_effective_date
475: ,p_object_version_number => p_rec.object_version_number
476: ) THEN

Line 484: nvl(ame_atr_shd.g_old_rec.name,hr_api.g_varchar2)

480: fnd_message.raise_error;
481: END IF;
482: --
483: if nvl(p_rec.name,hr_api.g_varchar2) <>
484: nvl(ame_atr_shd.g_old_rec.name,hr_api.g_varchar2)
485: then
486: hr_api.argument_changed_error
487: (p_api_name => l_proc
488: ,p_argument => 'NAME'

Line 489: ,p_base_table => ame_atr_shd.g_tab_nam

485: then
486: hr_api.argument_changed_error
487: (p_api_name => l_proc
488: ,p_argument => 'NAME'
489: ,p_base_table => ame_atr_shd.g_tab_nam
490: );
491: end if;
492: if nvl(p_rec.attribute_type,hr_api.g_varchar2) <>
493: nvl(ame_atr_shd.g_old_rec.attribute_type,hr_api.g_varchar2)

Line 493: nvl(ame_atr_shd.g_old_rec.attribute_type,hr_api.g_varchar2)

489: ,p_base_table => ame_atr_shd.g_tab_nam
490: );
491: end if;
492: if nvl(p_rec.attribute_type,hr_api.g_varchar2) <>
493: nvl(ame_atr_shd.g_old_rec.attribute_type,hr_api.g_varchar2)
494: then
495: hr_api.argument_changed_error
496: (p_api_name => l_proc
497: ,p_argument => 'ATTRIBUTE_TYPE'

Line 498: ,p_base_table => ame_atr_shd.g_tab_nam

494: then
495: hr_api.argument_changed_error
496: (p_api_name => l_proc
497: ,p_argument => 'ATTRIBUTE_TYPE'
498: ,p_base_table => ame_atr_shd.g_tab_nam
499: );
500: end if;
501: if nvl(p_rec.approver_type_id,hr_api.g_number) <>
502: nvl(ame_atr_shd.g_old_rec.approver_type_id,hr_api.g_number)

Line 502: nvl(ame_atr_shd.g_old_rec.approver_type_id,hr_api.g_number)

498: ,p_base_table => ame_atr_shd.g_tab_nam
499: );
500: end if;
501: if nvl(p_rec.approver_type_id,hr_api.g_number) <>
502: nvl(ame_atr_shd.g_old_rec.approver_type_id,hr_api.g_number)
503: then
504: hr_api.argument_changed_error
505: (p_api_name => l_proc
506: ,p_argument => 'APPROVER_TYPE_ID'

Line 507: ,p_base_table => ame_atr_shd.g_tab_nam

503: then
504: hr_api.argument_changed_error
505: (p_api_name => l_proc
506: ,p_argument => 'APPROVER_TYPE_ID'
507: ,p_base_table => ame_atr_shd.g_tab_nam
508: );
509: end if;
510: if nvl(p_rec.item_class_id,hr_api.g_number) <>
511: nvl(ame_atr_shd.g_old_rec.item_class_id,hr_api.g_number)

Line 511: nvl(ame_atr_shd.g_old_rec.item_class_id,hr_api.g_number)

507: ,p_base_table => ame_atr_shd.g_tab_nam
508: );
509: end if;
510: if nvl(p_rec.item_class_id,hr_api.g_number) <>
511: nvl(ame_atr_shd.g_old_rec.item_class_id,hr_api.g_number)
512: then
513: hr_api.argument_changed_error
514: (p_api_name => l_proc
515: ,p_argument => 'ITEM_CLASS_ID'

Line 516: ,p_base_table => ame_atr_shd.g_tab_nam

512: then
513: hr_api.argument_changed_error
514: (p_api_name => l_proc
515: ,p_argument => 'ITEM_CLASS_ID'
516: ,p_base_table => ame_atr_shd.g_tab_nam
517: );
518: end if;
519: --Added an extra if condition so that no error is thrown when the description for a seeded attribute is modified
520: --using AME Developer responsibility.

Line 523: nvl(ame_utility_pkg.is_seed_user(ame_atr_shd.g_old_rec.created_by),hr_api.g_number) and

519: --Added an extra if condition so that no error is thrown when the description for a seeded attribute is modified
520: --using AME Developer responsibility.
521: if ame_utility_pkg.check_seeddb() = 'N' then
522: if nvl(ame_util.seededDataCreatedById,hr_api.g_number) =
523: nvl(ame_utility_pkg.is_seed_user(ame_atr_shd.g_old_rec.created_by),hr_api.g_number) and
524: nvl(p_rec.description,hr_api.g_varchar2) <>
525: nvl(ame_atr_shd.g_old_rec.description,hr_api.g_varchar2)
526: then
527: hr_api.argument_changed_error

Line 525: nvl(ame_atr_shd.g_old_rec.description,hr_api.g_varchar2)

521: if ame_utility_pkg.check_seeddb() = 'N' then
522: if nvl(ame_util.seededDataCreatedById,hr_api.g_number) =
523: nvl(ame_utility_pkg.is_seed_user(ame_atr_shd.g_old_rec.created_by),hr_api.g_number) and
524: nvl(p_rec.description,hr_api.g_varchar2) <>
525: nvl(ame_atr_shd.g_old_rec.description,hr_api.g_varchar2)
526: then
527: hr_api.argument_changed_error
528: (p_api_name => l_proc
529: ,p_argument => 'DESCRIPTION'

Line 530: ,p_base_table => ame_atr_shd.g_tab_nam

526: then
527: hr_api.argument_changed_error
528: (p_api_name => l_proc
529: ,p_argument => 'DESCRIPTION'
530: ,p_base_table => ame_atr_shd.g_tab_nam
531: );
532: end if;
533: end if;
534: --

Line 718: (p_rec in ame_atr_shd.g_rec_type

714: -- ----------------------------------------------------------------------------
715: -- |---------------------------< insert_validate >----------------------------|
716: -- ----------------------------------------------------------------------------
717: Procedure insert_validate
718: (p_rec in ame_atr_shd.g_rec_type
719: ,p_effective_date in date
720: ,p_datetrack_mode in varchar2
721: ,p_validation_start_date in date
722: ,p_validation_end_date in date

Line 770: (p_rec in ame_atr_shd.g_rec_type

766: -- ----------------------------------------------------------------------------
767: -- |---------------------------< update_validate >----------------------------|
768: -- ----------------------------------------------------------------------------
769: Procedure update_validate
770: (p_rec in ame_atr_shd.g_rec_type
771: ,p_effective_date in date
772: ,p_datetrack_mode in varchar2
773: ,p_validation_start_date in date
774: ,p_validation_end_date in date

Line 805: (p_rec in ame_atr_shd.g_rec_type

801: -- ----------------------------------------------------------------------------
802: -- |---------------------------< delete_validate >----------------------------|
803: -- ----------------------------------------------------------------------------
804: Procedure delete_validate
805: (p_rec in ame_atr_shd.g_rec_type
806: ,p_effective_date in date
807: ,p_datetrack_mode in varchar2
808: ,p_validation_start_date in date
809: ,p_validation_end_date in date