APPS.HXC_APPROVAL_COMPS_API SQL Statements

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

Line: 219

procedure update_approval_comps
  (p_validate                      in     boolean  default false
  ,p_approval_comp_id              in     number
  ,p_object_version_number         in out nocopy number
  ,p_approval_mechanism            in     varchar2
  ,p_approval_style_id             in     number
  ,p_time_recipient_id             in     number   default null
  ,p_start_date                    in     date
  ,p_end_date                      in     date
  ,p_approval_mechanism_id         in     number   default null
  ,p_approval_order                in     number   default null
  ,p_wf_item_type                  in     varchar2 default null
  ,p_wf_name                       in     varchar2 default null
  ,p_effective_date                in     date     default null
  ,p_time_category_id              in     number   default null
  ,p_parent_comp_id                in     number   default null
  ,p_parent_comp_ovn               in     number   default null
  ,p_run_recipient_extensions      in     varchar2 default null
  )is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 248

	l_proc := g_package||' update_approval_comps';

Line: 254

  savepoint update_approval_comps;

Line: 263

    hxc_approval_comps_bk_1.update_approval_comps_b
  (p_approval_comp_id        => p_approval_comp_id
  ,p_object_version_number   => p_object_version_number
  ,p_approval_mechanism      => p_approval_mechanism
  ,p_approval_style_id       => p_approval_style_id
  ,p_time_recipient_id       => p_time_recipient_id
  ,p_start_date              => p_start_date
  ,p_end_date                => p_end_date
  ,p_approval_mechanism_id   => p_approval_mechanism_id
  ,p_approval_order          => p_approval_order
  ,p_wf_item_type            => p_wf_item_type
  ,p_wf_name                 => p_wf_name
  ,p_effective_date          => p_effective_date
  ,p_time_category_id      => p_time_category_id
  ,p_parent_comp_id        => p_parent_comp_id
  ,p_parent_comp_ovn       => p_parent_comp_ovn
  ,p_run_recipient_extensions => p_run_recipient_extensions
   );

Line: 284

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

Line: 324

    hxc_approval_comps_bk_1.update_approval_comps_a
  (p_approval_comp_id        => p_approval_comp_id
  ,p_object_version_number   => p_object_version_number
  ,p_approval_mechanism      => p_approval_mechanism
  ,p_approval_style_id       => p_approval_style_id
  ,p_time_recipient_id       => p_time_recipient_id
  ,p_start_date              => p_start_date
  ,p_end_date                => p_end_date
  ,p_approval_mechanism_id   => p_approval_mechanism_id
  ,p_approval_order          => p_approval_order
  ,p_wf_item_type            => p_wf_item_type
  ,p_wf_name                 => p_wf_name
  ,p_effective_date          => p_effective_date
  ,p_time_category_id      => p_time_category_id
  ,p_parent_comp_id        => p_parent_comp_id
  ,p_parent_comp_ovn       => p_parent_comp_ovn
  ,p_run_recipient_extensions => p_run_recipient_extensions
   );

Line: 345

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

Line: 375

    ROLLBACK TO update_approval_comps;

Line: 391

    ROLLBACK TO update_approval_comps;

Line: 397

END update_approval_comps;

Line: 403

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

Line: 417

	l_proc := g_package||'delete_approval_comps';

Line: 423

  savepoint delete_approval_comps;

Line: 433

          hxc_approval_comps_bk_1.delete_approval_comps_b
          (p_approval_comp_id      => p_approval_comp_id
          ,p_object_version_number => p_object_version_number
          );

Line: 440

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

Line: 465

        hxc_approval_comps_bk_1.delete_approval_comps_a
          (p_approval_comp_id      => p_approval_comp_id
          ,p_object_version_number => p_object_version_number
          );

Line: 472

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

Line: 494

    ROLLBACK TO delete_approval_comps;

Line: 500

    ROLLBACK TO delete_approval_comps;

Line: 503

end delete_approval_comps;