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.BSC_COLOR_PVT SQL Statements

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

Line: 56


    SELECT COUNT(1) INTO l_Count
    FROM   BSC_SYS_COLORS_B
    WHERE  COLOR_ID = p_Bsc_Color_Rec.Color_id;

Line: 78


  BSC_COLOR_PKG.INSERT_ROW(p_Bsc_Color_Rec.color_id
                          ,p_Bsc_Color_Rec.Short_Name
                          ,p_Bsc_Color_Rec.name
                          ,p_Bsc_Color_Rec.description
                          ,p_Bsc_Color_Rec.prototype_label
                          ,p_Bsc_Color_Rec.Perf_Sequence
                          ,p_Bsc_Color_Rec.color
                          ,p_Bsc_Color_Rec.User_Color
                          ,p_Bsc_Color_Rec.forecast_color
                          ,p_Bsc_Color_Rec.User_Forecast_Color
                          ,p_Bsc_Color_Rec.Numeric_Equivalent
                          ,p_Bsc_Color_Rec.User_Numeric_Equivalent
                          ,p_Bsc_Color_Rec.Image
                          ,p_Bsc_Color_Rec.Created_By
                          ,p_Bsc_Color_Rec.Last_Updated_By
                          ,p_Bsc_Color_Rec.Last_Update_Login
                           );

Line: 134


PROCEDURE Update_Color(
  p_commit             IN             VARCHAR2 := FND_API.G_FALSE
 ,p_Bsc_Color_Rec      IN             BSC_COLOR_PUB.Bsc_Color_Rec
 ,x_return_status       OUT NOCOPY     VARCHAR2
 ,x_msg_count           OUT NOCOPY     NUMBER
 ,x_msg_data            OUT NOCOPY     VARCHAR2
) IS
  l_color_id         NUMBER;

Line: 151


  /*BSC_COLOR_PKG.UPDATE_ROW(p_Bsc_Color_Rec.color_id
                          ,p_Bsc_Color_Rec.Perf_Sequence
                          ,p_Bsc_Color_Rec.color
                          ,p_Bsc_Color_Rec.user_color
                          ,p_Bsc_Color_Rec.User_Forecast_Color
                          ,p_Bsc_Color_Rec.Numeric_Equivalent
                          ,p_Bsc_Color_Rec.User_Numeric_Equivalent
                          ,p_Bsc_Color_Rec.Image
                          ,p_Bsc_Color_Rec.Last_Updated_By
                          ,p_Bsc_Color_Rec.last_update_login);*/

Line: 205


  BSC_COLOR_PKG.UPDATE_ROW(p_Color_Id               =>   l_Bsc_Color_Rec.color_id
                          ,p_Perf_Sequence_Id       =>   l_Bsc_Color_Rec.Perf_Sequence
                          ,p_System_Color           =>   l_Bsc_Color_Rec.color
                          ,p_User_Color             =>   l_Bsc_Color_Rec.user_color
                          ,p_User_Forecast_Color    =>   l_Bsc_Color_Rec.User_Forecast_Color
                          ,p_Numeric_Equivalent     =>   l_Bsc_Color_Rec.Numeric_Equivalent
                          ,p_User_Numeric_Equivalent=>   l_Bsc_Color_Rec.User_Numeric_Equivalent
                          ,p_Image                  =>   l_Bsc_Color_Rec.Image
                          ,p_Last_Updated_By        =>   nvl(l_Bsc_Color_Rec.Last_Updated_By, l_user_id)
                          ,p_Last_Update_Login      =>   nvl(l_Bsc_Color_Rec.last_update_login, l_login_id));

Line: 219


END Update_Color;

Line: 222


PROCEDURE Delete_Color(
  p_commit              IN             VARCHAR2:= FND_API.G_FALSE
 ,p_Bsc_Color_Id        IN             NUMBER
 ,p_Bsc_Color_SN        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: 241


  BSC_COLOR_PKG.DELETE_ROW(p_Bsc_Color_Id
                          ,p_Bsc_Color_SN);

Line: 247


END Delete_Color;

Line: 310


  BSC_COLOR_PKG.UPDATE_ROW(p_Color_Id               =>   l_Bsc_Color_Rec.color_id
                          ,p_System_Color_Name      =>   l_Bsc_Color_Rec.name
                          ,p_System_Color_Desc      =>   l_Bsc_Color_Rec.description
                          ,p_prototype_label        =>   l_Bsc_Color_Rec.prototype_label
                          ,p_Perf_Sequence_Id       =>   l_Bsc_Color_Rec.Perf_Sequence
                          ,p_System_Color           =>   l_Bsc_Color_Rec.color
                          ,p_User_Color             =>   l_Bsc_Color_Rec.user_color
                          ,p_User_Forecast_Color    =>   l_Bsc_Color_Rec.User_Forecast_Color
                          ,p_Numeric_Equivalent     =>   l_Bsc_Color_Rec.Numeric_Equivalent
                          ,p_User_Numeric_Equivalent=>   l_Bsc_Color_Rec.User_Numeric_Equivalent
                          ,p_Image                  =>   l_Bsc_Color_Rec.Image
                          ,p_Last_Updated_By        =>   l_Bsc_Color_Rec.Last_Updated_By
                          ,p_Last_Update_Login      =>   l_Bsc_Color_Rec.last_update_login);

Line: 381


  UPDATE bsc_sys_colors_tl
  SET    name = l_Bsc_Color_Rec.name
        ,description = l_Bsc_Color_Rec.description
        ,prototype_label = l_Bsc_Color_Rec.prototype_label
        ,source_lang = userenv('LANG')
        ,last_update_date = l_Bsc_Color_Rec.last_update_date
        ,last_updated_by  = l_user_id
        ,last_update_login= l_login_id
  WHERE color_id= l_Bsc_Color_Rec.color_id
  AND   userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 392


  UPDATE bsc_sys_colors_b
  SET    perf_sequence      = l_Bsc_Color_Rec.perf_sequence
        ,color              = l_Bsc_Color_Rec.color
        ,forecast_color     = l_Bsc_Color_Rec.forecast_color
        ,numeric_equivalent = l_Bsc_Color_Rec.numeric_equivalent
        ,last_update_date   = l_Bsc_Color_Rec.last_update_date
        ,last_updated_by    = l_user_id
        ,last_update_login  = l_login_id
   WHERE color_id= l_Bsc_Color_Rec.color_id;

Line: 420


    SELECT color_id, short_name, name, description, prototype_label, perf_sequence,
           color, user_color, forecast_color, user_forecast_color, numeric_equivalent, user_numeric_equivalent, last_update_date
    FROM   bsc_sys_colors_vl
    WHERE  color_id = p_Bsc_Color_Id;

Line: 426


    SELECT color_id, short_name, name, description, prototype_label, perf_sequence,
           color, user_color, forecast_color, user_forecast_color, numeric_equivalent, user_numeric_equivalent, last_update_date
    FROM   bsc_sys_colors_vl
    WHERE  short_name = p_Bsc_Color_SN;

Line: 457


         ,x_Bsc_Color_Rec.last_update_date;

Line: 478


         ,x_Bsc_Color_Rec.last_update_date;

Line: 510


  SELECT COUNT(1)
  INTO   l_count
  FROM   bsc_sys_colors_b
  WHERE  short_name = p_Bsc_Color_Rec.short_name;