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

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

Line: 4


Procedure Create_User_Ind_Selection(
        p_api_version           IN NUMBER,
        p_Indicator_Region_Rec
          IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type,
        x_return_status	        OUT NOCOPY VARCHAR2,
        x_error_Tbl             OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_user_id             NUMBER;

Line: 19


   select rowid from BIS_USER_IND_SELECTIONS
   where IND_SELECTION_ID = l_user_ind_id;

Line: 38


  BIS_INDICATOR_REGION_PVT.Validate_User_Ind_Selection(
        p_api_version               => 1.0,
        p_event                     => 'CREATE',
        p_user_id                   => l_user_id,
        p_Indicator_Region_Rec      => p_Indicator_Region_Rec,
        x_return_status	            => x_return_status);

Line: 49


  BIS_INDICATOR_REGION_PVT.Create_User_Ind_Selection(
        p_api_version            => 1.0,
        p_Indicator_Region_Rec   => p_Indicator_Region_Rec,
        x_return_status	         => x_return_status ,
        x_error_Tbl              => x_error_Tbl);

Line: 67


  htp.p('BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection:'||SQLERRM); htp.para;

Line: 69


END Create_User_Ind_Selection;

Line: 71


Procedure Retrieve_User_Ind_Selections(
        p_api_version           IN NUMBER,
        p_user_id               IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
        p_user_name             IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
        p_plug_id               IN NUMBER ,
        p_all_info              IN VARCHAR2 Default FND_API.G_TRUE,
        x_Indicator_Region_Tbl
          OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
        x_return_status	        OUT NOCOPY VARCHAR2,
        x_error_Tbl             OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_Indicator_Region_rec  BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;

Line: 105


  BIS_INDICATOR_REGION_PVT.Validate_User_Ind_Selection(
        p_api_version               => 1.0,
        p_event                     => 'RETRIEVE',
        p_user_id                   => l_indicator_region_rec.user_id,
        p_Indicator_Region_Rec      => l_Indicator_Region_Rec,
        x_return_status	            => x_return_status);

Line: 116


  BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections(
        p_api_version               => 1.0,
        p_user_id                   => l_indicator_region_rec.user_id,
        p_user_name                 => l_indicator_region_rec.user_name,
        p_plug_id                   => l_indicator_region_rec.plug_id,
        p_all_info                  => p_all_info,
        x_Indicator_Region_Tbl      => x_Indicator_Region_Tbl,
        x_return_status	            => x_return_status ,
        x_error_Tbl                 => x_error_Tbl);

Line: 149


  htp.p('BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections:'||SQLERRM);

Line: 152


END Retrieve_User_Ind_Selections;

Line: 154


Procedure Retrieve_User_Ind_Selections(
        p_api_version           IN NUMBER,
        p_all_info              IN VARCHAR2 Default FND_API.G_TRUE,
        p_Target_level_rec      IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type,
        x_Indicator_Region_Tbl
          OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
        x_return_status	        OUT NOCOPY VARCHAR2,
        x_error_Tbl             OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS

l_Indicator_Region_rec  BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;

Line: 214


  BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections
  (  p_api_version              => 1.0
  , p_all_info                  => p_all_info
  , p_Target_level_id           => l_Target_level_rec.Target_Level_ID
  , x_Indicator_Region_Tbl      => x_Indicator_Region_Tbl
  , x_return_status	        => x_return_status
  , x_error_Tbl                 => x_error_Tbl
  );

Line: 248


END Retrieve_User_Ind_Selections;

Line: 251


Procedure Update_User_Ind_Selection(
        p_api_version           IN NUMBER,
        p_user_id               IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
        p_user_name             IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
        p_plug_id               IN NUMBER ,
        p_Indicator_Region_Tbl
          IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
        x_return_status	        OUT NOCOPY VARCHAR2,
        x_error_Tbl     OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_user_id NUMBER;

Line: 266


e_UpdateException EXCEPTION;

Line: 280


     RAISE e_UpdateException;

Line: 285


    BIS_INDICATOR_REGION_PVT.Validate_User_Ind_Selection(
        p_api_version               => 1.0,
        p_event                     => 'UPDATE',
        p_user_id                   => l_user_id,
        p_Indicator_Region_Rec      => p_Indicator_Region_Tbl(i),
        x_return_status	            => x_return_status);

Line: 293


        RAISE e_UpdateException;

Line: 296


    BIS_INDICATOR_REGION_PVT.Update_User_Ind_Selection(
        p_api_version               => 1.0,
        p_user_id                   => l_user_id,
        p_user_name                 => l_user_name,
        p_plug_id                   => p_plug_id,
        p_Indicator_Region_Rec      => p_Indicator_Region_Tbl(i),
        x_return_status	            => x_return_status ,
        x_error_Tbl                 => x_error_Tbl);

Line: 308


  WHEN e_UpdateException THEN
    x_return_status := FND_API.G_RET_STS_ERROR;

Line: 319


  htp.p('BIS_INDICATOR_REGION_PUB.Update_User_Ind_Selection:'||SQLERRM); htp.para;

Line: 321


END Update_User_Ind_Selection;

Line: 324


Procedure Delete_User_Ind_Selections(
        p_api_version           IN NUMBER,
        p_user_id               IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
        p_user_name             IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
        p_plug_id               IN NUMBER,
        x_return_status	        OUT NOCOPY VARCHAR2,
        x_error_Tbl             OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
)
IS
l_Indicator_Region_rec  BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;

Line: 337


e_DeleteException       EXCEPTION;

Line: 351


     RAISE e_DeleteException;

Line: 358


  BIS_INDICATOR_REGION_PVT.Validate_User_Ind_Selection(
        p_api_version               => 1.0,
        p_event                     => 'DELETE',
        p_user_id                   => l_Indicator_Region_Rec.user_id,
        p_Indicator_Region_Rec      => l_Indicator_Region_Rec,
        x_return_status	            => x_return_status);

Line: 366


        RAISE e_DeleteException;

Line: 369


  BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections(
        p_api_version               => 1.0,
        p_user_id                   => l_indicator_region_rec.user_id,
        p_user_name                 => l_indicator_region_rec.user_name,
        p_plug_id                   => l_indicator_region_rec.plug_id,
        x_return_status	            => x_return_status ,
        x_error_Tbl                 => x_error_Tbl);

Line: 378


  WHEN e_DeleteException THEN
    x_return_status := FND_API.G_RET_STS_ERROR;

Line: 389


  htp.p('BIS_INDICATOR_REGION_PUB.Delete_User_Ind_Selection:'||SQLERRM); htp.para;

Line: 391


END Delete_User_Ind_Selections;