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_TAG_PVT SQL Statements

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

Line: 26


    INSERT INTO OKC_REPORT_TAG_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        MEANING,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.MEANING,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKC_REPORT_TAG_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKC_REPORT_TAG_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 110


    select '!'
    from OKC_REPORT_TAG_V
    where xsl_id = n1 and code = c2
    and id <> n3;

Line: 162


    select '!'
    from OKC_REPORT_TAG_V
    where xsl_id = n1 and meaning = c2
    and id <> n3;

Line: 258


    SELECT '!' FROM OKC_REPORT_XSL_B
    WHERE ID = p FOR UPDATE OF LAST_UPDATE_DATE;

Line: 266


    update okc_report_xsl_b set LAST_UPDATE_DATE = sysdate
    where id = p_xsl_id;

Line: 277


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tagv_rec                     IN tagv_rec_type,
    x_tagv_rec                     OUT NOCOPY tagv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 287


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

Line: 314


    l_tagv_rec.LAST_UPDATED_BY 		:= FND_GLOBAL.USER_ID;

Line: 315


    l_tagv_rec.LAST_UPDATE_DATE 	:= SYSDATE;

Line: 316


    l_tagv_rec.LAST_UPDATE_LOGIN 	:= FND_GLOBAL.LOGIN_ID;

Line: 325


    insert into OKC_REPORT_TAG_B
    (
	 ID
	 ,XSL_ID
	 ,CODE
	 ,ENABLED_FLAG
	 ,OBJECT_VERSION_NUMBER
	 ,CREATED_BY
	 ,CREATION_DATE
	 ,LAST_UPDATED_BY
	 ,LAST_UPDATE_DATE
	 ,LAST_UPDATE_LOGIN
    ) values
    (
	 l_tagv_rec.ID
	 ,l_tagv_rec.XSL_ID
	 ,l_tagv_rec.CODE
	 ,l_tagv_rec.ENABLED_FLAG
	 ,l_tagv_rec.OBJECT_VERSION_NUMBER
	 ,l_tagv_rec.CREATED_BY
	 ,l_tagv_rec.CREATION_DATE
	 ,l_tagv_rec.LAST_UPDATED_BY
	 ,l_tagv_rec.LAST_UPDATE_DATE
	 ,l_tagv_rec.LAST_UPDATE_LOGIN
    );

Line: 351


    INSERT INTO OKC_REPORT_TAG_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        MEANING,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
  	    l_tagv_rec.ID,
            L.LANGUAGE_CODE,
            USERENV('LANG'),
            decode(L.LANGUAGE_CODE,USERENV('LANG'),'N','Y'),
  	    l_tagv_rec.MEANING,
 	    l_tagv_rec.CREATED_BY,
	    l_tagv_rec.CREATION_DATE,
	    l_tagv_rec.LAST_UPDATED_BY,
	    l_tagv_rec.LAST_UPDATE_DATE,
	    l_tagv_rec.LAST_UPDATE_LOGIN
        FROM FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
     ;

Line: 410


  END insert_row;

Line: 427


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_REPORT_TAG_V
     WHERE ID = p_tagv_rec.id
       AND OBJECT_VERSION_NUMBER =
         decode(p_tagv_rec.object_version_number,NULL,OBJECT_VERSION_NUMBER,
			OKC_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,p_tagv_rec.object_version_number)
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 436


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_REPORT_TAG_B
    WHERE ID = p_tagv_rec.id;

Line: 480


        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 526


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tagv_rec                     IN tagv_rec_type,
    x_tagv_rec                     OUT NOCOPY tagv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 536


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

Line: 567


    select
	 XSL_ID
	,CODE
	,MEANING
	,ENABLED_FLAG
	,OBJECT_VERSION_NUMBER+1
        ,created_by
        ,creation_date
    into
	 l_tagv_rec.XSL_ID
	,l_tagv_rec.CODE
	,l_tagv_rec.MEANING
	,l_tagv_rec.ENABLED_FLAG
	,l_tagv_rec.OBJECT_VERSION_NUMBER
        ,l_tagv_rec.created_by
        ,l_tagv_rec.creation_date
    from OKC_REPORT_TAG_V
    where ID = l_tagv_rec.ID;

Line: 586


    l_tagv_rec.LAST_UPDATED_BY 		:= FND_GLOBAL.USER_ID;

Line: 587


    l_tagv_rec.LAST_UPDATE_DATE 	:= SYSDATE;

Line: 588


    l_tagv_rec.LAST_UPDATE_LOGIN 	:= FND_GLOBAL.LOGIN_ID;

Line: 611


    UPDATE OKC_REPORT_TAG_B set
	 XSL_ID = l_tagv_rec.XSL_ID
	 ,CODE = l_tagv_rec.CODE
	 ,ENABLED_FLAG = l_tagv_rec.ENABLED_FLAG
	 ,OBJECT_VERSION_NUMBER = l_tagv_rec.OBJECT_VERSION_NUMBER
	 ,LAST_UPDATED_BY = l_tagv_rec.LAST_UPDATED_BY
	 ,LAST_UPDATE_DATE = l_tagv_rec.LAST_UPDATE_DATE
	 ,LAST_UPDATE_LOGIN = l_tagv_rec.LAST_UPDATE_LOGIN
    where ID = l_tagv_rec.ID;

Line: 621


    UPDATE OKC_REPORT_TAG_TL set
	 SOURCE_LANG = USERENV('LANG')
         ,SFWT_FLAG = decode(LANGUAGE,USERENV('LANG'),'N','Y')
         ,MEANING = l_tagv_rec.MEANING
	 ,LAST_UPDATED_BY = l_tagv_rec.LAST_UPDATED_BY
	 ,LAST_UPDATE_DATE = l_tagv_rec.LAST_UPDATE_DATE
	 ,LAST_UPDATE_LOGIN = l_tagv_rec.LAST_UPDATE_LOGIN
    where ID = l_tagv_rec.ID
      and USERENV('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 665


  END update_row;

Line: 671


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tagv_rec                     IN tagv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 680


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

Line: 684


    select S.id
    from okc_report_tag_v TAG, okc_report_xsl_v S
    where TAG.id = p and S.id = TAG.xsl_id;

Line: 716


    delete
    from OKC_REPORT_TAG_B
    where ID = p_tagv_rec.ID;

Line: 720


    delete
    from OKC_REPORT_TAG_TL
    where ID = p_tagv_rec.ID;

Line: 763


  END delete_row;