APPS.HXC_ALIAS_DEFINITIONS_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 201

procedure update_alias_definition
  (p_validate                      in     boolean  default false
  ,p_alias_definition_id           in     number
  ,p_alias_definition_name         in     varchar2
  ,p_alias_context_code            in     varchar2  default null
  ,p_business_group_id             in     number   default null
  ,p_legislation_code              in     varchar2 default null
  ,p_description                   in     varchar2 default null
  ,p_prompt                        in     varchar2 default null
  ,p_timecard_field                in     varchar2
  ,p_object_version_number         in out nocopy number
  ,p_language_code                 in     varchar2  default hr_api.userenv_lang
  ,p_alias_type_id 		   in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72);

Line: 226

	l_proc := g_package||'update_alias_definition';

Line: 232

  savepoint update_alias_definition;

Line: 253

    hxc_alias_definitions_bk_1.update_alias_definition_b
      (p_alias_definition_id	       => p_alias_definition_id
      ,p_alias_definition_name         => p_alias_definition_name
      ,p_alias_context_code            => p_alias_context_code
      ,p_business_group_id             => p_business_group_id
      ,p_legislation_code              => p_legislation_code
      ,p_description                   => p_description
      ,p_prompt                        => p_prompt
      ,p_timecard_field                => p_timecard_field
      ,p_object_version_number	       => p_object_version_number
      ,p_language_code                 => l_language_code
      ,p_alias_type_id   	       => p_alias_type_id
      );

Line: 269

        (p_module_name => 'update_alias_definition'
        ,p_hook_type   => 'BP'
        );

Line: 323

    hxc_alias_definitions_bk_1.update_alias_definition_a
      (p_alias_definition_id           => p_alias_definition_id
      ,p_alias_definition_name         => p_alias_definition_name
      ,p_alias_context_code            => p_alias_context_code
      ,p_business_group_id             => p_business_group_id
      ,p_legislation_code              => p_legislation_code
      ,p_description                   => p_description
      ,p_prompt                        => p_prompt
      ,p_timecard_field                => p_timecard_field
      ,p_object_version_number         => l_object_version_number
      ,p_language_code                 => l_language_code
      ,p_alias_type_id		       => p_alias_type_id
      );

Line: 339

        (p_module_name => 'update_alias_definition'
        ,p_hook_type   => 'AP'
        );

Line: 364

    rollback to update_alias_definition;

Line: 379

    rollback to update_alias_definition;

Line: 384

end update_alias_definition;

Line: 390

procedure delete_alias_definition
  (p_validate                      in     boolean  default false
  ,p_alias_definition_id           in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72);

Line: 404

	l_proc := g_package||'delete_alias_definition';

Line: 410

  savepoint delete_alias_definition;

Line: 423

    hxc_alias_definitions_bk_1.delete_alias_definition_b
      (p_alias_definition_id           => p_alias_definition_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 430

        (p_module_name => 'delete_alias_definition'
        ,p_hook_type   => 'BP'
        );

Line: 469

    hxc_alias_definitions_bk_1.delete_alias_definition_a
      (p_alias_definition_id           => p_alias_definition_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 476

        (p_module_name => 'delete_alias_definition'
        ,p_hook_type   => 'AP'
        );

Line: 499

    rollback to delete_alias_definition;

Line: 512

    rollback to delete_alias_definition;

Line: 517

end delete_alias_definition;