APPS.OKC_ALLOWED_TMPL_USAGES_PVT SQL Statements

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

Line: 11

  G_RECORD_DELETED             CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

Line: 13

  G_RECORD_LOGICALLY_DELETED   CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line: 63

     SELECT OKC_ALLOWED_TMPL_USAGES_S.NEXTVAL FROM DUAL;

Line: 132

    x_last_updated_by        OUT NOCOPY NUMBER,
    x_last_update_login      OUT NOCOPY NUMBER,
    x_last_update_date       OUT NOCOPY DATE

  ) RETURN VARCHAR2 IS
    CURSOR OKC_ALLOWED_TMPL_USAGES_pk_csr (cp_allowed_tmpl_usages_id IN NUMBER) IS
    SELECT
            TEMPLATE_ID,
            DOCUMENT_TYPE,
            DEFAULT_YN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE
      FROM OKC_ALLOWED_TMPL_USAGES t
     WHERE t.ALLOWED_TMPL_USAGES_ID = cp_allowed_tmpl_usages_id;

Line: 197

            x_last_updated_by,
            x_last_update_login,
            x_last_update_date;

Line: 283

    l_last_updated_by        OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

Line: 284

    l_last_update_login      OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line: 285

    l_last_update_date       OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line: 317

        x_last_updated_by        => l_last_updated_by,
        x_last_update_login      => l_last_update_login,
        x_last_update_date       => l_last_update_date
      );

Line: 513

     SELECT '!'
      FROM okc_terms_templates_all
      WHERE TEMPLATE_ID = p_template_id;

Line: 518

     SELECT '!'
      FROM okc_bus_doc_types_b
      WHERE DOCUMENT_TYPE = p_document_type;

Line: 523

     SELECT intent
     FROM okc_terms_templates_all
     WHERE template_id = p_template_id;

Line: 528

    SELECT intent
    FROM OKC_BUS_DOC_TYPES_B
    WHERE document_type = p_document_type;

Line: 533

      SELECT name
      FROM okc_bus_doc_types_vl
      WHERE document_type = p_document_type;

Line: 719

      SELECT parent_template_id,org_id
      FROM   okc_terms_templates_all
      WHERE  template_id = p_template_id;

Line: 725

      SELECT tmpl.template_name
      FROM okc_allowed_tmpl_usages usg,
           okc_terms_templates_all tmpl
      WHERE document_type = p_document_type
      AND allowed_tmpl_usages_id <> nvl(p_allowed_tmpl_usages_id, -9999)
      AND nvl(usg.default_yn,'N') = 'Y'
      AND ((tmpl.template_id <> pc_parent_tmpl_id AND pc_parent_tmpl_id IS NOT NULL) OR
           (pc_parent_tmpl_id IS NULL))
      AND NVL(tmpl.org_id,-99) = NVL(pc_org_id,-99)
      AND usg.template_id = tmpl.template_id;

Line: 736

      SELECT '!'
      FROM okc_allowed_tmpl_usages
      WHERE template_id = p_template_id
      AND document_type = p_document_type
      AND allowed_tmpl_usages_id <> nvl(p_allowed_tmpl_usages_id, -9999);

Line: 742

      SELECT name
      FROM okc_bus_doc_types_vl
      WHERE document_type = p_document_type;

Line: 919

      l_last_updated_by        OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

Line: 920

      l_last_update_login      OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line: 921

      l_last_update_date       OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line: 1039

  FUNCTION Insert_Row(
    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,
    p_attribute1             IN VARCHAR2,
    p_attribute2             IN VARCHAR2,
    p_attribute3             IN VARCHAR2,
    p_attribute4             IN VARCHAR2,
    p_attribute5             IN VARCHAR2,
    p_attribute6             IN VARCHAR2,
    p_attribute7             IN VARCHAR2,
    p_attribute8             IN VARCHAR2,
    p_attribute9             IN VARCHAR2,
    p_attribute10            IN VARCHAR2,
    p_attribute11            IN VARCHAR2,
    p_attribute12            IN VARCHAR2,
    p_attribute13            IN VARCHAR2,
    p_attribute14            IN VARCHAR2,
    p_attribute15            IN VARCHAR2,
    p_object_version_number  IN NUMBER,
    p_created_by             IN NUMBER,
    p_creation_date          IN DATE,
    p_last_updated_by        IN NUMBER,
    p_last_update_login      IN NUMBER,
    p_last_update_date       IN DATE

  ) RETURN VARCHAR2 IS

  BEGIN

    IF (l_debug = 'Y') THEN
       Okc_Debug.Log('3600: Entered Insert_Row function', 2);

Line: 1075

    INSERT INTO OKC_ALLOWED_TMPL_USAGES(
        TEMPLATE_ID,
        DOCUMENT_TYPE,
        DEFAULT_YN,
        ALLOWED_TMPL_USAGES_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE)
      VALUES (
        p_template_id,
        p_document_type,
        p_default_yn,
        p_allowed_tmpl_usages_id,
        p_attribute_category,
        p_attribute1,
        p_attribute2,
        p_attribute3,
        p_attribute4,
        p_attribute5,
        p_attribute6,
        p_attribute7,
        p_attribute8,
        p_attribute9,
        p_attribute10,
        p_attribute11,
        p_attribute12,
        p_attribute13,
        p_attribute14,
        p_attribute15,
        p_object_version_number,
        p_created_by,
        p_creation_date,
        p_last_updated_by,
        p_last_update_login,
        p_last_update_date);

Line: 1131

       Okc_Debug.Log('3700: Leaving Insert_Row', 2);

Line: 1140

         Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);

Line: 1152

  END Insert_Row;

Line: 1158

  PROCEDURE Insert_Row(
    p_validation_level	      IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    x_return_status           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  := NULL,

    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,

    x_allowed_tmpl_usages_id OUT NOCOPY NUMBER

  ) IS

    l_object_version_number  OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;

Line: 1191

    l_last_updated_by        OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

Line: 1192

    l_last_update_login      OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line: 1193

    l_last_update_date       OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line: 1199

       Okc_Debug.Log('4200: Entered Insert_Row', 2);

Line: 1222

    l_last_update_date := l_creation_date;

Line: 1223

    l_last_updated_by := l_created_by;

Line: 1224

    l_last_update_login := Fnd_Global.Login_Id;

Line: 1262

       Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);

Line: 1265

    x_return_status := Insert_Row(
      p_allowed_tmpl_usages_id => x_allowed_tmpl_usages_id,
      p_template_id            => p_template_id,
      p_document_type          => p_document_type,
      p_default_yn             => p_default_yn,
      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  => l_object_version_number,
      p_created_by             => l_created_by,
      p_creation_date          => l_creation_date,
      p_last_updated_by        => l_last_updated_by,
      p_last_update_login      => l_last_update_login,
      p_last_update_date       => l_last_update_date
    );

Line: 1302

       Okc_Debug.Log('4500: Leaving Insert_Row', 2);

Line: 1308

         Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);

Line: 1314

         Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

Line: 1320

         Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);

Line: 1330

  END Insert_Row;

Line: 1347

    SELECT object_version_number
      FROM OKC_ALLOWED_TMPL_USAGES
     WHERE ALLOWED_TMPL_USAGES_ID = cp_allowed_tmpl_usages_id
       AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
    FOR UPDATE OF object_version_number NOWAIT;

Line: 1354

    SELECT object_version_number
      FROM OKC_ALLOWED_TMPL_USAGES
     WHERE ALLOWED_TMPL_USAGES_ID = cp_allowed_tmpl_usages_id;

Line: 1394

        Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

Line: 1398

        Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1503

  FUNCTION Update_Row(
    p_allowed_tmpl_usages_id IN NUMBER,
    p_template_id            IN NUMBER,
    p_document_type          IN VARCHAR2,
    p_default_yn             IN VARCHAR2,
    p_attribute_category     IN VARCHAR2,
    p_attribute1             IN VARCHAR2,
    p_attribute2             IN VARCHAR2,
    p_attribute3             IN VARCHAR2,
    p_attribute4             IN VARCHAR2,
    p_attribute5             IN VARCHAR2,
    p_attribute6             IN VARCHAR2,
    p_attribute7             IN VARCHAR2,
    p_attribute8             IN VARCHAR2,
    p_attribute9             IN VARCHAR2,
    p_attribute10            IN VARCHAR2,
    p_attribute11            IN VARCHAR2,
    p_attribute12            IN VARCHAR2,
    p_attribute13            IN VARCHAR2,
    p_attribute14            IN VARCHAR2,
    p_attribute15            IN VARCHAR2,
    p_object_version_number  IN NUMBER,
    p_last_updated_by        IN NUMBER,
    p_last_update_login      IN NUMBER,
    p_last_update_date       IN DATE
   ) RETURN VARCHAR2 IS

  BEGIN

    IF (l_debug = 'Y') THEN
       Okc_Debug.Log('6400: Entered Update_Row', 2);

Line: 1536

    UPDATE OKC_ALLOWED_TMPL_USAGES
     SET TEMPLATE_ID            = p_template_id,
         DOCUMENT_TYPE          = p_document_type,
         DEFAULT_YN             = p_default_yn,
         ATTRIBUTE_CATEGORY     = p_attribute_category,
         ATTRIBUTE1             = p_attribute1,
         ATTRIBUTE2             = p_attribute2,
         ATTRIBUTE3             = p_attribute3,
         ATTRIBUTE4             = p_attribute4,
         ATTRIBUTE5             = p_attribute5,
         ATTRIBUTE6             = p_attribute6,
         ATTRIBUTE7             = p_attribute7,
         ATTRIBUTE8             = p_attribute8,
         ATTRIBUTE9             = p_attribute9,
         ATTRIBUTE10            = p_attribute10,
         ATTRIBUTE11            = p_attribute11,
         ATTRIBUTE12            = p_attribute12,
         ATTRIBUTE13            = p_attribute13,
         ATTRIBUTE14            = p_attribute14,
         ATTRIBUTE15            = p_attribute15,
         OBJECT_VERSION_NUMBER  = p_object_version_number,
         LAST_UPDATED_BY        = p_last_updated_by,
         LAST_UPDATE_LOGIN      = p_last_update_login,
         LAST_UPDATE_DATE       = p_last_update_date
    WHERE ALLOWED_TMPL_USAGES_ID = p_allowed_tmpl_usages_id;

Line: 1563

       Okc_Debug.Log('6500: Leaving Update_Row', 2);

Line: 1572

         Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);

Line: 1584

  END Update_Row;

Line: 1589

  PROCEDURE Update_Row(
    p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

    x_return_status                OUT NOCOPY VARCHAR2,

    p_allowed_tmpl_usages_id IN NUMBER,

    p_template_id            IN NUMBER := NULL,
    p_document_type          IN VARCHAR2 := NULL,
    p_default_yn             IN VARCHAR2 := NULL,
    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_template_id            OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;

Line: 1640

    l_last_updated_by        OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

Line: 1641

    l_last_update_login      OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line: 1642

    l_last_update_date       OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line: 1647

       Okc_Debug.Log('7000: Entered Update_Row', 2);

Line: 1754

    l_last_update_date := SYSDATE;

Line: 1755

    l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 1756

    l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1770

    x_return_status := Update_Row(
      p_allowed_tmpl_usages_id => p_allowed_tmpl_usages_id,
      p_template_id            => l_template_id,
      p_document_type          => l_document_type,
      p_default_yn             => l_default_yn,
      p_attribute_category     => l_attribute_category,
      p_attribute1             => l_attribute1,
      p_attribute2             => l_attribute2,
      p_attribute3             => l_attribute3,
      p_attribute4             => l_attribute4,
      p_attribute5             => l_attribute5,
      p_attribute6             => l_attribute6,
      p_attribute7             => l_attribute7,
      p_attribute8             => l_attribute8,
      p_attribute9             => l_attribute9,
      p_attribute10            => l_attribute10,
      p_attribute11            => l_attribute11,
      p_attribute12            => l_attribute12,
      p_attribute13            => l_attribute13,
      p_attribute14            => l_attribute14,
      p_attribute15            => l_attribute15,
      p_object_version_number  => l_object_version_number,
      p_last_updated_by        => l_last_updated_by,
      p_last_update_login      => l_last_update_login,
      p_last_update_date       => l_last_update_date
    );

Line: 1804

      Okc_Debug.Log('7800: Leaving Update_Row', 2);

Line: 1810

        Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);

Line: 1816

        Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

Line: 1822

        Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);

Line: 1832

  END Update_Row;

Line: 1840

  FUNCTION Delete_Row(
    p_allowed_tmpl_usages_id IN NUMBER
  ) RETURN VARCHAR2 IS

  BEGIN

    IF (l_debug = 'Y') THEN
       Okc_Debug.Log('8200: Entered Delete_Row', 2);

Line: 1850

    DELETE FROM OKC_ALLOWED_TMPL_USAGES
      WHERE ALLOWED_TMPL_USAGES_ID = p_ALLOWED_TMPL_USAGES_ID;

Line: 1854

       Okc_Debug.Log('8300: Leaving Delete_Row', 2);

Line: 1863

         Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);

Line: 1875

  END Delete_Row;

Line: 1880

  PROCEDURE Delete_Row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_allowed_tmpl_usages_id IN NUMBER,
    p_object_version_number  IN NUMBER
  ) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'B_Delete_Row';

Line: 1889

       Okc_Debug.Log('8800: Entered Delete_Row', 2);

Line: 1907

    x_return_status := Delete_Row( p_allowed_tmpl_usages_id => p_allowed_tmpl_usages_id );

Line: 1916

       Okc_Debug.Log('9300: Leaving Delete_Row', 2);

Line: 1922

         Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);

Line: 1928

         Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

Line: 1934

         Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);

Line: 1944

  END Delete_Row;