APPS.HXC_APPROVAL_STYLES_API SQL Statements

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

Line: 194

procedure update_approval_styles
  (p_validate                      in     boolean  default false
  ,p_approval_style_id             in     number
  ,p_object_version_number         in out nocopy number
  ,p_name                          in     varchar2
  ,p_business_group_id		   in     number   default hr_api.g_number
  ,p_legislation_code		   in     varchar2 default hr_api.g_varchar2
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_run_recipient_extensions      in     varchar2 default hr_api.g_varchar2
  ,p_admin_role                    in     varchar2 default hr_api.g_varchar2
  ,p_error_admin_role              in     varchar2 default hr_api.g_varchar2
 -- ,p_effective_date                in     date     default null
  )is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 217

	l_proc := g_package||' update_approval_styles';

Line: 223

  savepoint update_approval_styles;

Line: 232

    hxc_approval_styles_bk_1.update_approval_styles_b
    (p_approval_style_id      => p_approval_style_id
    ,p_object_version_number  => p_object_version_number
    ,p_name                   => p_name
    ,p_business_group_id      => p_business_group_id
    ,p_legislation_code	      => p_legislation_code
    ,p_description            => p_description
    ,p_run_recipient_extensions=>p_run_recipient_extensions
    ,p_admin_role             => p_admin_role
    ,p_error_admin_role       => p_error_admin_role
  --  ,p_effective_date         => p_effective_date
    );

Line: 247

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

Line: 280

    hxc_approval_styles_bk_1.update_approval_styles_a
  (p_approval_style_id     => p_approval_style_id
  ,p_object_version_number => p_object_version_number
  ,p_name                  => p_name
  ,p_business_group_id	   => p_business_group_id
  ,p_legislation_code	   => p_legislation_code
  ,p_description           => p_description
  ,p_run_recipient_extensions =>p_run_recipient_extensions
  ,p_admin_role             => p_admin_role
  ,p_error_admin_role       => p_error_admin_role
 -- ,p_effective_date        => p_effective_date
  );

Line: 295

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

Line: 325

    ROLLBACK TO update_approval_styles;

Line: 341

    ROLLBACK TO update_approval_styles;

Line: 347

END update_approval_styles;

Line: 353

procedure delete_approval_styles
  (p_validate                       in  boolean  default false
  ,p_approval_style_id              in  number
  ,p_object_version_number          in  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 367

	l_proc := g_package||'delete_approval_styles';

Line: 373

  savepoint delete_approval_styles;

Line: 383

          hxc_approval_styles_bk_1.delete_approval_styles_b
          (p_approval_style_id => p_approval_style_id
          ,p_object_version_number => p_object_version_number
          );

Line: 390

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

Line: 415

        hxc_approval_styles_bk_1.delete_approval_styles_a
          (p_approval_style_id => p_approval_style_id
          ,p_object_version_number => p_object_version_number
          );

Line: 422

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

Line: 444

    ROLLBACK TO delete_approval_styles;

Line: 450

    ROLLBACK TO delete_approval_styles;

Line: 453

end delete_approval_styles;