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_ARTICLE_ADOPTIONS_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_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;

Line: 116


    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_ADOPTIONS_pk_csr (cp_local_org_id IN NUMBER,cp_local_article_version_id IN NUMBER) IS
    SELECT
            GLOBAL_ARTICLE_VERSION_ID,
            ADOPTION_TYPE,
            ADOPTION_STATUS,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE
      FROM OKC_ARTICLE_ADOPTIONS t
     WHERE t.LOCAL_ORG_ID = cp_local_org_id and
           t.LOCAL_ARTICLE_VERSION_ID = cp_local_article_version_id;

Line: 137


    SELECT
            ADOPTION_TYPE,
            ADOPTION_STATUS,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE
      FROM OKC_ARTICLE_ADOPTIONS t
     WHERE t.GLOBAL_ARTICLE_VERSION_ID = cp_global_article_version_id and
           t.LOCAL_ORG_ID = cp_local_org_id and
           t.LOCAL_ARTICLE_VERSION_ID IS NULL;

Line: 167


            x_last_updated_by,
            x_last_update_login,
            x_last_update_date;

Line: 182


            x_last_updated_by,
            x_last_update_login,
            x_last_update_date;

Line: 240


    l_last_updated_by           OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

Line: 241


    l_last_update_login         OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

Line: 242


    l_last_update_date          OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

Line: 269


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


     SELECT '!'
      FROM  OKC_ARTICLE_VERSIONS
      WHERE ARTICLE_VERSION_ID = p_global_article_version_id
      AND   global_yn = 'Y';

Line: 353


     SELECT '!'
      FROM HR_ALL_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = p_local_org_id;

Line: 358


     SELECT '!'
      FROM OKC_ARTICLE_VERSIONS
      WHERE ARTICLE_VERSION_ID = p_local_article_version_id
      AND   global_yn = 'N';

Line: 640


      l_last_updated_by           OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

Line: 641


      l_last_update_login         OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

Line: 642


      l_last_update_date          OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

Line: 714


  FUNCTION Insert_Row(
    p_global_article_version_id IN NUMBER,
    p_adoption_type             IN VARCHAR2,
    p_local_org_id              IN NUMBER,
    p_local_article_version_id  IN NUMBER,
    p_adoption_status           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: 735


    INSERT INTO OKC_ARTICLE_ADOPTIONS(
        GLOBAL_ARTICLE_VERSION_ID,
        ADOPTION_TYPE,
        LOCAL_ORG_ID,
        LOCAL_ARTICLE_VERSION_ID,
        ADOPTION_STATUS,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE)
      VALUES (
        p_global_article_version_id,
        p_adoption_type,
        p_local_org_id,
        p_local_article_version_id,
        p_adoption_status,
        p_object_version_number,
        p_created_by,
        p_creation_date,
        p_last_updated_by,
        p_last_update_login,
        p_last_update_date);

Line: 761


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

Line: 770


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

Line: 782


  END Insert_Row;

Line: 788


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

    p_global_article_version_id IN NUMBER,
    p_adoption_type             IN VARCHAR2,
    p_local_org_id              IN NUMBER,
    p_local_article_version_id  IN NUMBER,
    p_adoption_status           IN VARCHAR2,



    x_global_article_version_id OUT NOCOPY NUMBER,
    x_local_org_id              OUT NOCOPY NUMBER,
    x_local_article_version_id  OUT NOCOPY NUMBER

  ) IS

    l_object_version_number     OKC_ARTICLE_ADOPTIONS.OBJECT_VERSION_NUMBER%TYPE;

Line: 809


    l_last_updated_by           OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

Line: 810


    l_last_update_login         OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

Line: 811


    l_last_update_date          OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

Line: 817


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

Line: 834


    l_last_update_date := l_creation_date;

Line: 835


    l_last_updated_by := l_created_by;

Line: 836


    l_last_update_login := Fnd_Global.Login_Id;

Line: 859


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

Line: 862


    x_return_status := Insert_Row(
      p_global_article_version_id => x_global_article_version_id,
      p_local_org_id              => x_local_org_id,
      p_local_article_version_id  => x_local_article_version_id,
      p_adoption_type             => p_adoption_type,
      p_adoption_status           => p_adoption_status,
      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: 884


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

Line: 890


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

Line: 896


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

Line: 902


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

Line: 912


  END Insert_Row;

Line: 930


    SELECT object_version_number
      FROM OKC_ARTICLE_ADOPTIONS
     WHERE LOCAL_ORG_ID = cp_local_org_id AND
      (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL) AND
      LOCAL_ARTICLE_VERSION_ID = cp_local_article_version_id
    FOR UPDATE OF object_version_number NOWAIT;

Line: 938


    SELECT object_version_number
      FROM OKC_ARTICLE_ADOPTIONS
     WHERE LOCAL_ORG_ID = cp_local_org_id AND
           LOCAL_ARTICLE_VERSION_ID = cp_local_article_version_id;

Line: 944


    SELECT object_version_number
      FROM OKC_ARTICLE_ADOPTIONS
     WHERE GLOBAL_ARTICLE_VERSION_ID = cp_global_article_version_id AND
      LOCAL_ORG_ID = cp_local_org_id AND
      (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL) AND
      LOCAL_ARTICLE_VERSION_ID IS NULL
    FOR UPDATE OF object_version_number NOWAIT;

Line: 953


    SELECT object_version_number
      FROM OKC_ARTICLE_ADOPTIONS
     WHERE GLOBAL_ARTICLE_VERSION_ID = cp_global_article_version_id AND LOCAL_ORG_ID = cp_local_org_id AND LOCAL_ARTICLE_VERSION_ID IS NULL;

Line: 998


               Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

Line: 1002


               Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1037


               Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);

Line: 1041


               Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1158


  FUNCTION Update_Row(
    p_global_article_version_id IN NUMBER,
    p_adoption_type             IN VARCHAR2,
    p_local_org_id              IN NUMBER,
    p_orig_local_version_id  IN NUMBER,
    p_new_local_version_id  IN NUMBER,
    p_adoption_status           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('6400: Entered Update_Row', 2);

Line: 1179


       UPDATE OKC_ARTICLE_ADOPTIONS
       SET ADOPTION_TYPE             = p_adoption_type,
         ADOPTION_STATUS           = p_adoption_status,
         LOCAL_ARTICLE_VERSION_ID  = p_new_local_version_id,
-- muteshev
         OBJECT_VERSION_NUMBER     = object_version_number+1,
         LAST_UPDATED_BY           = p_last_updated_by,
         LAST_UPDATE_LOGIN         = p_last_update_login,
         LAST_UPDATE_DATE          = p_last_update_date
       WHERE GLOBAL_ARTICLE_VERSION_ID = p_global_article_version_id AND
             LOCAL_ORG_ID              = p_local_org_id AND LOCAL_ARTICLE_VERSION_ID  = p_orig_local_version_id;

Line: 1191


       UPDATE OKC_ARTICLE_ADOPTIONS
       SET ADOPTION_TYPE             = p_adoption_type,
         ADOPTION_STATUS           = p_adoption_status,
         LOCAL_ARTICLE_VERSION_ID  = p_new_local_version_id,
-- muteshev
         OBJECT_VERSION_NUMBER     = object_version_number+1,
         LAST_UPDATED_BY           = p_last_updated_by,
         LAST_UPDATE_LOGIN         = p_last_update_login,
         LAST_UPDATE_DATE          = p_last_update_date
      WHERE GLOBAL_ARTICLE_VERSION_ID = p_global_article_version_id AND
         LOCAL_ORG_ID              = p_local_org_id AND
         LOCAL_ARTICLE_VERSION_ID  IS NULL;

Line: 1206


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

Line: 1215


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

Line: 1227


  END Update_Row;

Line: 1232


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

    x_return_status                OUT NOCOPY VARCHAR2,

    p_global_article_version_id IN NUMBER,
    p_adoption_type             IN VARCHAR2,
    p_local_org_id              IN NUMBER,
    p_orig_local_version_id  IN NUMBER,
    p_new_local_version_id  IN NUMBER,
    p_adoption_status           IN VARCHAR2,



    p_object_version_number     IN NUMBER

   ) IS

    l_global_article_version_id OKC_ARTICLE_ADOPTIONS.GLOBAL_ARTICLE_VERSION_ID%TYPE;

Line: 1256


    l_last_updated_by           OKC_ARTICLE_ADOPTIONS.LAST_UPDATED_BY%TYPE;

Line: 1257


    l_last_update_login         OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_LOGIN%TYPE;

Line: 1258


    l_last_update_date          OKC_ARTICLE_ADOPTIONS.LAST_UPDATE_DATE%TYPE;

Line: 1263


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

Line: 1325


    l_last_update_date := SYSDATE;

Line: 1326


    l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 1327


    l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1341


    x_return_status := Update_Row(
      p_global_article_version_id => l_global_article_version_id,
      p_local_org_id              => p_local_org_id,
      p_orig_local_version_id  => p_orig_local_version_id,
      p_new_local_version_id  => p_new_local_version_id,
      p_adoption_type             => l_adoption_type,
      p_adoption_status           => l_adoption_status,
      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: 1363


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

Line: 1369


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

Line: 1375


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

Line: 1381


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

Line: 1391


  END Update_Row;

Line: 1399


  FUNCTION Delete_Row(
    p_global_article_version_id IN NUMBER,
    p_local_org_id              IN NUMBER,
    p_local_article_version_id  IN NUMBER
  ) RETURN VARCHAR2 IS

  BEGIN

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

Line: 1411


    DELETE FROM OKC_ARTICLE_ADOPTIONS
      WHERE GLOBAL_ARTICLE_VERSION_ID = p_GLOBAL_ARTICLE_VERSION_ID AND LOCAL_ORG_ID = p_LOCAL_ORG_ID AND LOCAL_ARTICLE_VERSION_ID = p_LOCAL_ARTICLE_VERSION_ID;

Line: 1415


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

Line: 1424


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

Line: 1436


  END Delete_Row;

Line: 1441


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

Line: 1452


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

Line: 1472


    x_return_status := Delete_Row( p_global_article_version_id => p_global_article_version_id,p_local_org_id => p_local_org_id,p_local_article_version_id => p_local_article_version_id );

Line: 1481


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

Line: 1487


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

Line: 1493


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

Line: 1499


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

Line: 1509


  END Delete_Row;