APPS.OKC_ALLOWED_TMPL_USAGES_GRP SQL Statements

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

Line: 209

    l_last_updated_by        OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

Line: 210

    l_last_update_login      OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line: 211

    l_last_update_date       OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line: 234

    OKC_ALLOWED_TMPL_USAGES_PVT.Insert_Row(
      p_validation_level           =>   p_validation_level,
      x_return_status              =>   x_return_status,
      p_template_id            => p_template_id,
      p_document_type          => p_document_type,
      p_default_yn             => p_default_yn,
      p_allowed_tmpl_usages_id => p_allowed_tmpl_usages_id,
      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,
      x_allowed_tmpl_usages_id => x_allowed_tmpl_usages_id
    );

Line: 399

  PROCEDURE Update_Allowed_Tmpl_Usages(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    p_commit                       IN VARCHAR2 := FND_API.G_FALSE,

    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,

    p_template_id            IN NUMBER,
    p_document_type          IN VARCHAR2,
    p_default_yn             IN VARCHAR2,
    p_allowed_tmpl_usages_id IN NUMBER,

    p_attribute_category     IN VARCHAR2 := NULL,
    p_attribute1             IN VARCHAR2 := NULL,
    p_attribute2             IN VARCHAR2 := NULL,
    p_attribute3             IN VARCHAR2 := NULL,
    p_attribute4             IN VARCHAR2 := NULL,
    p_attribute5             IN VARCHAR2 := NULL,
    p_attribute6             IN VARCHAR2 := NULL,
    p_attribute7             IN VARCHAR2 := NULL,
    p_attribute8             IN VARCHAR2 := NULL,
    p_attribute9             IN VARCHAR2 := NULL,
    p_attribute10            IN VARCHAR2 := NULL,
    p_attribute11            IN VARCHAR2 := NULL,
    p_attribute12            IN VARCHAR2 := NULL,
    p_attribute13            IN VARCHAR2 := NULL,
    p_attribute14            IN VARCHAR2 := NULL,
    p_attribute15            IN VARCHAR2 := NULL,

    p_object_version_number  IN NUMBER

   ) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 436

    l_api_name                     CONSTANT VARCHAR2(30) := 'g_Update_Allowed_Tmpl_Usages';

Line: 441

       okc_debug.log('1600: Entered Update_Allowed_Tmpl_Usages', 2);

Line: 446

    SAVEPOINT g_Update_Allowed_Usages_GRP;

Line: 461

    OKC_ALLOWED_TMPL_USAGES_PVT.Update_Row(
      p_validation_level           => p_validation_level,
      x_return_status              => x_return_status,
      p_template_id            => p_template_id,
      p_document_type          => p_document_type,
      p_default_yn             => p_default_yn,
      p_allowed_tmpl_usages_id => p_allowed_tmpl_usages_id,
      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_object_version_number  => p_object_version_number
    );

Line: 502

      okc_debug.log('1800: Leaving Update_Allowed_Tmpl_Usages', 2);

Line: 508

         okc_debug.log('1900: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 510

      ROLLBACK TO g_Update_Allowed_Usages_GRP;

Line: 516

         okc_debug.log('2000: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 518

      ROLLBACK TO g_Update_Allowed_Usages_GRP;

Line: 524

        okc_debug.log('2100: Leaving Update_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);

Line: 527

      ROLLBACK TO g_Update_Allowed_Usages_GRP;

Line: 534

  END Update_Allowed_Tmpl_Usages;

Line: 539

  PROCEDURE Delete_Allowed_Tmpl_Usages(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    p_commit                       IN VARCHAR2 := FND_API.G_FALSE,

    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,

    p_allowed_tmpl_usages_id IN NUMBER,
    p_object_version_number  IN NUMBER
  ) IS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 552

    l_api_name                     CONSTANT VARCHAR2(30) := 'g_Delete_Allowed_Tmpl_Usages';

Line: 556

       okc_debug.log('2200: Entered Delete_Allowed_Tmpl_Usages', 2);

Line: 560

    SAVEPOINT g_Delete_Allowed_Usages_GRP;

Line: 575

    OKC_ALLOWED_TMPL_USAGES_PVT.Delete_Row(
      x_return_status              =>   x_return_status,
      p_allowed_tmpl_usages_id => p_allowed_tmpl_usages_id,
      p_object_version_number  => p_object_version_number
    );

Line: 596

       okc_debug.log('2300: Leaving Delete_Allowed_Tmpl_Usages', 2);

Line: 602

         okc_debug.log('2400: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 604

      ROLLBACK TO g_Delete_Allowed_Usages_GRP;

Line: 610

         okc_debug.log('2500: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 612

      ROLLBACK TO g_Delete_Allowed_Usages_GRP;

Line: 618

        okc_debug.log('2600: Leaving Delete_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);

Line: 621

      ROLLBACK TO g_Delete_Allowed_Usages_GRP;

Line: 628

  END Delete_Allowed_Tmpl_Usages;