APPS.OTA_LP_CATEGORY_API SQL Statements

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

Line: 224

procedure update_lp_cat_inclusion
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_learning_path_id          in number
  ,p_object_version_number        in out nocopy number
  ,p_attribute_category     in varchar2     default hr_api.g_varchar2
  ,p_attribute1             in varchar2     default hr_api.g_varchar2
  ,p_attribute2             in varchar2     default hr_api.g_varchar2
  ,p_attribute3             in varchar2     default hr_api.g_varchar2
  ,p_attribute4             in varchar2     default hr_api.g_varchar2
  ,p_attribute5             in varchar2     default hr_api.g_varchar2
  ,p_attribute6             in varchar2     default hr_api.g_varchar2
  ,p_attribute7             in varchar2     default hr_api.g_varchar2
  ,p_attribute8             in varchar2     default hr_api.g_varchar2
  ,p_attribute9             in varchar2     default hr_api.g_varchar2
  ,p_attribute10            in varchar2     default hr_api.g_varchar2
  ,p_attribute11            in varchar2     default hr_api.g_varchar2
  ,p_attribute12            in varchar2     default hr_api.g_varchar2
  ,p_attribute13            in varchar2     default hr_api.g_varchar2
  ,p_attribute14            in varchar2     default hr_api.g_varchar2
  ,p_attribute15            in varchar2     default hr_api.g_varchar2
  ,p_attribute16            in varchar2     default hr_api.g_varchar2
  ,p_attribute17            in varchar2     default hr_api.g_varchar2
  ,p_attribute18            in varchar2     default hr_api.g_varchar2
  ,p_attribute19            in varchar2     default hr_api.g_varchar2
  ,p_attribute20            in varchar2     default hr_api.g_varchar2
  ,p_start_date_active            in date         default hr_api.g_date
  ,p_end_date_active              in date         default hr_api.g_date
  ,p_primary_flag                 in varchar2     default hr_api.g_varchar2
  ,p_category_usage_id            in number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' update_lp_cat_inclusion ';

Line: 267

  savepoint update_lp_cat_inclusion ;

Line: 278

    ota_lp_category_bk2.update_lp_cat_inclusion_b
   (p_effective_date             => l_effective_date,
   p_learning_path_id        => p_learning_path_id ,
  p_object_version_number       => p_object_version_number,
  p_attribute_category    => p_attribute_category,
  p_attribute1            => p_attribute1,
  p_attribute2            => p_attribute2,
  p_attribute3            => p_attribute3,
  p_attribute4            => p_attribute4,
  p_attribute5            => p_attribute5 ,
  p_attribute6            => p_attribute6,
  p_attribute7            => p_attribute7,
  p_attribute8            => p_attribute8,
  p_attribute9            => p_attribute9,
  p_attribute10           => p_attribute10,
  p_attribute11           => p_attribute11,
  p_attribute12           => p_attribute12,
  p_attribute13           => p_attribute13,
  p_attribute14           => p_attribute14,
  p_attribute15           => p_attribute15,
  p_attribute16           => p_attribute16,
  p_attribute17           => p_attribute17,
  p_attribute18           => p_attribute18,
  p_attribute19           => p_attribute19,
  p_attribute20           => p_attribute20,
  p_start_date_active           => p_start_date_active,
  p_end_date_active             => p_end_date_active,
  p_primary_flag                => p_primary_flag,
  p_category_usage_id           => p_category_usage_id
);

Line: 312

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

Line: 356

  ota_lp_category_bk2.update_lp_cat_inclusion_a
   (p_effective_date             => l_effective_date,
   p_learning_path_id        => p_learning_path_id ,
  p_object_version_number       => p_object_version_number,
  p_attribute_category    => p_attribute_category,
  p_attribute1            => p_attribute1,
  p_attribute2            => p_attribute2,
  p_attribute3            => p_attribute3,
  p_attribute4            => p_attribute4,
  p_attribute5            => p_attribute5 ,
  p_attribute6            => p_attribute6,
  p_attribute7            => p_attribute7,
  p_attribute8            => p_attribute8,
  p_attribute9            => p_attribute9,
  p_attribute10           => p_attribute10,
  p_attribute11           => p_attribute11,
  p_attribute12           => p_attribute12,
  p_attribute13           => p_attribute13,
  p_attribute14           => p_attribute14,
  p_attribute15           => p_attribute15,
  p_attribute16           => p_attribute16,
  p_attribute17           => p_attribute17,
  p_attribute18           => p_attribute18,
  p_attribute19           => p_attribute19,
  p_attribute20           => p_attribute20,
  p_start_date_active           => p_start_date_active,
  p_end_date_active             => p_end_date_active,
  p_primary_flag                => p_primary_flag,
  p_category_usage_id           => p_category_usage_id
  );

Line: 389

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

Line: 411

    rollback to update_lp_cat_inclusion ;

Line: 423

    rollback to update_lp_cat_inclusion ;

Line: 427

end update_lp_cat_inclusion ;

Line: 434

procedure delete_lp_cat_inclusion
( p_learning_path_id                in number,
  p_category_usage_id                   in varchar2,
  p_object_version_number              in number,
  p_validate                           in boolean default false

  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' delete_lp_cat_inclusion ';

Line: 451

  savepoint delete_lp_cat_inclusion ;

Line: 456

    ota_lp_category_bk3.delete_lp_cat_inclusion_b
    (p_learning_path_id        => p_learning_path_id ,
     p_category_usage_id           => p_category_usage_id,
     p_object_version_number       => p_object_version_number);

Line: 464

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

Line: 482

  ota_lp_category_bk3.delete_lp_cat_inclusion_a
    (p_learning_path_id        => p_learning_path_id ,
     p_category_usage_id           => p_category_usage_id,
     p_object_version_number       => p_object_version_number);

Line: 489

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

Line: 510

    rollback to delete_lp_cat_inclusion ;

Line: 521

    rollback to delete_lp_cat_inclusion ;

Line: 524

end delete_lp_cat_inclusion;