APPS.BIS_PMV_REGION_ITEMS_PVT SQL Statements

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

Line: 39

        BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW
        (      p_commit                => p_commit
           ,   p_region_code           => p_region_code
           ,   p_region_application_id => p_region_application_id
           ,   p_Region_Item_Rec       => l_Region_Item_Rec
           ,   x_return_status         => x_return_status
           ,   x_msg_count             => x_msg_count
           ,   x_msg_data              => x_msg_data
        );

Line: 123

PROCEDURE UPDATE_REGION_ITEMS
(       p_commit                IN          VARCHAR2   := FND_API.G_TRUE
    ,   p_region_code           IN          VARCHAR2
    ,   p_region_application_id IN          NUMBER
    ,   p_Region_Item_Tbl       IN          BIS_AK_REGION_PUB.Bis_Region_Item_Tbl_Type
    ,   x_return_status         OUT NOCOPY  VARCHAR2
    ,   x_msg_count             OUT NOCOPY  NUMBER
    ,   x_msg_data              OUT NOCOPY  VARCHAR2
) IS
  l_Region_Item_Rec       BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;

Line: 140

        BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW
        (      p_commit                => p_commit
           ,   p_region_code           => p_region_code
           ,   p_region_application_id => p_region_application_id
           ,   p_Region_Item_Rec       => l_Region_Item_Rec
           ,   x_return_status         => x_return_status
           ,   x_msg_count             => x_msg_count
           ,   x_msg_data              => x_msg_data
        );

Line: 158

        BIS_REGION_ITEM_EXTENSION_PVT.UPDATE_REGION_ITEM_RECORD
        (      pRegionCode              => p_region_code
           ,   pRegionAppId             => p_region_application_id
           ,   pAttributeCode           => l_Region_Item_Rec.Attribute_Code
           ,   pAttributeAppId          => l_Region_Item_Rec.Attribute_Application_Id
           ,   pAttribute16             => l_Region_Item_Rec.Additional_View_By
           ,   pAttribute17             => l_Region_Item_Rec.Rolling_Lookup
           ,   pAttribute18             => l_Region_Item_Rec.Operator_Lookup
           ,   pAttribute19             => l_Region_Item_Rec.Dual_YAxis_Graphs
           ,   pAttribute20             => l_Region_Item_Rec.Custom_View_Name
           ,   pAttribute21             => l_Region_Item_Rec.Graph_Measure_Type
           ,   pAttribute22             => l_Region_Item_Rec.Hide_Target_In_Table
           ,   pAttribute23             => l_Region_Item_Rec.Parameter_Render_Type
           ,   pAttribute24             => l_Region_Item_Rec.Privilege
           ,   pAttribute25             => NULL
           ,   pAttribute26             => l_Region_Item_Rec.Grand_Total_Flag
           ,   pAttribute27             => NULL
           ,   pAttribute28             => NULL
           ,   pAttribute29             => NULL
           ,   pAttribute30             => NULL
           ,   pAttribute31             => NULL
           ,   pAttribute32             => NULL
           ,   pAttribute33             => NULL
           ,   pAttribute34             => NULL
           ,   pAttribute35             => NULL
           ,   pAttribute36             => NULL
           ,   pAttribute37             => NULL
           ,   pAttribute38             => NULL
           ,   pAttribute39             => NULL
           ,   pAttribute40             => NULL
           ,   pCommit                  => l_commit
        );

Line: 217

            x_msg_data      :=  x_msg_data||' -> BIS_PMV_REGION_ITEMS_PVT.UPDATE_REGION_ITEMS ';

Line: 219

            x_msg_data      :=  SQLERRM||' at BIS_PMV_REGION_ITEMS_PVT.UPDATE_REGION_ITEMS ';

Line: 222

END UPDATE_REGION_ITEMS;

Line: 224

PROCEDURE DELETE_REGION_ITEMS
(       p_commit                      IN          VARCHAR2   := FND_API.G_TRUE
    ,   p_region_code                 IN          VARCHAR2
    ,   p_region_application_id       IN          NUMBER
    ,   p_Attribute_Code_Tbl          IN          BISVIEWER.t_char
    ,   p_Attribute_Appl_Id_Tbl       IN          BISVIEWER.t_num
    ,   x_return_status               OUT NOCOPY  VARCHAR2
    ,   x_msg_count                   OUT NOCOPY  NUMBER
    ,   x_msg_data                    OUT NOCOPY  VARCHAR2
) IS
BEGIN
    FND_MSG_PUB.Initialize;

Line: 239

        BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW
        (      p_REGION_CODE              => p_region_code
           ,   p_REGION_APPLICATION_ID    => p_region_application_id
           ,   p_ATTRIBUTE_CODE           => p_Attribute_Code_Tbl(i)
           ,   p_ATTRIBUTE_APPLICATION_ID => p_Attribute_Appl_Id_Tbl(i)
           ,   x_return_status            => x_return_status
           ,   x_msg_count                => x_msg_count
           ,   x_msg_data                 => x_msg_data
           ,   p_commit                   => p_commit
        );

Line: 254

        BIS_REGION_ITEM_EXTENSION_PVT.DELETE_REGION_ITEM_RECORD
        (      p_commit                 => p_commit
           ,   pRegionCode              => p_region_code
           ,   pRegionAppId             => p_region_application_id
           ,   pAttributeCode           => p_Attribute_Code_Tbl(i)
           ,   pAttributeAppId          => p_Attribute_Appl_Id_Tbl(i)
        );

Line: 288

            x_msg_data      :=  x_msg_data||' -> BIS_PMV_REGION_ITEMS_PVT.DELETE_REGION_ITEMS ';

Line: 290

            x_msg_data      :=  SQLERRM||' at BIS_PMV_REGION_ITEMS_PVT.DELETE_REGION_ITEMS ';

Line: 293

END DELETE_REGION_ITEMS;