DBA Data[Home] [Help]

APPS.HR_ASG_BUDGET_VALUE_API SQL Statements

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

Line: 22

  ,p_program_update_date           in     date     default null
  ,p_last_update_date              in     date     default null
  ,p_last_updated_by               in     number   default null
  ,p_last_update_login             in     number   default null
  ,p_created_by                    in     number   default null
  ,p_creation_date                 in     date     default null
  ,p_object_version_number         out nocopy    number
  ,p_assignment_budget_value_id    out nocopy    number
 ) is
  --
  -- Declare cursors and local variables
  --
  l_assignment_budget_value_id  number;
Line: 63

      ,p_program_update_date       => p_program_update_date
      ,p_last_update_date          => p_last_update_date
      ,p_last_updated_by           => p_last_updated_by
      ,p_last_update_login         => p_last_update_login
      ,p_created_by                => p_created_by
      ,p_creation_date             => p_creation_date
);
Line: 89

  ,p_program_update_date           => p_program_update_date
  ,p_effective_start_date          => l_effective_start_date
  ,p_effective_end_date            => l_effective_end_date
  ,p_assignment_budget_value_id    => l_assignment_budget_value_id
  ,p_object_version_number         => p_object_version_number
  );
Line: 117

      ,p_program_update_date       => p_program_update_date
      ,p_last_update_date          => p_last_update_date
      ,p_last_updated_by           => p_last_updated_by
      ,p_last_update_login         => p_last_update_login
      ,p_created_by                => p_created_by
      ,p_creation_date             => p_creation_date
      ,p_assignment_budget_value_id=> l_assignment_budget_value_id
      ,p_effective_start_date      => l_effective_start_date
      ,p_effective_end_date        => l_effective_end_date
      ,p_object_version_number     => l_object_version_number
      );
Line: 179

procedure UPDATE_ASG_BUDGET_VALUE
  (p_validate                      in     boolean default false
  ,p_assignment_budget_value_id    in     number
  ,p_effective_date                in     date
  ,p_datetrack_mode                in     varchar2
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_unit                          in     varchar2 default hr_api.g_varchar2
  ,p_value                         in     number   default hr_api.g_number
  ,p_request_id                    in     number   default hr_api.g_number
  ,p_program_application_id        in     number   default hr_api.g_number
  ,p_program_id                    in     number   default hr_api.g_number
  ,p_program_update_date           in     date     default hr_api.g_date
  ,p_last_update_date              in     date     default hr_api.g_date
  ,p_last_updated_by               in     number   default hr_api.g_number
  ,p_last_update_login             in     number   default hr_api.g_number
  ,p_created_by                    in     number   default hr_api.g_number
  ,p_creation_date                 in     date     default hr_api.g_date
  ,p_object_version_number         in out nocopy number
 ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_start_date        date;
Line: 204

  l_proc                varchar2(72) := g_package||'UPDATE_ASG_BUDGET_VALUE';
Line: 213

  savepoint UPDATE_ASG_BUDGET_VALUE;
Line: 222

    HR_ASG_BUDGET_VALUE_BK2.UPDATE_ASG_BUDGET_VALUE_b
      (p_effective_date            => p_effective_date
      ,p_assignment_budget_value_id=> p_assignment_budget_value_id
      ,p_business_group_id         => p_business_group_id
      ,p_unit                      => p_unit
      ,p_value                     => p_value
      ,p_request_id                => p_request_id
      ,p_program_application_id    => p_program_application_id
      ,p_program_id                => p_program_id
      ,p_program_update_date       => p_program_update_date
      ,p_last_update_date          => p_last_update_date
      ,p_last_updated_by           => p_last_updated_by
      ,p_last_update_login         => p_last_update_login
      ,p_created_by                => p_created_by
      ,p_creation_date             => p_creation_date
      ,p_datetrack_mode            => p_datetrack_mode
      ,p_object_version_number     => p_object_version_number
);
Line: 243

        (p_module_name => 'UPDATE_ASG_BUDGET_VALUE'
        ,p_hook_type   => 'BP'
        );
Line: 262

  ,p_program_update_date           => p_program_update_date
  ,p_effective_start_date          => l_effective_start_date
  ,p_effective_end_date            => l_effective_end_date
  ,p_object_version_number         => p_object_version_number
  );
Line: 271

    HR_ASG_BUDGET_VALUE_BK2.UPDATE_ASG_BUDGET_VALUE_a
      (p_effective_date            => p_effective_date
      ,p_datetrack_mode            => p_datetrack_mode
      ,p_business_group_id         => p_business_group_id
      ,p_unit                      => p_unit
      ,p_value                     => p_value
      ,p_request_id                => p_request_id
      ,p_program_application_id    => p_program_application_id
      ,p_program_id                => p_program_id
      ,p_program_update_date       => p_program_update_date
      ,p_last_update_date          => p_last_update_date
      ,p_last_updated_by           => p_last_updated_by
      ,p_last_update_login         => p_last_update_login
      ,p_created_by                => p_created_by
      ,p_creation_date             => p_creation_date
      ,p_assignment_budget_value_id=> p_assignment_budget_value_id
      ,p_effective_start_date          => l_effective_start_date
      ,p_effective_end_date            => l_effective_end_date
      ,p_object_version_number         => p_object_version_number
       );
Line: 294

        (p_module_name => 'UPDATE_ASG_BUDGET_VALUE'
        ,p_hook_type   => 'AP'
        );
Line: 315

    rollback to UPDATE_ASG_BUDGET_VALUE;
Line: 328

    rollback to UPDATE_ASG_BUDGET_VALUE;
Line: 331

end UPDATE_ASG_BUDGET_VALUE;
Line: 339

procedure DELETE_ASG_BUDGET_VALUE
 (p_validate                       in     boolean  default false
  ,p_assignment_budget_value_id    in     number
  ,p_effective_date                in     date
  ,p_datetrack_mode                in     varchar2
  ,p_object_version_number         in out nocopy number
 ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_start_date        date;
Line: 352

  l_proc                varchar2(72) := g_package||'DELETE_ASG_BUDGET_VALUE';
Line: 362

  savepoint DELETE_ASG_BUDGET_VALUE;
Line: 371

    HR_ASG_BUDGET_VALUE_BK3.DELETE_ASG_BUDGET_VALUE_b
      (p_assignment_budget_value_id=> p_assignment_budget_value_id
      ,p_datetrack_mode            => p_datetrack_mode
      ,p_effective_date            => p_effective_date
      ,p_object_version_number     => p_object_version_number);
Line: 379

        (p_module_name => 'DELETE_ASG_BUDGET_VALUE'
        ,p_hook_type   => 'BP'
        );
Line: 401

    HR_ASG_BUDGET_VALUE_BK3.DELETE_ASG_BUDGET_VALUE_a
      (p_effective_date             => p_effective_date
      ,p_datetrack_mode             => p_datetrack_mode
      ,p_assignment_budget_value_id => p_assignment_budget_value_id
      ,p_effective_start_date       => l_effective_start_date
      ,p_effective_end_date         => l_effective_end_date
      ,p_object_version_number      => l_object_version_number
      );
Line: 412

        (p_module_name => 'DELETE_ASG_BUDGET_VALUE'
        ,p_hook_type   => 'AP'
        );
Line: 434

    rollback to DELETE_ASG_BUDGET_VALUE;
Line: 447

    rollback to DELETE_ASG_BUDGET_VALUE;
Line: 450

end DELETE_ASG_BUDGET_VALUE;