APPS.OKC_NUMBER_SCHEME_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: 62

     SELECT OKC_NUMBER_SCHEMES_B_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_NUMBER_SCHEMES_V_pk_csr (cp_num_scheme_id IN NUMBER) IS
    SELECT
            NUMBER_ARTICLE_YN,
            LANGUAGE,
            SOURCE_LANG,
            SCHEME_NAME,
            NUM_SCHEME_PREVIEW,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE
      FROM OKC_NUMBER_SCHEMES_V t
     WHERE t.NUM_SCHEME_ID = cp_num_scheme_id;

Line: 174

            x_last_updated_by,
            x_last_update_login,
            x_last_update_date;

Line: 238

    l_last_updated_by       OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

Line: 239

    l_last_update_login     OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

Line: 240

    l_last_update_date      OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

Line: 265

        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: 656

      l_last_updated_by       OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

Line: 657

      l_last_update_login     OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

Line: 658

      l_last_update_date      OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

Line: 754

  FUNCTION Insert_Row(
    p_num_scheme_id         IN NUMBER,
    p_number_article_yn     IN VARCHAR2,
    p_num_scheme_preview    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: 775

     	    G_PKG_NAME, '3600: Entered Insert_Row function' );

Line: 778

    INSERT INTO OKC_NUMBER_SCHEMES_B(
        NUM_SCHEME_ID,
        NUMBER_ARTICLE_YN,
        NUM_SCHEME_PREVIEW,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE)
      VALUES (
        p_num_scheme_id,
        p_number_article_yn,
        p_num_scheme_preview,
        p_object_version_number,
        p_created_by,
        p_creation_date,
        p_last_updated_by,
        p_last_update_login,
        p_last_update_date);

Line: 800

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

Line: 805

     	    G_PKG_NAME, '3700: Leaving Insert_Row' );

Line: 814

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

Line: 819

	      G_PKG_NAME, '3800: Leaving Insert_Row:OTHERS Exception' );

Line: 831

  END Insert_Row;

Line: 837

  FUNCTION Insert_Row(
    p_num_scheme_id         IN NUMBER,
    p_scheme_name           IN VARCHAR2,
    p_num_scheme_preview    IN VARCHAR2,
    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
    CURSOR get_languages IS
      SELECT language_code
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 856

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

Line: 861

     	    G_PKG_NAME, '3900: Entered Insert_Row function' );

Line: 865

      INSERT INTO OKC_NUMBER_SCHEMES_TL(
          NUM_SCHEME_ID,
          SCHEME_NAME,
          CREATED_BY,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_LOGIN,
          LAST_UPDATE_DATE,
          SOURCE_LANG,
          LANGUAGE)
       VALUES (
          p_num_scheme_id,
          p_scheme_name,
          p_created_by,
          p_creation_date,
          p_last_updated_by,
          p_last_update_login,
          p_last_update_date,
          l_ulang,
          l_lang_rec.language_code);

Line: 888

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

Line: 893

     	    G_PKG_NAME, '4000: Leaving Insert_Row' );

Line: 902

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

Line: 907

	      G_PKG_NAME, '4100: Leaving Insert_Row:OTHERS Exception' );

Line: 919

  END Insert_Row;

Line: 925

  PROCEDURE Insert_Row(
    p_validation_level	      IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    x_return_status           OUT NOCOPY VARCHAR2,

    p_num_scheme_id         IN NUMBER,
    p_number_article_yn     IN VARCHAR2,
    p_scheme_name           IN VARCHAR2,
    p_num_scheme_preview    IN VARCHAR2,

    x_num_scheme_id         OUT NOCOPY NUMBER

  ) IS

    l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;

Line: 941

    l_last_updated_by       OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

Line: 942

    l_last_update_login     OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

Line: 943

    l_last_update_date      OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

Line: 949

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

Line: 954

     	    G_PKG_NAME, '4200: Entered Insert_Row' );

Line: 977

    l_last_update_date := l_creation_date;

Line: 978

    l_last_updated_by := l_created_by;

Line: 979

    l_last_update_login := Fnd_Global.Login_Id;

Line: 1001

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

Line: 1006

     	    G_PKG_NAME, '4300: Call the internal Insert_Row for Base Table' );

Line: 1009

    x_return_status := Insert_Row(
      p_num_scheme_id         => x_num_scheme_id,
      p_number_article_yn     => p_number_article_yn,
      p_num_scheme_preview    => p_num_scheme_preview,
      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: 1031

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

Line: 1036

     	    G_PKG_NAME, '4400: Call the internal Insert_Row for TL Table' );

Line: 1039

    x_return_status := Insert_Row(
      p_num_scheme_id         => x_num_scheme_id,
      p_scheme_name           => p_scheme_name,
      p_num_scheme_preview    => p_num_scheme_preview,
      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: 1057

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

Line: 1062

     	    G_PKG_NAME, '4500: Leaving Insert_Row' );

Line: 1068

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

Line: 1073

	      G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );

Line: 1079

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

Line: 1084

	      G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

Line: 1090

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

Line: 1095

	      G_PKG_NAME, '4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm );

Line: 1105

  END Insert_Row;

Line: 1121

    SELECT object_version_number
      FROM OKC_NUMBER_SCHEMES_B
     WHERE NUM_SCHEME_ID = cp_num_scheme_id
       AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
    FOR UPDATE OF object_version_number NOWAIT;

Line: 1128

    SELECT object_version_number
      FROM OKC_NUMBER_SCHEMES_B
     WHERE NUM_SCHEME_ID = cp_num_scheme_id;

Line: 1183

        Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

Line: 1187

        Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1246

    SELECT *
      FROM OKC_NUMBER_SCHEMES_TL
     WHERE NUM_SCHEME_ID = cp_num_scheme_id
    FOR UPDATE NOWAIT;

Line: 1293

      Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

Line: 1450

  FUNCTION Update_Row(
    p_num_scheme_id         IN NUMBER,
    p_number_article_yn     IN VARCHAR2,
    p_num_scheme_preview    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: 1468

     	    G_PKG_NAME, '6400: Entered Update_Row' );

Line: 1471

    UPDATE OKC_NUMBER_SCHEMES_B
     SET NUMBER_ARTICLE_YN     = p_number_article_yn,
         NUM_SCHEME_PREVIEW    = p_num_scheme_preview,
         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 NUM_SCHEME_ID         = p_num_scheme_id;

Line: 1481

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

Line: 1486

     	    G_PKG_NAME, '6500: Leaving Update_Row' );

Line: 1495

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

Line: 1500

	      G_PKG_NAME, '6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm );

Line: 1512

  END Update_Row;

Line: 1517

  FUNCTION Update_Row(
    p_num_scheme_id         IN NUMBER,
    p_scheme_name           IN VARCHAR2,
    p_num_scheme_preview    IN VARCHAR2,
    p_last_updated_by       IN NUMBER,
    p_last_update_login     IN NUMBER,
    p_last_update_date      IN DATE
   ) RETURN VARCHAR2 IS
    l_ulang fnd_languages.language_code%TYPE := okc_util.get_userenv_lang;

Line: 1529

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

Line: 1534

     	    G_PKG_NAME, '6700: Entered Update_Row' );

Line: 1537

    UPDATE OKC_NUMBER_SCHEMES_TL
     SET SCHEME_NAME           = p_scheme_name,
         LAST_UPDATED_BY       = p_last_updated_by,
         LAST_UPDATE_LOGIN     = p_last_update_login,
         LAST_UPDATE_DATE      = p_last_update_date,
         SOURCE_LANG           = l_ulang
    WHERE NUM_SCHEME_ID         = p_num_scheme_id AND l_ulang in (SOURCE_LANG,LANGUAGE);

Line: 1547

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

Line: 1552

     	    G_PKG_NAME, '6800: Leaving Update_Row' );

Line: 1561

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

Line: 1566

	      G_PKG_NAME, '6900: Leaving Update_Row because of EXCEPTION: '||sqlerrm );

Line: 1578

  END Update_Row;

Line: 1583

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

    x_return_status         OUT NOCOPY VARCHAR2,

    p_num_scheme_id         IN NUMBER,
    p_number_article_yn     IN VARCHAR2 := NULL,
    p_scheme_name           IN VARCHAR2 := NULL,
    p_num_scheme_preview    IN VARCHAR2 := NULL,

    p_object_version_number IN NUMBER

   ) IS

    l_number_article_yn     OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;

Line: 1601

    l_last_updated_by       OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

Line: 1602

    l_last_update_login     OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

Line: 1603

    l_last_update_date      OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

Line: 1608

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

Line: 1614

     	    G_PKG_NAME, '7000: Entered Update_Row' );

Line: 1708

    l_last_update_date := SYSDATE;

Line: 1709

    l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 1710

    l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1729

    x_return_status := Update_Row(
      p_num_scheme_id         => p_num_scheme_id,
      p_number_article_yn     => l_number_article_yn,
      p_num_scheme_preview    => l_num_scheme_preview,
      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: 1754

    x_return_status := Update_Row(
      p_num_scheme_id         => p_num_scheme_id,
      p_scheme_name           => l_scheme_name,
      p_num_scheme_preview    => l_num_scheme_preview,
      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: 1769

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

Line: 1774

     	    G_PKG_NAME, '7800: Leaving Update_Row' );

Line: 1780

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

Line: 1785

	     G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );

Line: 1791

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

Line: 1796

	     G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

Line: 1802

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

Line: 1807

	     G_PKG_NAME, '8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm );

Line: 1817

  END Update_Row;

Line: 1825

  FUNCTION Delete_Row(
    p_num_scheme_id         IN NUMBER
  ) RETURN VARCHAR2 IS

  BEGIN

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

Line: 1837

     	    G_PKG_NAME, '8200: Entered Delete_Row' );

Line: 1840

    DELETE FROM OKC_NUMBER_SCHEMES_B
      WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID;

Line: 1844

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

Line: 1849

     	    G_PKG_NAME, '8300: Leaving Delete_Row' );

Line: 1858

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

Line: 1863

	      G_PKG_NAME, '8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );

Line: 1875

  END Delete_Row;

Line: 1881

  FUNCTION Delete_Row_T(
    p_num_scheme_id         IN NUMBER
  ) RETURN VARCHAR2 IS

  BEGIN

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

Line: 1893

     	    G_PKG_NAME, '8500: Entered Delete_Row' );

Line: 1896

    DELETE FROM OKC_NUMBER_SCHEMES_TL
      WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID;

Line: 1900

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

Line: 1905

     	    G_PKG_NAME, '8600: Leaving Delete_Row' );

Line: 1914

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

Line: 1919

	      G_PKG_NAME, '8700: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );

Line: 1931

  END Delete_Row_T;

Line: 1936

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

Line: 1945

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

Line: 1951

     	    G_PKG_NAME, '8800: Entered Delete_Row' );

Line: 1994

    x_return_status := Delete_Row( p_num_scheme_id => p_num_scheme_id );

Line: 2010

    x_return_status := Delete_Row_T( p_num_scheme_id => p_num_scheme_id );

Line: 2019

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

Line: 2024

     	    G_PKG_NAME, '9300: Leaving Delete_Row' );

Line: 2030

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

Line: 2035

	      G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );

Line: 2041

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

Line: 2046

	      G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

Line: 2052

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

Line: 2057

	      G_PKG_NAME, '9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );

Line: 2067

  END Delete_Row;