DBA Data[Home] [Help]

APPS.AME_CON_BUS dependencies on AME_CON_SHD

Line 558: procedure chk_unique(p_rec in ame_con_shd.g_rec_type

554: -- Internal Row Handler Use Only.
555: --
556: -- {End Of Comments}
557: -- ----------------------------------------------------------------------------
558: procedure chk_unique(p_rec in ame_con_shd.g_rec_type
559: ,p_effective_date in date
560: ) IS
561: --
562: cursor csr_name is

Line 933: ,p_rec in ame_con_shd.g_rec_type

929: -- {End Of Comments}
930: -- ----------------------------------------------------------------------------
931: Procedure chk_non_updateable_args
932: (p_effective_date in date
933: ,p_rec in ame_con_shd.g_rec_type
934: ) IS
935: --
936: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
937: --

Line 943: IF NOT ame_con_shd.api_updating

939: --
940: -- Only proceed with the validation if a row exists for the current
941: -- record in the HR Schema.
942: --
943: IF NOT ame_con_shd.api_updating
944: (p_condition_id => p_rec.condition_id
945: ,p_effective_date => p_effective_date
946: ,p_object_version_number => p_rec.object_version_number
947: ) THEN

Line 959: nvl(ame_con_shd.g_old_rec.condition_type,hr_api.g_varchar2) then

955: -- not been updated.
956: --
957: -- CONDITION_TYPE is non-updateable
958: if nvl(p_rec.condition_type, hr_api.g_varchar2) <>
959: nvl(ame_con_shd.g_old_rec.condition_type,hr_api.g_varchar2) then
960: hr_api.argument_changed_error
961: (p_api_name => l_proc
962: ,p_argument => 'CONDITION_TYPE'
963: ,p_base_table => ame_con_shd.g_tab_nam

Line 963: ,p_base_table => ame_con_shd.g_tab_nam

959: nvl(ame_con_shd.g_old_rec.condition_type,hr_api.g_varchar2) then
960: hr_api.argument_changed_error
961: (p_api_name => l_proc
962: ,p_argument => 'CONDITION_TYPE'
963: ,p_base_table => ame_con_shd.g_tab_nam
964: );
965: end if;
966: --
967: -- ATTRIBUTE_ID is non-updateable

Line 969: nvl(ame_con_shd.g_old_rec.attribute_id,hr_api.g_number ) then

965: end if;
966: --
967: -- ATTRIBUTE_ID is non-updateable
968: if nvl(p_rec.attribute_id, hr_api.g_number) <>
969: nvl(ame_con_shd.g_old_rec.attribute_id,hr_api.g_number ) then
970: hr_api.argument_changed_error
971: (p_api_name => l_proc
972: ,p_argument => 'ATTRIBUTE_ID'
973: ,p_base_table => ame_con_shd.g_tab_nam

Line 973: ,p_base_table => ame_con_shd.g_tab_nam

969: nvl(ame_con_shd.g_old_rec.attribute_id,hr_api.g_number ) then
970: hr_api.argument_changed_error
971: (p_api_name => l_proc
972: ,p_argument => 'ATTRIBUTE_ID'
973: ,p_base_table => ame_con_shd.g_tab_nam
974: );
975: end if;
976: --
977: -- CONDITION_KEY is non-updateable

Line 979: nvl(ame_con_shd.g_old_rec.condition_key,hr_api.g_varchar2 ) then

975: end if;
976: --
977: -- CONDITION_KEY is non-updateable
978: if nvl(p_rec.condition_key, hr_api.g_varchar2) <>
979: nvl(ame_con_shd.g_old_rec.condition_key,hr_api.g_varchar2 ) then
980: hr_api.argument_changed_error
981: (p_api_name => l_proc
982: ,p_argument => 'CONDITION_KEY'
983: ,p_base_table => ame_con_shd.g_tab_nam

Line 983: ,p_base_table => ame_con_shd.g_tab_nam

979: nvl(ame_con_shd.g_old_rec.condition_key,hr_api.g_varchar2 ) then
980: hr_api.argument_changed_error
981: (p_api_name => l_proc
982: ,p_argument => 'CONDITION_KEY'
983: ,p_base_table => ame_con_shd.g_tab_nam
984: );
985: end if;
986: --
987: End chk_non_updateable_args;

Line 1166: (p_rec in ame_con_shd.g_rec_type

1162: -- ----------------------------------------------------------------------------
1163: -- |---------------------------< insert_validate >----------------------------|
1164: -- ----------------------------------------------------------------------------
1165: Procedure insert_validate
1166: (p_rec in ame_con_shd.g_rec_type
1167: ,p_effective_date in date
1168: ,p_datetrack_mode in varchar2
1169: ,p_validation_start_date in date
1170: ,p_validation_end_date in date

Line 1234: (p_rec in ame_con_shd.g_rec_type

1230: -- ----------------------------------------------------------------------------
1231: -- |---------------------------< update_validate >----------------------------|
1232: -- ----------------------------------------------------------------------------
1233: Procedure update_validate
1234: (p_rec in ame_con_shd.g_rec_type
1235: ,p_effective_date in date
1236: ,p_datetrack_mode in varchar2
1237: ,p_validation_start_date in date
1238: ,p_validation_end_date in date

Line 1305: (p_rec in ame_con_shd.g_rec_type

1301: -- ----------------------------------------------------------------------------
1302: -- |---------------------------< delete_validate >----------------------------|
1303: -- ----------------------------------------------------------------------------
1304: Procedure delete_validate
1305: (p_rec in ame_con_shd.g_rec_type
1306: ,p_effective_date in date
1307: ,p_datetrack_mode in varchar2
1308: ,p_validation_start_date in date
1309: ,p_validation_end_date in date