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

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

Line: 21


REM | 14-Feb-2006 hengliu  Added Delete_Custom_Region_Items                 |
REM +=======================================================================+
*/
--


PROCEDURE Create_Custom_Region_Items
( p_api_version              IN  NUMBER
, p_commit                   IN  VARCHAR2   := FND_API.G_FALSE
, p_Custom_Region_Items_Rec  IN  BIS_CUSTOMIZATION_PUB.custom_region_items_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: 91


PROCEDURE Update_Custom_Region_Items
( p_api_version              IN  NUMBER
, p_commit                   IN  VARCHAR2   := FND_API.G_FALSE
, p_Custom_Region_Items_Rec  IN  BIS_CUSTOMIZATION_PUB.custom_Region_Items_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: 105


  BIS_CUSTOMIZATION_PVT.Update_Custom_Region_Items
  ( p_api_version              =>  p_api_version
  , p_commit                   =>  p_commit
  , p_Custom_Region_Items_Rec  =>  p_Custom_Region_Items_Rec
  , x_return_status            =>  x_return_status
  , x_msg_count                =>  x_msg_count
  , x_msg_data                 =>  x_msg_data
  );

Line: 139


      x_msg_data      :=  x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';

Line: 141


      x_msg_data      :=  SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';

Line: 146


      x_msg_data      :=  x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';

Line: 148


      x_msg_data      :=  SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';

Line: 151


END Update_Custom_Region_Items;

Line: 224


PROCEDURE Update_Custom_Region_Items_UI
( p_api_version                   IN  NUMBER
, p_commit                        IN  VARCHAR2   := FND_API.G_FALSE
, p_customization_application_id  IN  NUMBER
, p_customization_code            IN  VARCHAR2
, p_region_application_id         IN  NUMBER
, p_region_code                   IN  VARCHAR2
, p_attribute_application_id      IN  NUMBER
, p_attribute_code                IN  VARCHAR2
, p_property_name                 IN  VARCHAR2
, p_property_varchar2_value       IN  VARCHAR2
, p_property_number_value         IN  NUMBER
, p_property_date_value           IN  DATE
, x_return_status                 OUT NOCOPY VARCHAR2
, x_msg_count                     OUT NOCOPY NUMBER
, x_msg_data                      OUT NOCOPY VARCHAR2
)IS

l_custom_region_items_rec      BIS_CUSTOMIZATION_PUB.custom_region_items_type;

Line: 259


  BIS_CUSTOMIZATION_PUB.Update_Custom_Region_Items
  ( p_api_version              =>  p_api_version
  , p_commit                   =>  p_commit
  , p_Custom_Region_Items_Rec  =>  l_custom_region_items_rec
  , x_return_status            =>  x_return_status
  , x_msg_count                =>  x_msg_count
  , x_msg_data                 =>  x_msg_data
  );

Line: 287


      x_msg_data      :=  x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Custom_region_items_UI ';

Line: 289


      x_msg_data      :=  SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Custom_region_items_UI ';

Line: 292


END Update_Custom_region_items_UI;

Line: 294


PROCEDURE Delete_Custom_Region_Items
( p_api_version              IN  NUMBER
, p_commit                   IN  VARCHAR2   := FND_API.G_FALSE
, p_Custom_Region_Items_Rec  IN  BIS_CUSTOMIZATION_PUB.custom_Region_Items_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: 308


  BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_Items
  ( p_api_version              =>  p_api_version
  , p_commit                   =>  p_commit
  , p_Custom_Region_Items_Rec  =>  p_Custom_Region_Items_Rec
  , x_return_status            =>  x_return_status
  , x_msg_count                =>  x_msg_count
  , x_msg_data                 =>  x_msg_data
  );

Line: 342


      x_msg_data      :=  x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';

Line: 344


      x_msg_data      :=  SQLERRM||' at BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';

Line: 349


      x_msg_data      :=  x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';

Line: 351


      x_msg_data      :=  SQLERRM||' at BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';

Line: 354


END Delete_Custom_Region_Items;

Line: 356


PROCEDURE Delete_Custom_Region_Items_UI
( p_api_version                   IN  NUMBER
, p_commit                        IN  VARCHAR2   := FND_API.G_FALSE
, p_customization_application_id  IN  NUMBER
, p_customization_code            IN  VARCHAR2
, p_region_application_id         IN  NUMBER
, p_region_code                   IN  VARCHAR2
, p_attribute_application_id      IN  NUMBER
, p_attribute_code                IN  VARCHAR2
, p_property_name                 IN  VARCHAR2
, x_return_status                 OUT NOCOPY VARCHAR2
, x_msg_count                     OUT NOCOPY NUMBER
, x_msg_data                      OUT NOCOPY VARCHAR2
) IS
  l_custom_region_items_rec       BIS_CUSTOMIZATION_PUB.custom_region_items_type;

Line: 383


  BIS_CUSTOMIZATION_PVT.delete_custom_region_items
  ( p_api_version               => p_api_version
  , p_commit                    => p_commit
  , p_custom_region_items_rec   => l_custom_region_items_rec
  , x_return_status             => x_return_status
  , x_msg_count                 => x_msg_count
  , x_msg_data                  => x_msg_data);

Line: 411


      x_msg_data      :=  x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Delete_Custom_region_items_UI ';

Line: 413


      x_msg_data      :=  SQLERRM||' at BIS_CUSTOMIZATION_PUB.Delete_Custom_region_items_UI ';

Line: 416


END Delete_Custom_Region_Items_UI;

Line: 480


PROCEDURE Update_Customizations
( p_api_version         IN  NUMBER
, p_commit              IN  VARCHAR2   := FND_API.G_FALSE
, p_Customizations_Rec  IN  BIS_CUSTOMIZATION_PUB.customizations_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: 494


  BIS_CUSTOMIZATION_PVT.Update_Customizations
  ( p_api_version         =>  p_api_version
  , p_commit              =>  p_commit
  , p_Customizations_Rec  =>  p_Customizations_Rec
  , x_return_status       =>  x_return_status
  , x_msg_count           =>  x_msg_count
  , x_msg_data            =>  x_msg_data
  );

Line: 529


      x_msg_data      :=  x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Customizations ';

Line: 531


      x_msg_data      :=  SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Customizations ';

Line: 536


      x_msg_data      :=  x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Customizations ';

Line: 538


      x_msg_data      :=  SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Customizations ';

Line: 541


END Update_Customizations;

Line: 631


PROCEDURE Update_Customizations_UI
( p_api_version                   IN  NUMBER
, p_commit                        IN  VARCHAR2  := FND_API.G_FALSE
, p_customization_application_id  IN  NUMBER
, p_customization_code            IN  VARCHAR2
, p_region_application_id         IN  NUMBER
, p_region_code                   IN  VARCHAR2
, p_verticalization_id            IN  VARCHAR2
, p_localization_code             IN  VARCHAR2
, p_org_id                        IN  NUMBER
, p_site_id                       IN  NUMBER
, p_responsibility_id             IN  NUMBER
, p_web_user_id                   IN  NUMBER
, p_default_customization_flag    IN  VARCHAR2
, p_customization_level_id        IN  NUMBER
, p_start_date_active             IN  DATE
, p_end_date_active               IN  DATE
, p_reference_path                IN  VARCHAR2
, p_function_name                 IN  VARCHAR2
, p_developer_mode                IN  VARCHAR2
, p_name                          IN  VARCHAR2
, p_description                   IN  VARCHAR2
, x_return_status                 OUT NOCOPY VARCHAR2
, x_msg_count                     OUT NOCOPY NUMBER
, x_msg_data                      OUT NOCOPY VARCHAR2
)
IS
  l_customizations_rec    BIS_CUSTOMIZATION_PUB.customizations_type;

Line: 683


  BIS_CUSTOMIZATION_PUB.Update_Customizations
  ( p_api_version         =>  p_api_version
  , p_commit              =>  p_commit
  , p_Customizations_Rec  =>  l_customizations_rec
  , x_return_status       =>  x_return_status
  , x_msg_count           =>  x_msg_count
  , x_msg_data            =>  x_msg_data
  );

Line: 711


      x_msg_data      :=  x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Customizations_UI ';

Line: 713


      x_msg_data      :=  SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Customizations_UI ';

Line: 716


END Update_Customizations_UI;