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

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

Line: 19


REM | 14-Feb-2005 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
l_rowid  VARCHAR2(100);

Line: 40


  AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW
  ( X_ROWID                         =>  l_rowid
  , X_CUSTOMIZATION_APPLICATION_ID  =>  p_Custom_Region_Items_Rec.customization_application_id
  , X_CUSTOMIZATION_CODE            =>  p_Custom_Region_Items_Rec.customization_code
  , X_REGION_APPLICATION_ID         =>  p_Custom_Region_Items_Rec.region_application_id
  , X_REGION_CODE                   =>  p_Custom_Region_Items_Rec.region_code
  , X_ATTRIBUTE_APPLICATION_ID      =>  p_Custom_Region_Items_Rec.attribute_application_id
  , X_ATTRIBUTE_CODE                =>  p_Custom_Region_Items_Rec.attribute_code
  , X_PROPERTY_NAME                 =>  p_Custom_Region_Items_Rec.property_name
  , X_PROPERTY_VARCHAR2_VALUE       =>  p_Custom_Region_Items_Rec.property_varchar2_value
  , X_PROPERTY_NUMBER_VALUE         =>  p_Custom_Region_Items_Rec.property_number_value
  , X_PROPERTY_DATE_VALUE           =>  p_Custom_Region_Items_Rec.property_date_value
  , X_CREATED_BY                    =>  NVL(p_Custom_Region_Items_Rec.created_by,FND_GLOBAL.USER_ID)
  , X_CREATION_DATE                 =>  NVL(p_Custom_Region_Items_Rec.last_update_date,SYSDATE)
  , X_LAST_UPDATED_BY               =>  NVL(p_Custom_Region_Items_Rec.last_updated_by,FND_GLOBAL.USER_ID)
  , X_LAST_UPDATE_DATE              =>  NVL(p_Custom_Region_Items_Rec.last_update_date,SYSDATE)
  , X_LAST_UPDATE_LOGIN             =>  NVL(p_Custom_Region_Items_Rec.last_update_login,FND_GLOBAL.LOGIN_ID)
   );

Line: 102


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


  AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW
  ( X_CUSTOMIZATION_APPLICATION_ID  =>  p_Custom_Region_Items_Rec.customization_application_id
  , X_CUSTOMIZATION_CODE            =>  p_Custom_Region_Items_Rec.customization_code
  , X_REGION_APPLICATION_ID         =>  p_Custom_Region_Items_Rec.region_application_id
  , X_REGION_CODE                   =>  p_Custom_Region_Items_Rec.region_code
  , X_ATTRIBUTE_APPLICATION_ID      =>  p_Custom_Region_Items_Rec.attribute_application_id
  , X_ATTRIBUTE_CODE                =>  p_Custom_Region_Items_Rec.attribute_code
  , X_PROPERTY_NAME                 =>  p_Custom_Region_Items_Rec.property_name
  , X_PROPERTY_VARCHAR2_VALUE       =>  p_Custom_Region_Items_Rec.property_varchar2_value
  , X_PROPERTY_NUMBER_VALUE         =>  p_Custom_Region_Items_Rec.property_number_value
  , X_PROPERTY_DATE_VALUE           =>  p_Custom_Region_Items_Rec.property_date_value
  , X_LAST_UPDATED_BY               =>  NVL(p_Custom_Region_Items_Rec.last_updated_by,FND_GLOBAL.USER_ID)
  , X_LAST_UPDATE_DATE              =>  NVL(p_Custom_Region_Items_Rec.last_update_date,SYSDATE)
  , X_LAST_UPDATE_LOGIN             =>  NVL(p_Custom_Region_Items_Rec.last_update_login,FND_GLOBAL.LOGIN_ID)
  );

Line: 160


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

Line: 162


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

Line: 167


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

Line: 169


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

Line: 173


END Update_Custom_Region_Items;

Line: 175


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


  AK_CUSTOM_REGION_ITEMS_PKG.Delete_ROW
  ( X_CUSTOMIZATION_APPLICATION_ID  =>  p_Custom_Region_Items_Rec.customization_application_id
  , X_CUSTOMIZATION_CODE            =>  p_Custom_Region_Items_Rec.customization_code
  , X_REGION_APPLICATION_ID         =>  p_Custom_Region_Items_Rec.region_application_id
  , X_REGION_CODE                   =>  p_Custom_Region_Items_Rec.region_code
  , X_ATTRIBUTE_APPLICATION_ID      =>  p_Custom_Region_Items_Rec.attribute_application_id
  , X_ATTRIBUTE_CODE                =>  p_Custom_Region_Items_Rec.attribute_code
  , X_PROPERTY_NAME                 =>  p_Custom_Region_Items_Rec.property_name
  );

Line: 223


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

Line: 225


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

Line: 230


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

Line: 232


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

Line: 235


END Delete_Custom_Region_Items;

Line: 251


  INSERT INTO ak_customizations (
     customization_application_id
    ,customization_code
    ,region_application_id
    ,region_code
    ,verticalization_id
    ,localization_code
    ,org_id
    ,site_id
    ,responsibility_id
    ,web_user_id
    ,default_customization_flag
    ,customization_level_id
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,start_date_active
    ,end_date_active
    ,reference_path
    ,function_name
    ,developer_mode
  ) VALUES (
     p_Customizations_Rec.customization_application_id
    ,p_Customizations_Rec.customization_code
    ,p_Customizations_Rec.region_application_id
    ,p_Customizations_Rec.region_code
    ,p_Customizations_Rec.verticalization_id
    ,p_Customizations_Rec.localization_code
    ,p_Customizations_Rec.org_id
    ,p_Customizations_Rec.site_id
    ,p_Customizations_Rec.responsibility_id
    ,p_Customizations_Rec.web_user_id
    ,p_Customizations_Rec.default_customization_flag
    ,p_Customizations_Rec.customization_level_id
    ,NVL(p_Customizations_Rec.created_by,FND_GLOBAL.USER_ID)
    ,NVL(p_Customizations_Rec.last_update_date,SYSDATE)
    ,NVL(p_Customizations_Rec.last_updated_by,FND_GLOBAL.USER_ID)
    ,NVL(p_Customizations_Rec.last_update_date,SYSDATE)
    ,NVL(p_Customizations_Rec.last_update_login,FND_GLOBAL.LOGIN_ID)
    ,NVL(p_Customizations_Rec.start_date_active,SYSDATE)
    ,p_Customizations_Rec.end_date_active
    ,p_Customizations_Rec.reference_path
    ,p_Customizations_Rec.function_name
    ,p_Customizations_Rec.developer_mode
    );

Line: 300


  INSERT INTO ak_customizations_tl (
     customization_application_id
    ,customization_code
    ,region_application_id
    ,region_code
    ,name
    ,description
    ,language
    ,source_lang
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
  ) SELECT
     p_Customizations_Rec.customization_application_id
    ,p_Customizations_Rec.customization_code
    ,p_Customizations_Rec.region_application_id
    ,p_Customizations_Rec.region_code
    ,p_Customizations_Rec.name
    ,p_Customizations_Rec.description
    ,L.language_code
    ,USERENV('LANG')
    ,NVL(p_Customizations_Rec.created_by,FND_GLOBAL.USER_ID)
    ,NVL(p_Customizations_Rec.last_update_date,SYSDATE)
    ,NVL(p_Customizations_Rec.last_updated_by,FND_GLOBAL.USER_ID)
    ,NVL(p_Customizations_Rec.last_update_date,SYSDATE)
    ,NVL(p_Customizations_Rec.last_update_login,FND_GLOBAL.LOGIN_ID)
  FROM fnd_languages L
  WHERE L.installed_flag IN ('I', 'B')
  AND   NOT EXISTS
  (SELECT NULL
  FROM ak_customizations_tl T
  WHERE T.customization_application_id = p_Customizations_Rec.customization_application_id
  AND   T.customization_code           = p_Customizations_Rec.customization_code
  AND   T.region_application_id        = p_Customizations_Rec.region_application_id
  AND   T.region_code                  = p_Customizations_Rec.region_code
  AND   T.language                     = L.language_code);

Line: 384


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


  UPDATE ak_customizations SET
     customization_application_id  =  p_Customizations_Rec.customization_application_id
    ,customization_code            =  p_Customizations_Rec.customization_code
    ,region_application_id         =  p_Customizations_Rec.region_application_id
    ,region_code                   =  p_Customizations_Rec.region_code
    ,verticalization_id            =  p_Customizations_Rec.verticalization_id
    ,localization_code             =  p_Customizations_Rec.localization_code
    ,org_id                        =  p_Customizations_Rec.org_id
    ,site_id                       =  p_Customizations_Rec.site_id
    ,responsibility_id             =  p_Customizations_Rec.responsibility_id
    ,web_user_id                   =  p_Customizations_Rec.web_user_id
    ,default_customization_flag    =  p_Customizations_Rec.default_customization_flag
    ,customization_level_id        =  p_Customizations_Rec.customization_level_id
    ,last_updated_by               =  NVL(p_Customizations_Rec.last_updated_by,FND_GLOBAL.USER_ID)
    ,last_update_date              =  NVL(p_Customizations_Rec.last_update_date,SYSDATE)
    ,last_update_login             =  NVL(p_Customizations_Rec.last_update_login,FND_GLOBAL.LOGIN_ID)
    ,start_date_active             =  p_Customizations_Rec.start_date_active
    ,end_date_active               =  p_Customizations_Rec.end_date_active
    ,reference_path                =  p_Customizations_Rec.reference_path
    ,function_name                 =  p_Customizations_Rec.function_name
    ,developer_mode                =  p_Customizations_Rec.developer_mode
  WHERE customization_application_id = p_Customizations_Rec.customization_application_id
  AND   customization_code           = p_Customizations_Rec.customization_code
  AND   region_application_id        = p_Customizations_Rec.region_application_id
  AND   region_code                  = p_Customizations_Rec.region_code;

Line: 423


  UPDATE AK_CUSTOMIZATIONS_TL SET
     name               =  p_Customizations_Rec.name
    ,description        =  p_Customizations_Rec.description
    ,last_updated_by    =  NVL(p_Customizations_Rec.last_updated_by,FND_GLOBAL.USER_ID)
    ,last_update_date   =  NVL(p_Customizations_Rec.last_update_date,SYSDATE)
    ,last_update_login  =  NVL(p_Customizations_Rec.last_update_login,FND_GLOBAL.LOGIN_ID)
    ,source_lang        =  USERENV('LANG')
  WHERE customization_application_id =  p_Customizations_Rec.customization_application_id
  AND   customization_code           =  p_Customizations_Rec.customization_code
  AND   region_application_id        =  p_Customizations_Rec.region_application_id
  AND   region_code                  =  p_Customizations_Rec.region_code
  AND   USERENV('LANG')              IN (language, source_lang);

Line: 463


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

Line: 465


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

Line: 470


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

Line: 472


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

Line: 475


END Update_Customizations;