APPS.BIS_PMV_REGION_PVT SQL Statements

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

Line: 31

    BIS_AK_REGION_PUB.INSERT_REGION_ROW
    (      p_commit                => p_commit
       ,   p_Report_Region_Rec     => p_Report_Region_Rec
       ,   x_return_status         => x_return_status
       ,   x_msg_count             => x_msg_count
       ,   x_msg_data              => x_msg_data
    );

Line: 84

PROCEDURE UPDATE_REGION
(       p_commit                IN          VARCHAR2   := FND_API.G_TRUE
    ,   p_Report_Region_Rec     IN          BIS_AK_REGION_PUB.Bis_Region_Rec_Type
    ,   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: 94

    BIS_AK_REGION_PUB.UPDATE_REGION_ROW
    (      p_commit                => p_commit
       ,   p_Report_Region_Rec     => p_Report_Region_Rec
       ,   x_return_status         => x_return_status
       ,   x_msg_count             => x_msg_count
       ,   x_msg_data              => x_msg_data
    );

Line: 105

    BIS_REGION_EXTENSION_PVT.UPDATE_REGION_EXTN_RECORD
    (       p_commit                 => p_commit
        ,   pRegionCode              => p_Report_Region_Rec.Region_Code
        ,   pRegionAppId             => p_Report_Region_Rec.Region_Application_Id
        ,   pAttribute16             => p_Report_Region_Rec.Kpi_Id || ''
        ,   pAttribute17             => p_Report_Region_Rec.Analysis_Option_Id || ''
        ,   pAttribute18             => p_Report_Region_Rec.Dim_Set_Id || ''
        ,   pAttribute19             => p_Report_Region_Rec.Global_Menu || ''
        ,   pAttribute20             => p_Report_Region_Rec.Global_Title || ''
    );

Line: 140

            x_msg_data      :=  x_msg_data||' -> BIS_PMV_REGION_PVT.UPDATE_REGION ';

Line: 142

            x_msg_data      :=  SQLERRM||' at BIS_PMV_REGION_PVT.UPDATE_REGION ';

Line: 145

END UPDATE_REGION;

Line: 147

PROCEDURE DELETE_REGION
(       p_commit                IN          VARCHAR2   := FND_API.G_TRUE
    ,   p_Region_Code           IN          VARCHAR2
    ,   p_Region_Application_Id IN          NUMBER
    ,   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: 158

    BIS_AK_REGION_PUB.DELETE_REGION_ROW
    (      p_REGION_CODE           => p_Region_Code
       ,   p_REGION_APPLICATION_ID => p_Region_Application_Id
       ,   x_return_status         => x_return_status
       ,   x_msg_count             => x_msg_count
       ,   x_msg_data              => x_msg_data
       ,   p_commit                => p_commit
    );

Line: 170

    BIS_REGION_EXTENSION_PVT.DELETE_REGION_EXTN_RECORD
    (      p_commit                 => p_commit
       ,   pRegionCode              => p_Region_Code
       ,   pRegionAppId             => p_Region_Application_Id
    );

Line: 200

            x_msg_data      :=  x_msg_data||' -> BIS_PMV_REGION_PVT.DELETE_REGION ';

Line: 202

            x_msg_data      :=  SQLERRM||' at BIS_PMV_REGION_PVT.DELETE_REGION ';

Line: 205

END DELETE_REGION;