APPS.BEN_POPUP_MESSAGE_API SQL Statements

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

Line: 181

procedure update_popup_message
  (p_validate                       in  boolean   default false
  ,p_pop_up_messages_id             in  number
  ,p_pop_name                       in  varchar2  default hr_api.g_varchar2
  ,p_formula_id                     in  number    default hr_api.g_number
  ,p_function_name                  in  varchar2  default hr_api.g_varchar2
  ,p_block_name                     in  varchar2  default hr_api.g_varchar2
  ,p_field_name                     in  varchar2  default hr_api.g_varchar2
  ,p_event_name                     in  varchar2  default hr_api.g_varchar2
  ,p_message                        in  varchar2  default hr_api.g_varchar2
  ,p_message_type                   in  varchar2  default hr_api.g_varchar2
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_object_version_number          in out nocopy number
  ,p_start_date                     in  date      default hr_api.g_date
  ,p_end_date                       in  date      default hr_api.g_date
  ,p_no_formula_flag                in  varchar2  default hr_api.g_varchar2
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_popup_message';

Line: 211

  savepoint update_popup_message;

Line: 223

    ben_popup_message_bk2.update_popup_message_b
      (
       p_pop_up_messages_id             =>  p_pop_up_messages_id
      ,p_pop_name                       =>  p_pop_name
      ,p_formula_id                     =>  p_formula_id
      ,p_function_name                  =>  p_function_name
      ,p_block_name                     =>  p_block_name
      ,p_field_name                     =>  p_field_name
      ,p_event_name                     =>  p_event_name
      ,p_message                        =>  p_message
      ,p_message_type                   =>  p_message_type
      ,p_business_group_id              =>  p_business_group_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_start_date                     =>  p_start_date
      ,p_end_date                       =>  p_end_date
      ,p_no_formula_flag                =>  p_no_formula_flag
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 244

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

Line: 275

    ben_popup_message_bk2.update_popup_message_a
      (
       p_pop_up_messages_id             =>  p_pop_up_messages_id
      ,p_pop_name                       =>  p_pop_name
      ,p_formula_id                     =>  p_formula_id
      ,p_function_name                  =>  p_function_name
      ,p_block_name                     =>  p_block_name
      ,p_field_name                     =>  p_field_name
      ,p_event_name                     =>  p_event_name
      ,p_message                        =>  p_message
      ,p_message_type                   =>  p_message_type
      ,p_business_group_id              =>  p_business_group_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_start_date                     =>  p_start_date
      ,p_end_date                       =>  p_end_date
      ,p_no_formula_flag                =>  p_no_formula_flag
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 296

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

Line: 325

    ROLLBACK TO update_popup_message;

Line: 337

    ROLLBACK TO update_popup_message;

Line: 340

end update_popup_message;

Line: 345

procedure delete_popup_message
  (p_validate                       in  boolean  default false
  ,p_pop_up_messages_id             in  number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_popup_message';

Line: 363

  savepoint delete_popup_message;

Line: 376

    ben_popup_message_bk3.delete_popup_message_b
      (
       p_pop_up_messages_id             =>  p_pop_up_messages_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 385

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

Line: 404

    ben_popup_message_bk3.delete_popup_message_a
      (
       p_pop_up_messages_id             =>  p_pop_up_messages_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 413

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

Line: 438

    ROLLBACK TO delete_popup_message;

Line: 449

    ROLLBACK TO delete_popup_message;

Line: 452

end delete_popup_message;