eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_NUMBER_SCHEME_DTL_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: 73


    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_SCHEME_DTLS_pk_csr (cp_num_scheme_id IN NUMBER,cp_num_sequence_code IN VARCHAR2,cp_sequence_level IN NUMBER) IS
    SELECT
            CONCATENATION_YN,
            END_CHARACTER,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE
      FROM OKC_NUMBER_SCHEME_DTLS t
     WHERE t.NUM_SCHEME_ID = cp_num_scheme_id and
           t.NUM_SEQUENCE_CODE = cp_num_sequence_code and
           t.SEQUENCE_LEVEL = cp_sequence_level;

Line: 111


            x_last_updated_by,
            x_last_update_login,
            x_last_update_date;

Line: 176


    l_last_updated_by       OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

Line: 177


    l_last_update_login     OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

Line: 178


    l_last_update_date      OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

Line: 200


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


     SELECT '!'
      FROM OKC_NUMBER_SCHEMES_B
      WHERE NUM_SCHEME_ID = p_num_scheme_id;

Line: 677


      l_last_updated_by       OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

Line: 678


      l_last_update_login     OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

Line: 679


      l_last_update_date      OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

Line: 776


  FUNCTION Insert_Row(
    p_num_scheme_id         IN NUMBER,
    p_num_sequence_code     IN VARCHAR2,
    p_sequence_level        IN NUMBER,
    p_concatenation_yn      IN VARCHAR2,
    p_end_character         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: 799


            G_PKG_NAME, '3600: Entered Insert_Row function' );

Line: 802


    INSERT INTO OKC_NUMBER_SCHEME_DTLS(
        NUM_SCHEME_ID,
        NUM_SEQUENCE_CODE,
        SEQUENCE_LEVEL,
        CONCATENATION_YN,
        END_CHARACTER,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE)
      VALUES (
        p_num_scheme_id,
        p_num_sequence_code,
        p_sequence_level,
        p_concatenation_yn,
        p_end_character,
        p_object_version_number,
        p_created_by,
        p_creation_date,
        p_last_updated_by,
        p_last_update_login,
        p_last_update_date);

Line: 828


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

Line: 833


            G_PKG_NAME, '3700: Leaving Insert_Row' );

Line: 842


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

Line: 847


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

Line: 859


  END Insert_Row;

Line: 865


  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_num_sequence_code     IN VARCHAR2,
    p_sequence_level        IN NUMBER,
    p_concatenation_yn      IN VARCHAR2,
    p_end_character         IN VARCHAR2,



    x_num_scheme_id         OUT NOCOPY NUMBER,
    x_num_sequence_code     OUT NOCOPY VARCHAR2,
    x_sequence_level        OUT NOCOPY NUMBER

  ) IS

    l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;

Line: 886


    l_last_updated_by       OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

Line: 887


    l_last_update_login     OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

Line: 888


    l_last_update_date      OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

Line: 894


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

Line: 899


            G_PKG_NAME, '4200: Entered Insert_Row' );

Line: 911


    l_last_update_date := l_creation_date;

Line: 912


    l_last_updated_by := l_created_by;

Line: 913


    l_last_update_login := Fnd_Global.Login_Id;

Line: 936


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

Line: 941


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

Line: 944


    x_return_status := Insert_Row(
      p_num_scheme_id         => x_num_scheme_id,
      p_num_sequence_code     => x_num_sequence_code,
      p_sequence_level        => x_sequence_level,
      p_concatenation_yn      => p_concatenation_yn,
      p_end_character         => p_end_character,
      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: 966


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

Line: 971


            G_PKG_NAME, '4500: Leaving Insert_Row' );

Line: 977


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

Line: 982


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

Line: 988


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

Line: 993


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

Line: 999


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

Line: 1004


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

Line: 1014


  END Insert_Row;

Line: 1029


    SELECT object_version_number
      FROM OKC_NUMBER_SCHEME_DTLS
     WHERE NUM_SCHEME_ID = cp_num_scheme_id AND NUM_SEQUENCE_CODE = cp_num_sequence_code AND SEQUENCE_LEVEL = cp_sequence_level
       AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
    FOR UPDATE OF object_version_number NOWAIT;

Line: 1036


    SELECT object_version_number
      FROM OKC_NUMBER_SCHEME_DTLS
     WHERE NUM_SCHEME_ID = cp_num_scheme_id AND NUM_SEQUENCE_CODE = cp_num_sequence_code AND SEQUENCE_LEVEL = cp_sequence_level;

Line: 1091


        Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

Line: 1095


        Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1241


  FUNCTION Update_Row(
    p_num_scheme_id         IN NUMBER,
    p_num_sequence_code     IN VARCHAR2,
    p_sequence_level        IN NUMBER,
    p_concatenation_yn      IN VARCHAR2,
    p_end_character         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: 1261


            G_PKG_NAME, '6400: Entered Update_Row' );

Line: 1264


    UPDATE OKC_NUMBER_SCHEME_DTLS
     SET CONCATENATION_YN      = p_concatenation_yn,
         END_CHARACTER         = p_end_character,
         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 AND NUM_SEQUENCE_CODE     = p_num_sequence_code AND SEQUENCE_LEVEL        = p_sequence_level;

Line: 1274


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

Line: 1279


            G_PKG_NAME, '6500: Leaving Update_Row' );

Line: 1288


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

Line: 1293


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

Line: 1305


  END Update_Row;

Line: 1310


  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_num_sequence_code     IN VARCHAR2,
    p_sequence_level        IN NUMBER,
    p_concatenation_yn      IN VARCHAR2 := NULL,
    p_end_character         IN VARCHAR2 := NULL,

    p_object_version_number IN NUMBER

   ) IS

    l_concatenation_yn      OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;

Line: 1328


    l_last_updated_by       OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

Line: 1329


    l_last_update_login     OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

Line: 1330


    l_last_update_date      OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

Line: 1335


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

Line: 1341


            G_PKG_NAME, '7000: Entered Update_Row');

Line: 1420


    l_last_update_date := SYSDATE;

Line: 1421


    l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 1422


    l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1441


    x_return_status := Update_Row(
      p_num_scheme_id         => p_num_scheme_id,
      p_num_sequence_code     => p_num_sequence_code,
      p_sequence_level        => p_sequence_level,
      p_concatenation_yn      => l_concatenation_yn,
      p_end_character         => l_end_character,
      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: 1460


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

Line: 1465


            G_PKG_NAME, '7800: Leaving Update_Row');

Line: 1471


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

Line: 1476


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

Line: 1482


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

Line: 1487


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

Line: 1493


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

Line: 1498


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

Line: 1508


  END Update_Row;

Line: 1516


  FUNCTION Delete_Row(
    p_num_scheme_id         IN NUMBER,
    p_num_sequence_code     IN VARCHAR2,
    p_sequence_level        IN NUMBER
  ) RETURN VARCHAR2 IS

  BEGIN

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

Line: 1530


            G_PKG_NAME, '8200: Entered Delete_Row' );

Line: 1533


    DELETE FROM OKC_NUMBER_SCHEME_DTLS
      WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID AND NUM_SEQUENCE_CODE = p_NUM_SEQUENCE_CODE AND SEQUENCE_LEVEL = p_SEQUENCE_LEVEL;

Line: 1537


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

Line: 1542


            G_PKG_NAME, '8300: Leaving Delete_Row' );

Line: 1551


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

Line: 1556


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

Line: 1568


  END Delete_Row;

Line: 1573


  PROCEDURE Delete_Row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_num_scheme_id         IN NUMBER,
    p_num_sequence_code     IN VARCHAR2,
    p_sequence_level        IN NUMBER,
    p_object_version_number IN NUMBER
  ) IS
  BEGIN

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

Line: 1589


            G_PKG_NAME, '8800: Entered Delete_Row');

Line: 1615


    x_return_status := Delete_Row( p_num_scheme_id => p_num_scheme_id,p_num_sequence_code => p_num_sequence_code,p_sequence_level => p_sequence_level );

Line: 1623


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

Line: 1628


            G_PKG_NAME, '9300: Leaving Delete_Row' );

Line: 1634


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

Line: 1639


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

Line: 1645


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

Line: 1650


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

Line: 1656


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

Line: 1661


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

Line: 1672


  END Delete_Row;

Line: 1674


  PROCEDURE delete_set(
    x_return_status                OUT NOCOPY VARCHAR2,

    p_num_scheme_id         IN NUMBER
  ) IS
    CURSOR lock_csr IS
    SELECT rowid
      FROM OKC_NUMBER_SCHEME_DTLS
     WHERE NUM_SCHEME_ID = p_num_scheme_id
    FOR UPDATE NOWAIT;

Line: 1687


       Okc_Debug.Log('9700: Entered Delete_Set', 2);

Line: 1693


            G_PKG_NAME, '9700: Entered Delete_Set');

Line: 1711


    DELETE FROM OKC_NUMBER_SCHEME_DTLS
      WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID ;

Line: 1715


       Okc_Debug.Log('10000: Leaving Delete_set', 2);

Line: 1720


            G_PKG_NAME, '10000: Leaving Delete_set' );

Line: 1725


         Okc_Debug.Log('11000: Leaving Delete_set:E_Resource_Busy Exception', 2);

Line: 1730


     	      G_PKG_NAME, '11000: Leaving Delete_set:E_Resource_Busy Exception' );

Line: 1741


         Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);

Line: 1746


     	      G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );

Line: 1752


         Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

Line: 1757


     	      G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

Line: 1763


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

Line: 1768


     	      G_PKG_NAME, '11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm );

Line: 1779


  END Delete_Set;