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.BIS_OBJECT_EXTENSIONS_PUB SQL Statements

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

Line: 158


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


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


    SAVEPOINT  UpdateFormFuncPSP;

Line: 276


     ,  p_Action_Type         =>  BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE
     ,  x_Return_Status       =>  x_Return_Status
     ,  x_Msg_Count           =>  x_Msg_Count
     ,  x_Msg_Data            =>  x_Msg_Data
    );

Line: 285


    BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension(
        p_Api_Version         =>  p_Api_Version
     ,  p_Commit              =>  p_Commit
     ,  p_Form_Func_Extn_Rec  =>  p_Form_Func_Extn_Rec
     ,  x_Return_Status       =>  x_Return_Status
     ,  x_Msg_Count           =>  x_Msg_Count
     ,  x_Msg_Data            =>  x_Msg_Data
     );

Line: 303


        ROLLBACK TO UpdateFormFuncPSP;

Line: 313


        ROLLBACK TO UpdateFormFuncPSP;

Line: 323


        ROLLBACK TO UpdateFormFuncPSP;

Line: 326


            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';

Line: 328


            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';

Line: 331


        ROLLBACK TO UpdateFormFuncPSP;

Line: 334


            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';

Line: 336


            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';

Line: 338


END Update_Form_Func_Extension;

Line: 493


        IF (FND_LOAD_UTIL.UPLOAD_TEST(p_Form_Func_Extn_Rec.Last_Updated_By
                                    , p_Form_Func_Extn_Rec.Last_Update_Date
                                    , l_Form_Func_Extn_Rec.Last_Updated_By
                                    , l_Form_Func_Extn_Rec.Last_Update_Date
                                    , p_Custom_mode)) THEN
            l_Form_Func_Extn_Rec := p_Form_Func_Extn_Rec;

Line: 500


            BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension(
                p_Api_Version         =>  p_Api_Version
             ,  p_Commit              =>  p_Commit
             ,  p_Form_Func_Extn_Rec  =>  l_Form_Func_Extn_Rec
             ,  x_Return_Status       =>  x_Return_Status
             ,  x_Msg_Count           =>  x_Msg_Count
             ,  x_Msg_Data            =>  x_Msg_Data
            );

Line: 555


        FUNCTION Name :- Delete_Form_Func_Extension
        PARAMETERS    :-
            p_Form_Func_Extn_Rec :- The properites of Form function
        DESCRIPTION   :- This is the main function that is being called from ldt/UI
                         And this calls relevant APIs
        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
    l_Commit        VARCHAR2(30);

Line: 575


    SAVEPOINT  DeleteFormFuncPSP;

Line: 586


    ,   p_Action_Type         =>  BIS_OBJECT_EXTENSIONS_PUB.C_DELETE
    ,   x_Return_Status       =>  x_Return_Status
    ,   x_Msg_Count           =>  x_Msg_Count
    ,   x_Msg_Data            =>  x_Msg_Data
    );

Line: 595


    BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension(
        p_Api_Version         =>  p_Api_Version
     ,  p_Commit              =>  p_Commit
     ,  p_Form_Func_Extn_Rec  =>  p_Form_Func_Extn_Rec
     ,  x_Return_Status       =>  x_Return_Status
     ,  x_Msg_Count           =>  x_Msg_Count
     ,  x_Msg_Data            =>  x_Msg_Data
    );

Line: 613


        ROLLBACK TO DeleteFormFuncPSP;

Line: 623


        ROLLBACK TO DeleteFormFuncPSP;

Line: 633


        ROLLBACK TO DeleteFormFuncPSP;

Line: 636


            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';

Line: 638


            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';

Line: 641


        ROLLBACK TO DeleteFormFuncPSP;

Line: 644


            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';

Line: 646


            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';

Line: 648


END Delete_Form_Func_Extension;

Line: 888


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

BEGIN
    SAVEPOINT UpdateMeasExtnPSP;

Line: 905


     ,p_Action_Type    => BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE
     ,x_Return_Status  => x_Return_Status
     ,x_Msg_Count      => x_Msg_Count
     ,x_Msg_Data       => x_Msg_Data
    );

Line: 915


    BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension(
        p_Api_Version    => p_Api_Version
       ,p_Commit         => p_Commit
       ,p_Meas_Extn_Rec  => p_Meas_Extn_Rec
       ,x_Return_Status  => x_Return_Status
       ,x_Msg_Count      => x_Msg_Count
       ,x_Msg_Data       => x_Msg_Data
    );

Line: 935


        ROLLBACK TO UpdateMeasExtnPSP;

Line: 945


        ROLLBACK TO UpdateMeasExtnPSP;

Line: 955


        ROLLBACK TO UpdateMeasExtnPSP;

Line: 958


            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';

Line: 960


            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';

Line: 963


        ROLLBACK TO UpdateMeasExtnPSP;

Line: 966


            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';

Line: 968


            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';

Line: 970


END Update_Measure_Extension;

Line: 1041


        IF (FND_LOAD_UTIL.UPLOAD_TEST(p_Meas_Extn_Rec.Last_Updated_By
                                    , p_Meas_Extn_Rec.Last_Update_Date
                                    , l_Meas_Extn_Rec.Last_Updated_By
                                    , l_Meas_Extn_Rec.Last_Update_Date
                                    , p_Custom_mode)) THEN
           --dbms_output.put_line('UPLDOATE SUCESS I AM GOING TO UPDATE FOR MEASURES' );

Line: 1049


           BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension(
              p_Api_Version    => p_Api_Version
             ,p_Commit         => p_Commit
             ,p_Meas_Extn_Rec  => l_Mes_up_Rec
             ,x_Return_Status  => x_Return_Status
             ,x_Msg_Count      => x_Msg_Count
             ,x_Msg_Data       => x_Msg_Data
           );

Line: 1101


        FUNCTION Name :- Delete_Measure_Extension
        PARAMETERS    :-
            p_Form_Func_Extn_Rec:- The Record containing all the vlaues of form function tables
        DESCRIPTION   :- This fucntions takes care of all validations based on action type
        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
    l_Commit        VARCHAR2(30);

Line: 1119


    SAVEPOINT DeleteMeasExtnPSP;

Line: 1130


     ,p_Action_Type    => C_DELETE
     ,x_Return_Status  => x_Return_Status
     ,x_Msg_Count      => x_Msg_Count
     ,x_Msg_Data       => x_Msg_Data
    );

Line: 1140


    BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension(
       p_Api_Version    => p_Api_Version
      ,p_Commit         => p_Commit
      ,p_Meas_Extn_Rec  => p_Meas_Extn_Rec
      ,x_Return_Status  => x_Return_Status
      ,x_Msg_Count      => x_Msg_Count
      ,x_Msg_Data       => x_Msg_Data
    );

Line: 1158


        ROLLBACK TO DeleteMeasExtnPSP;

Line: 1168


        ROLLBACK TO DeleteMeasExtnPSP;

Line: 1178


        ROLLBACK TO DeleteMeasExtnPSP;

Line: 1181


            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';

Line: 1183


            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';

Line: 1186


        ROLLBACK TO DeleteMeasExtnPSP;

Line: 1189


            x_msg_data      :=  x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';

Line: 1191


            x_msg_data      :=  SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';

Line: 1194


END Delete_Measure_Extension;

Line: 1202


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

Line: 1236


    IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE OR  p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_CREATE)  THEN
      IF(Trim(l_Meas_Extn_Rec.Functional_Area_Id) IS NULL) THEN
          FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');

Line: 1244


        SELECT COUNT(1) INTO l_Count
        FROM   BIS_FUNCTIONAL_AREAS B
        WHERE  B.FUNCTIONAL_AREA_ID = p_Meas_Extn_Rec.Functional_Area_Id;

Line: 1257


    SELECT COUNT(1) INTO l_Count
    FROM   BIS_MEASURES_EXTENSION
    WHERE  UPPER(MEASURE_SHORT_NAME) = UPPER(Trim(l_Meas_Extn_Rec.Measure_Short_Name));

Line: 1268


    ELSIF (p_Action_Type = C_UPDATE) THEN
      IF (l_Count = 0) THEN
        FND_MESSAGE.SET_NAME('BIS','BIS_SHORT_NAME_NOT_EXISTS');

Line: 1281


            SELECT COUNT(1)
            INTO   l_Count
            FROM   BIS_FUNCTIONAL_AREAS
            WHERE  UPPER(SHORT_NAME) = UPPER(TRIM(l_Meas_Extn_Rec.Func_Area_Short_Name));

Line: 1292


    ELSIF (p_Action_Type = C_RETRIEVE OR p_Action_Type = C_DELETE OR p_Action_Type = C_TRANS) THEN
      IF (l_Count = 0) THEN
        FND_MESSAGE.SET_NAME('BIS','BIS_SHORT_NAME_NOT_EXISTS');

Line: 1340


            p_Action_Type       :-  Action type this can be either CREATE or UPDATE
            p_Form_Func_Extn_Rec:- The Record containing all the vlaues of form function tables
        DESCRIPTION   :- This fucntions takes care of all validations based on action type
        AUTHOR        :- KRISHNA
*********************************************************************************************/

PROCEDURE Validate_Form_Func_Extension(
  p_Form_Func_Extn_Rec  IN          BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
 ,p_Action_Type         IN          VARCHAR2
 ,x_Return_Status       OUT NOCOPY  VARCHAR2
 ,x_Msg_Count           OUT NOCOPY  NUMBER
 ,x_Msg_Data            OUT NOCOPY  VARCHAR2
) IS
    l_Count         NUMBER;

Line: 1360


    SELECT COUNT(1)
    INTO   l_cnt_sht_name
    FROM   BIS_FORM_FUNCTION_EXTENSION
    WHERE  UPPER(OBJECT_NAME) = UPPER(TRIM(p_Form_Func_Extn_Rec.Object_Name));

Line: 1365


    SELECT COUNT(1)
    INTO   l_cnt_func_id
    FROM   BIS_FUNCTIONAL_AREAS
    WHERE  FUNCTIONAL_AREA_ID = p_Form_Func_Extn_Rec.Func_Area_Id;

Line: 1385


    IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE) THEN
        IF(l_cnt_sht_name = 0 ) THEN
            FND_MESSAGE.SET_NAME('BIS','BIS_FORM_FUNC_SHTNAME_NOTEXIST');

Line: 1394


    IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE OR  p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_CREATE)  THEN
        IF(Trim(p_Form_Func_Extn_Rec.Func_Area_Id) IS NULL) THEN
            FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');

Line: 1412


            SELECT COUNT(1)
            INTO l_cnt_app_id
            FROM FND_APPLICATION
            WHERE APPLICATION_ID = p_Form_Func_Extn_Rec.Application_Id;

Line: 1431


            SELECT COUNT(1)
            INTO   l_cnt_func_id
            FROM   BIS_FUNCTIONAL_AREAS
            WHERE  SHORT_NAME = p_Form_Func_Extn_Rec.Func_Area_short_name;

Line: 1443


    IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_TRANS OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_DELETE OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_RETRIEVE) THEN
        IF(l_cnt_sht_name = 0 ) THEN
            FND_MESSAGE.SET_NAME('BIS','BIS_FORM_FUNC_SHTNAME_NOTEXIST');

Line: 1513


    SELECT COUNT(0)
    INTO   l_count
    FROM   BIS_FORM_FUNCTION_EXTENSION
    WHERE  UPPER(TRIM(object_name)) = UPPER(TRIM(p_object_name));

Line: 1520


    SELECT COUNT(0)
    INTO   l_count
    FROM   BIS_MEASURES_EXTENSION
    WHERE  UPPER(TRIM(measure_short_name)) = UPPER(TRIM(p_object_name));

Line: 1655


                 update the object type with the new functional Area Id.
           3.If the Functional Area Id is passed as NULL and the association exists
             for the current Objevt Type then delete that association.
AUTHOR     : Ashankar
*********************************************************************************************/
PROCEDURE Measure_Funct_Area_Map
(
        p_Api_Version         IN          NUMBER
    ,   p_Commit              IN          VARCHAR2 := FND_API.G_FALSE
    ,   p_Obj_Type            IN          VARCHAR2
    ,   p_Obj_Name            IN          VARCHAR2
    ,   p_App_Id              IN          NUMBER
    ,   p_Func_Area_Sht_Name  IN          VARCHAR2
    ,   x_Return_Status       OUT NOCOPY  VARCHAR2
    ,   x_Msg_Count           OUT NOCOPY  NUMBER
    ,   x_Msg_Data            OUT NOCOPY  VARCHAR2
)IS
    l_count            NUMBER;

Line: 1689


            l_Meas_Extn_Rec.Last_Updated_By      :=  FND_GLOBAL.user_id;

Line: 1690


            l_Meas_Extn_Rec.Last_Update_Date     :=  SYSDATE;

Line: 1691


            l_Meas_Extn_Rec.Last_Update_Login    :=  FND_GLOBAL.LOGIN_ID;

Line: 1693


            BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension
            (
                    p_Api_Version    => p_Api_Version
                ,   p_Commit         => p_Commit
                ,   p_Meas_Extn_Rec  => l_Meas_Extn_Rec
                ,   x_Return_Status  => x_Return_Status
                ,   x_Msg_Count      => x_Msg_Count
                ,   x_Msg_Data       => x_Msg_Data
            );

Line: 1705


                FND_MESSAGE.SET_NAME('BIS','BIS_OBJ_EXT_UPDATE_SUCCESSFUL');

Line: 1710


            BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension
            (
                    p_Api_Version         => p_Api_Version
                ,   p_Commit              => p_Commit
                ,   p_Meas_Extn_Rec       => l_Meas_Extn_Rec
                ,   x_Return_Status       => x_Return_Status
                ,   x_Msg_Count           => x_Msg_Count
                ,   x_Msg_Data            => x_Msg_Data
            );

Line: 1722


              FND_MESSAGE.SET_NAME('BIS','BIS_OBJ_EXT_DELETE_SUCCESSFUL');

Line: 1740


            l_Meas_Extn_Rec.Last_Updated_By      :=  FND_GLOBAL.user_id;

Line: 1741


            l_Meas_Extn_Rec.Last_Update_Date     :=  SYSDATE;

Line: 1742


            l_Meas_Extn_Rec.Last_Update_Login    :=  FND_GLOBAL.LOGIN_ID;

Line: 1815


                 update the object type with the new functional Area Id.
           3.If the Functional Area Id is passed as NULL and the association exists
             for the current Objevt Type then delete that association.
AUTHOR     : Ashankar
*********************************************************************************************/
PROCEDURE Form_Func_Functional_Area_Map
(
        p_Api_Version         IN          NUMBER
    ,   p_Commit              IN          VARCHAR2 := FND_API.G_FALSE
    ,   p_Obj_Type            IN          VARCHAR2
    ,   p_Obj_Name            IN          VARCHAR2
    ,   p_App_Id              IN          NUMBER
    ,   p_Func_Area_Sht_Name  IN          VARCHAR2
    ,   x_Return_Status       OUT NOCOPY  VARCHAR2
    ,   x_Msg_Count           OUT NOCOPY  NUMBER
    ,   x_Msg_Data            OUT NOCOPY  VARCHAR2
)IS
    l_count            NUMBER;

Line: 1852


                l_From_Func_Extn_Rec.Last_Updated_By       := FND_GLOBAL.user_id;

Line: 1853


                l_From_Func_Extn_Rec.Last_Update_Date      := SYSDATE;

Line: 1854


                l_From_Func_Extn_Rec.Last_Update_Login     := FND_GLOBAL.LOGIN_ID;

Line: 1856


                BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension
                (
                        p_Api_Version         =>  p_Api_Version
                    ,   p_Commit              =>  p_Commit
                    ,   p_Form_Func_Extn_Rec  =>  l_From_Func_Extn_Rec
                    ,   x_Return_Status       =>  x_Return_Status
                    ,   x_Msg_Count           =>  x_Msg_Count
                    ,   x_Msg_Data            =>  x_Msg_Data
                );

Line: 1868


                    FND_MESSAGE.SET_NAME('BIS','BIS_OBJ_EXT_UPDATE_SUCCESSFUL');

Line: 1873


            BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension
            (
                    p_Api_Version         => p_Api_Version
                ,   p_Commit              => p_Commit
                ,   p_Form_Func_Extn_Rec  => l_From_Func_Extn_Rec
                ,   x_Return_Status       => x_Return_Status
                ,   x_Msg_Count           => x_Msg_Count
                ,   x_Msg_Data            => x_Msg_Data
            );

Line: 1885


                FND_MESSAGE.SET_NAME('BIS','BIS_OBJ_EXT_DELETE_SUCCESSFUL');

Line: 1905


            l_From_Func_Extn_Rec.Last_Updated_By       := FND_GLOBAL.user_id;

Line: 1906


            l_From_Func_Extn_Rec.Last_Update_Date      := SYSDATE;

Line: 1907


            l_From_Func_Extn_Rec.Last_Update_Login     := FND_GLOBAL.LOGIN_ID;