DBA Data[Home] [Help]

APPS.BIS_OBJECT_EXTENSIONS_PVT SQL Statements

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

Line: 18

REM |             Name and Description should not be updated, if the values |
REM |             are BIS_COMMON_UTILS.G_DEF_CHAR                           |
REM |       19-MAY-2005  visuri   GSCC Issues bug 4363854                   |
REM |       24-Aug-2005  hengliu  bug#4572274: issue in loading seed data   |
REM +=======================================================================+
*/

G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_OBJECT_EXTENSIONS_PVT';
Line: 65

    INSERT INTO BIS_FORM_FUNCTION_EXTENSION
    (
          OBJECT_TYPE
        , OBJECT_NAME
        , APPLICATION_ID
        , FUNCTIONAL_AREA_ID
        , CREATED_BY
        , CREATION_DATE
        , LAST_UPDATED_BY
        , LAST_UPDATE_DATE
        , LAST_UPDATE_LOGIN
    )
    VALUES
    (
        l_Form_Func_Extn_Rec.Object_Type
      , TRIM(l_Form_Func_Extn_Rec.Object_Name)
      , l_Form_Func_Extn_Rec.Application_Id
      , l_Form_Func_Extn_Rec.Func_Area_Id
      , NVL(l_Form_Func_Extn_Rec.Created_By,FND_GLOBAL.USER_ID)
      , NVL(l_Form_Func_Extn_Rec.Last_Update_Date,SYSDATE)
      , NVL(l_Form_Func_Extn_Rec.Last_Updated_By,FND_GLOBAL.USER_ID)
      , NVL(l_Form_Func_Extn_Rec.Last_Update_Date,SYSDATE)
      , NVL(l_Form_Func_Extn_Rec.Last_Update_Login,FND_GLOBAL.LOGIN_ID)
    );
Line: 90

    INSERT INTO BIS_FORM_FUNCTION_EXTENSION_TL
    (
          OBJECT_NAME
        , NAME
        , DESCRIPTION
        , LANGUAGE
        , SOURCE_LANG
        , CREATED_BY
        , CREATION_DATE
        , LAST_UPDATED_BY
        , LAST_UPDATE_DATE
        , LAST_UPDATE_LOGIN
    )
    SELECT
        l_Form_Func_Extn_Rec.Object_Name
      , l_Form_Func_Extn_Rec.Name
      , l_Form_Func_Extn_Rec.Description
      , L.LANGUAGE_CODE
      , USERENV('LANG')
      , NVL(l_Form_Func_Extn_Rec.Created_By,FND_GLOBAL.USER_ID)
      , NVL(l_Form_Func_Extn_Rec.Last_Update_Date,SYSDATE)
      , NVL(l_Form_Func_Extn_Rec.Last_Updated_By,FND_GLOBAL.USER_ID)
      , NVL(l_Form_Func_Extn_Rec.Last_Update_Date,SYSDATE)
      , NVL(l_Form_Func_Extn_Rec.Last_Update_Login,FND_GLOBAL.LOGIN_ID)
    FROM FND_LANGUAGES L
    WHERE L.INSTALLED_FLAG IN ('I', 'B')
    AND NOT EXISTS
        (
          SELECT NULL
          FROM   BIS_FORM_FUNCTION_EXTENSION_TL T
          WHERE  T.OBJECT_NAME = l_Form_Func_Extn_Rec.Object_Name
          AND    T.LANGUAGE    = L.LANGUAGE_CODE
        );
Line: 170

        FUNCTION Name :- Update_Form_Func_Extension
        PARAMETERS    :-
            p_Form_Func_Extn_Rec :- The Details of form function sent from UI for update
        DESCRIPTION   :- This basically updates the properties for form functions
                         This can be called from UI also
        AUTHOR        :- KRISHNA
*********************************************************************************************/
PROCEDURE Update_Form_Func_Extension(
  p_Api_Version         IN          NUMBER
 ,p_Commit              IN          VARCHAR2
 ,p_Form_Func_Extn_Rec  IN          BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
 ,x_Return_Status       OUT NOCOPY  VARCHAR2
 ,x_Msg_Count           OUT NOCOPY  NUMBER
 ,x_Msg_Data            OUT NOCOPY  VARCHAR2
)IS
    l_Commit                VARCHAR2(30);
Line: 188

    SAVEPOINT  UpdateFormFuncSP;
Line: 215

    IF(p_Form_Func_Extn_Rec.Last_Update_Date IS NULL) THEN
        l_Form_Func_Extn_Rec.Last_Update_Date := SYSDATE;
Line: 218

        l_Form_Func_Extn_Rec.Last_Update_Date := p_Form_Func_Extn_Rec.Last_Update_Date;
Line: 221

    IF (p_Form_Func_Extn_Rec.Last_Updated_By IS NULL) THEN
      l_Form_Func_Extn_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;
Line: 224

      l_Form_Func_Extn_Rec.Last_Updated_By := p_Form_Func_Extn_Rec.Last_Updated_By;
Line: 227

    IF (p_Form_Func_Extn_Rec.Last_Update_Login IS NULL) THEN
      l_Form_Func_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
Line: 230

      l_Form_Func_Extn_Rec.Last_Update_Login := p_Form_Func_Extn_Rec.Last_Update_Login;
Line: 233

    UPDATE BIS_FORM_FUNCTION_EXTENSION
    SET
        APPLICATION_ID     = l_Form_Func_Extn_Rec.Application_id
      , FUNCTIONAL_AREA_ID = l_Form_Func_Extn_Rec.Func_Area_Id
      , LAST_UPDATED_BY    = l_Form_Func_Extn_Rec.Last_Updated_By
      , LAST_UPDATE_DATE   = l_Form_Func_Extn_Rec.Last_Update_Date
      , LAST_UPDATE_LOGIN  = l_Form_Func_Extn_Rec.Last_Update_Login
    WHERE OBJECT_NAME      = l_Form_Func_Extn_Rec.Object_Name;
Line: 260

        ROLLBACK TO UpdateFormFuncSP;
Line: 270

        ROLLBACK TO UpdateFormFuncSP;
Line: 280

        ROLLBACK TO UpdateFormFuncSP;
Line: 283

            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
Line: 285

            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
Line: 288

        ROLLBACK TO UpdateFormFuncSP;
Line: 291

            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
Line: 293

            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
Line: 295

END Update_Form_Func_Extension;
Line: 301

        DESCRIPTION   :- This basically updates the properties for form functions
                         This can be called from UI directly also
        AUTHOR        :- KRISHNA
*********************************************************************************************/

PROCEDURE Translate_Form_Func_Extension(
  p_Api_Version         IN          NUMBER
 ,p_Commit              IN          VARCHAR2
 ,p_Form_Func_Extn_Rec  IN          BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
 ,x_Return_Status       OUT NOCOPY  VARCHAR2
 ,x_Msg_Count           OUT NOCOPY  NUMBER
 ,x_Msg_Data            OUT NOCOPY  VARCHAR2
)IS
    l_Commit                VARCHAR2(30);
Line: 354

    IF(p_Form_Func_Extn_Rec.Last_Update_Date IS NULL) THEN
        l_Form_Func_Extn_Rec.Last_Update_Date := SYSDATE;
Line: 357

        l_Form_Func_Extn_Rec.Last_Update_Date := p_Form_Func_Extn_Rec.Last_Update_Date;
Line: 360

    IF (p_Form_Func_Extn_Rec.Last_Updated_By IS NULL) THEN
      l_Form_Func_Extn_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;
Line: 363

      l_Form_Func_Extn_Rec.Last_Updated_By := p_Form_Func_Extn_Rec.Last_Updated_By;
Line: 366

    IF (p_Form_Func_Extn_Rec.Last_Update_Login IS NULL) THEN
      l_Form_Func_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
Line: 369

      l_Form_Func_Extn_Rec.Last_Update_Login := p_Form_Func_Extn_Rec.Last_Update_Login;
Line: 372

    UPDATE BIS_FORM_FUNCTION_EXTENSION_TL
    SET
        NAME               = l_Form_Func_Extn_Rec.Name
      , DESCRIPTION        = l_Form_Func_Extn_Rec.Description
      , LAST_UPDATED_BY    = l_Form_Func_Extn_Rec.Last_Updated_By
      , LAST_UPDATE_DATE   = l_Form_Func_Extn_Rec.Last_Update_Date
      , LAST_UPDATE_LOGIN  = l_Form_Func_Extn_Rec.Last_Update_Login
      , SOURCE_LANG        = USERENV('LANG')
    WHERE OBJECT_NAME      = l_Form_Func_Extn_Rec.Object_Name
    AND USERENV('LANG')      IN (LANGUAGE, SOURCE_LANG);
Line: 449

    SELECT  F.OBJECT_TYPE
           ,F.OBJECT_NAME
           ,F.NAME
           ,F.DESCRIPTION
           ,F.APPLICATION_ID
           ,F.FUNCTIONAL_AREA_ID
           ,F.CREATED_BY
           ,F.CREATION_DATE
           ,F.LAST_UPDATED_BY
           ,F.LAST_UPDATE_DATE
           ,F.LAST_UPDATE_LOGIN
    INTO    x_Form_Func_Extn_Rec.Object_Type
           ,x_Form_Func_Extn_Rec.Object_Name
           ,x_Form_Func_Extn_Rec.Name
           ,x_Form_Func_Extn_Rec.Description
           ,x_Form_Func_Extn_Rec.Application_Id
           ,x_Form_Func_Extn_Rec.Func_Area_Id
           ,x_Form_Func_Extn_Rec.Created_By
           ,x_Form_Func_Extn_Rec.Creation_Date
           ,x_Form_Func_Extn_Rec.Last_Updated_By
           ,x_Form_Func_Extn_Rec.Last_Update_Date
           ,x_Form_Func_Extn_Rec.Last_Update_Login
    FROM   BIS_FORM_FUNCTION_EXTENSION_VL F
    WHERE  F.OBJECT_NAME = trim(p_Form_Func_Extn_Rec.Object_Name);
Line: 513

            DESCRIPTION   :- This delete the record in BIS_FORM_FUNCTION_EXTENSION table
        AUTHOR        :- KRISHNA
*********************************************************************************************/
PROCEDURE Delete_Form_Func_Extension(
    p_Api_Version         IN          NUMBER
 ,  p_Commit              IN          VARCHAR2
 ,  p_Form_Func_Extn_Rec  IN          BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
 ,  x_Return_Status       OUT NOCOPY  VARCHAR2
 ,  x_Msg_Count           OUT NOCOPY  NUMBER
 ,  x_Msg_Data            OUT NOCOPY  VARCHAR2
)IS
BEGIN
    SAVEPOINT  DeleteFormFuncSP_Pvt;
Line: 529

    DELETE FROM  BIS_FORM_FUNCTION_EXTENSION
    WHERE  OBJECT_NAME =   TRIM(p_Form_Func_Extn_Rec.Object_Name);
Line: 532

    DELETE FROM  BIS_FORM_FUNCTION_EXTENSION_TL
    WHERE  OBJECT_NAME =   TRIM(p_Form_Func_Extn_Rec.Object_Name);
Line: 541

        ROLLBACK TO DeleteFormFuncSP_Pvt;
Line: 551

        ROLLBACK TO DeleteFormFuncSP_Pvt;
Line: 561

        ROLLBACK TO DeleteFormFuncSP_Pvt;
Line: 564

            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
Line: 566

            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
Line: 569

        ROLLBACK TO DeleteFormFuncSP_Pvt;
Line: 572

            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
Line: 574

            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
Line: 576

END Delete_Form_Func_Extension;
Line: 613

    INSERT INTO BIS_MEASURES_EXTENSION
    (
       MEASURE_SHORT_NAME
      ,FUNCTIONAL_AREA_ID
      ,CREATED_BY
      ,CREATION_DATE
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_DATE
      ,LAST_UPDATE_LOGIN
    )
    VALUES
    (
       TRIM(l_Meas_Extn_Rec.Measure_Short_Name)
      ,l_Meas_Extn_Rec.Functional_Area_Id
      ,NVL(l_Meas_Extn_Rec.Created_By, FND_GLOBAL.USER_ID)
      ,NVL(l_Meas_Extn_Rec.Last_Update_Date,SYSDATE)
      ,NVL(l_Meas_Extn_Rec.Created_By, FND_GLOBAL.USER_ID)
      ,NVL(l_Meas_Extn_Rec.Last_Update_Date,SYSDATE)
      ,NVL(l_Meas_Extn_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
    );
Line: 634

    INSERT INTO BIS_MEASURES_EXTENSION_TL
    (
       MEASURE_SHORT_NAME
      ,NAME
      ,DESCRIPTION
      ,LANGUAGE
      ,SOURCE_LANG
      ,CREATED_BY
      ,CREATION_DATE
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_DATE
      ,LAST_UPDATE_LOGIN
    )
    SELECT
       l_Meas_Extn_Rec.Measure_Short_Name
      ,l_Meas_Extn_Rec.Name
      ,l_Meas_Extn_Rec.Description
      ,L.LANGUAGE_CODE
      ,USERENV('LANG')
      ,NVL(l_Meas_Extn_Rec.Created_By, FND_GLOBAL.USER_ID)
      ,NVL(l_Meas_Extn_Rec.Last_Update_Date,SYSDATE)
      ,NVL(l_Meas_Extn_Rec.Created_By, FND_GLOBAL.USER_ID)
      ,NVL(l_Meas_Extn_Rec.Last_Update_Date,SYSDATE)
      ,NVL(l_Meas_Extn_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
    FROM FND_LANGUAGES L
    WHERE L.INSTALLED_FLAG IN ('I', 'B')
    AND NOT EXISTS
        (
          SELECT NULL
          FROM   BIS_MEASURES_EXTENSION_TL T
          WHERE  T.MEASURE_SHORT_NAME = l_Meas_Extn_Rec.Measure_Short_Name
          AND    T.LANGUAGE           = L.LANGUAGE_CODE
        );
Line: 724

     SELECT  B.MEASURE_SHORT_NAME
            ,B.NAME
            ,B.DESCRIPTION
            ,B.FUNCTIONAL_AREA_ID
            ,B.CREATED_BY
            ,B.CREATION_DATE
            ,B.LAST_UPDATED_BY
            ,B.LAST_UPDATE_DATE
            ,B.LAST_UPDATE_LOGIN
     FROM   BIS_MEASURES_EXTENSION_VL B
     WHERE  B.MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);
Line: 749

        x_Meas_Extn_Rec.Last_Updated_By    := cME.LAST_UPDATED_BY;
Line: 750

        x_Meas_Extn_Rec.Last_Update_Date   := cME.LAST_UPDATE_DATE;
Line: 751

        x_Meas_Extn_Rec.Last_Update_Login  := cME.LAST_UPDATE_LOGIN;
Line: 842

    IF(p_Meas_Extn_Rec.Last_Update_Date IS NULL ) THEN
        l_Meas_Extn_Rec.Last_Update_Date := SYSDATE;
Line: 845

        l_Meas_Extn_Rec.Last_Update_Date := p_Meas_Extn_Rec.Last_Update_Date;
Line: 848

    IF (p_Meas_Extn_Rec.Last_Updated_By IS NULL) THEN
      l_Meas_Extn_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;
Line: 851

      l_Meas_Extn_Rec.Last_Updated_By := p_Meas_Extn_Rec.Last_Updated_By;
Line: 854

    IF (p_Meas_Extn_Rec.Last_Update_Login IS NULL) THEN
      l_Meas_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
Line: 857

      l_Meas_Extn_Rec.Last_Update_Login := p_Meas_Extn_Rec.Last_Update_Login;
Line: 861

    UPDATE BIS_MEASURES_EXTENSION_TL B
    SET
        B.NAME               = l_Meas_Extn_Rec.Name
      , B.DESCRIPTION        = l_Meas_Extn_Rec.Description
      , B.LAST_UPDATED_BY    = l_Meas_Extn_Rec.Last_Updated_By
      , B.LAST_UPDATE_DATE   = l_Meas_Extn_Rec.Last_Update_Date
      , B.LAST_UPDATE_LOGIN  = l_Meas_Extn_Rec.Last_Update_Login
      , B.SOURCE_LANG        = USERENV('LANG')
    WHERE
        B.MEASURE_SHORT_NAME = l_Meas_Extn_Rec.Measure_Short_Name
    AND USERENV('LANG')    IN (B.LANGUAGE, B.SOURCE_LANG);
Line: 919

PROCEDURE Update_Measure_Extension(
  p_Api_Version         IN          NUMBER
 ,p_Commit              IN          VARCHAR2
 ,p_Meas_Extn_Rec       IN          BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
 ,x_Return_Status       OUT NOCOPY  VARCHAR2
 ,x_Msg_Count           OUT NOCOPY  NUMBER
 ,x_Msg_Data            OUT NOCOPY  VARCHAR2
) IS
    l_Meas_Extn_Rec   BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
Line: 930

    SAVEPOINT UpdateMeasExtnSP;
Line: 955

    IF(p_Meas_Extn_Rec.Last_Update_Date IS NULL ) THEN
        l_Meas_Extn_Rec.Last_Update_Date := SYSDATE;
Line: 958

        l_Meas_Extn_Rec.Last_Update_Date := p_Meas_Extn_Rec.Last_Update_Date;
Line: 961

    IF (p_Meas_Extn_Rec.Last_Updated_By IS NULL) THEN
      l_Meas_Extn_Rec.Last_Updated_By := FND_GLOBAL.USER_ID;
Line: 964

      l_Meas_Extn_Rec.Last_Updated_By := p_Meas_Extn_Rec.Last_Updated_By;
Line: 967

    IF (p_Meas_Extn_Rec.Last_Update_Login IS NULL) THEN
      l_Meas_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
Line: 970

      l_Meas_Extn_Rec.Last_Update_Login := p_Meas_Extn_Rec.Last_Update_Login;
Line: 973

    UPDATE BIS_MEASURES_EXTENSION
    SET
        FUNCTIONAL_AREA_ID = l_Meas_Extn_Rec.Functional_Area_Id
      , LAST_UPDATED_BY    = l_Meas_Extn_Rec.Last_Updated_By
      , LAST_UPDATE_DATE   = l_Meas_Extn_Rec.Last_Update_Date
      , LAST_UPDATE_LOGIN  = l_Meas_Extn_Rec.Last_Update_Login
    WHERE
        MEASURE_SHORT_NAME = l_Meas_Extn_Rec.Measure_Short_Name;
Line: 1000

        ROLLBACK TO UpdateMeasExtnSP;
Line: 1010

        ROLLBACK TO UpdateMeasExtnSP;
Line: 1020

        ROLLBACK TO UpdateMeasExtnSP;
Line: 1023

            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
Line: 1025

            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
Line: 1028

        ROLLBACK TO UpdateMeasExtnSP;
Line: 1031

            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
Line: 1033

            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
Line: 1035

END Update_Measure_Extension;
Line: 1040

            DESCRIPTION   :- This delete the record in BIS_MEASURES_EXTENSION table
        AUTHOR        :- KRISHNA
*********************************************************************************************/
PROCEDURE Delete_Measure_Extension(
  p_Api_Version         IN          NUMBER
 ,p_Commit              IN          VARCHAR2
 ,p_Meas_Extn_Rec       IN          BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
 ,x_Return_Status       OUT NOCOPY  VARCHAR2
 ,x_Msg_Count           OUT NOCOPY  NUMBER
 ,x_Msg_Data            OUT NOCOPY  VARCHAR2
) IS

BEGIN
    SAVEPOINT DeleteMeasExtnSP;
Line: 1057

    DELETE FROM BIS_MEASURES_EXTENSION
    WHERE MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);
Line: 1060

    DELETE FROM BIS_MEASURES_EXTENSION_TL
    WHERE MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);
Line: 1071

        ROLLBACK TO DeleteMeasExtnSP;
Line: 1081

        ROLLBACK TO DeleteMeasExtnSP;
Line: 1091

        ROLLBACK TO DeleteMeasExtnSP;
Line: 1094

            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
Line: 1096

            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
Line: 1099

        ROLLBACK TO DeleteMeasExtnSP;
Line: 1102

            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
Line: 1104

            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
Line: 1107

END Delete_Measure_Extension;
Line: 1115

  SELECT FUNCTIONAL_AREA_ID
  INTO   l_FA_Id
  FROM   BIS_FUNCTIONAL_AREAS
  WHERE  UPPER(SHORT_NAME) = UPPER(Trim(p_Functional_Area_Short_Name));
Line: 1134

        DELETE FROM BIS_MEASURES_EXTENSION_TL T
        WHERE NOT EXISTS
        (
          SELECT NULL
          FROM   BIS_MEASURES_EXTENSION B
          WHERE  B.MEASURE_SHORT_NAME = T.MEASURE_SHORT_NAME
        );
Line: 1142

        UPDATE BIS_MEASURES_EXTENSION_TL T SET (
            NAME,
            DESCRIPTION
        ) = (SELECT
                B.NAME,
                B.DESCRIPTION
             FROM  BIS_MEASURES_EXTENSION_TL B
             WHERE B.MEASURE_SHORT_NAME = T.MEASURE_SHORT_NAME
             AND   B.LANGUAGE           = T.SOURCE_LANG)
             WHERE (
                T.MEASURE_SHORT_NAME,
                T.LANGUAGE
             ) IN (SELECT
                    SUBT.MEASURE_SHORT_NAME,
                    SUBT.LANGUAGE
                    FROM  BIS_MEASURES_EXTENSION_TL SUBB, BIS_MEASURES_EXTENSION_TL SUBT
                    WHERE SUBB.MEASURE_SHORT_NAME = SUBT.MEASURE_SHORT_NAME
                    AND   SUBB.LANGUAGE           = SUBT.SOURCE_LANG
                    AND (
                         SUBB.NAME              <> SUBT.NAME
                         OR SUBB.DESCRIPTION    <> SUBT.DESCRIPTION
                        )
                    );
Line: 1166

        INSERT INTO BIS_MEASURES_EXTENSION_TL
        (
           MEASURE_SHORT_NAME
          ,NAME
          ,DESCRIPTION
          ,LANGUAGE
          ,SOURCE_LANG
          ,CREATED_BY
          ,CREATION_DATE
          ,LAST_UPDATED_BY
          ,LAST_UPDATE_DATE
          ,LAST_UPDATE_LOGIN
        )
        SELECT
            B.MEASURE_SHORT_NAME
          , B.NAME
          , B.DESCRIPTION
          , L.LANGUAGE_CODE
          , B.SOURCE_LANG
          , B.CREATED_BY
          , B.CREATION_DATE
          , B.LAST_UPDATED_BY
          , B.LAST_UPDATE_DATE
          , B.LAST_UPDATE_LOGIN
       FROM  BIS_MEASURES_EXTENSION_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
       AND   B.LANGUAGE = USERENV('LANG')
       AND   NOT EXISTS
            (
              SELECT NULL
              FROM   BIS_MEASURES_EXTENSION_TL T
              WHERE  UPPER(T.MEASURE_SHORT_NAME) = UPPER(B.MEASURE_SHORT_NAME)
              AND    T.LANGUAGE           = L.LANGUAGE_CODE
            );
Line: 1208

        DELETE FROM BIS_FORM_FUNCTION_EXTENSION_TL T
        WHERE NOT EXISTS
        (
          SELECT NULL
          FROM   BIS_FORM_FUNCTION_EXTENSION B
          WHERE  B.OBJECT_NAME = T.OBJECT_NAME
        );
Line: 1216

        UPDATE BIS_FORM_FUNCTION_EXTENSION_TL T SET (
            NAME,
            DESCRIPTION
        ) = (SELECT
                B.NAME,
                B.DESCRIPTION
             FROM  BIS_FORM_FUNCTION_EXTENSION_TL B
             WHERE B.OBJECT_NAME  = T.OBJECT_NAME
             AND   B.LANGUAGE     = T.SOURCE_LANG)
             WHERE (
                T.OBJECT_NAME,
                T.LANGUAGE
             ) IN (SELECT
                    SUBT.OBJECT_NAME,
                    SUBT.LANGUAGE
                    FROM  BIS_FORM_FUNCTION_EXTENSION_TL SUBB, BIS_FORM_FUNCTION_EXTENSION_TL SUBT
                    WHERE SUBB.OBJECT_NAME = SUBT.OBJECT_NAME
                    AND   SUBB.LANGUAGE    = SUBT.SOURCE_LANG
                    AND (
                         SUBB.NAME              <> SUBT.NAME
                         OR SUBB.DESCRIPTION    <> SUBT.DESCRIPTION
                        )
                    );
Line: 1240

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