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

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

Line: 4


procedure INSERT_ROW (
  X_ROWID                     in out NOCOPY ROWID --File.Sql.39 bug 4440895
 ,X_GANTT_VIEW_ID             in NUMBER
 ,X_GANTT_VIEW_USAGE          in VARCHAR2
 ,X_ENABLE_FLAG               in VARCHAR2
 ,X_SHOW_SUMMARY_ROOT_FLAG    in VARCHAR2
 ,X_SHOW_DEPENDENCIES_FLAG    in VARCHAR2
 ,X_SHOW_SPLIT_TASK_FLAG      in VARCHAR2
 ,X_BAR_HEIGHT                in NUMBER
 ,X_TABLE_BACKGROUND          in NUMBER
 ,X_TABLE_FOREGROUND          in NUMBER
 ,X_CHART_BACKGROUND          in NUMBER
 ,X_COMPARISON_FLAG           in VARCHAR2
 ,X_GANTT_BAR_TEXT_LEFT       in VARCHAR2
 ,X_GANTT_BAR_TEXT_RIGHT      in VARCHAR2
 ,X_GANTT_BAR_TEXT_TOP        in VARCHAR2
 ,X_GANTT_BAR_TEXT_BOTTOM     in VARCHAR2
 ,X_GANTT_BAR_TEXT_INSIDE     in VARCHAR2
 ,X_RECORD_VERSION_NUMBER     in NUMBER
 ,X_ATTRIBUTE_CATEGORY        in VARCHAR2
 ,X_ATTRIBUTE1                in VARCHAR2
 ,X_ATTRIBUTE2                in VARCHAR2
 ,X_ATTRIBUTE3                in VARCHAR2
 ,X_ATTRIBUTE4                in VARCHAR2
 ,X_ATTRIBUTE5                in VARCHAR2
 ,X_ATTRIBUTE6                in VARCHAR2
 ,X_ATTRIBUTE7                in VARCHAR2
 ,X_ATTRIBUTE8                in VARCHAR2
 ,X_ATTRIBUTE9                in VARCHAR2
 ,X_ATTRIBUTE10               in VARCHAR2
 ,X_ATTRIBUTE11               in VARCHAR2
 ,X_ATTRIBUTE12               in VARCHAR2
 ,X_ATTRIBUTE13               in VARCHAR2
 ,X_ATTRIBUTE14               in VARCHAR2
 ,X_ATTRIBUTE15               in VARCHAR2
 ,X_NAME                      in VARCHAR2
 ,X_DESCRIPTION               in VARCHAR2
 ,X_CREATION_DATE             in DATE
 ,X_CREATED_BY                in NUMBER
 ,X_LAST_UPDATE_DATE          in DATE
 ,X_LAST_UPDATED_BY           in NUMBER
 ,X_LAST_UPDATE_LOGIN         in NUMBER
 )
 is

cursor C(c_gantt_view_id pa_gantt_views_b.gantt_view_id%TYPE) is
select ROWID
  from PA_GANTT_VIEWS_B
 where GANTT_VIEW_ID = c_gantt_view_id;

Line: 58


  select nvl(X_GANTT_VIEW_ID,PA_GANTT_VIEWS_B_S.nextval)
  into   l_gantt_view_id
  from   dual;

Line: 62


  insert into PA_GANTT_VIEWS_B (
    GANTT_VIEW_ID,
    GANTT_VIEW_USAGE,
    ENABLE_FLAG,
    SHOW_SUMMARY_ROOT_FLAG,
    SHOW_DEPENDENCIES_FLAG,
    SHOW_SPLIT_TASK_FLAG,
    BAR_HEIGHT,
    TABLE_BACKGROUND,
    TABLE_FOREGROUND,
    CHART_BACKGROUND,
    COMPARISON_FLAG,
    GANTT_BAR_TEXT_LEFT,
    GANTT_BAR_TEXT_RIGHT,
    GANTT_BAR_TEXT_TOP,
    GANTT_BAR_TEXT_BOTTOM,
    GANTT_BAR_TEXT_INSIDE,
    RECORD_VERSION_NUMBER,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values
  (
    l_gantt_view_id,
    X_GANTT_VIEW_USAGE,
    X_ENABLE_FLAG,
    X_SHOW_SUMMARY_ROOT_FLAG,
    X_SHOW_DEPENDENCIES_FLAG,
    X_SHOW_SPLIT_TASK_FLAG,
    X_BAR_HEIGHT,
    X_TABLE_BACKGROUND,
    X_TABLE_FOREGROUND,
    X_CHART_BACKGROUND,
    X_COMPARISON_FLAG,
    X_GANTT_BAR_TEXT_LEFT,
    X_GANTT_BAR_TEXT_RIGHT,
    X_GANTT_BAR_TEXT_TOP,
    X_GANTT_BAR_TEXT_BOTTOM,
    X_GANTT_BAR_TEXT_INSIDE,
    1,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 143


  insert into PA_GANTT_VIEWS_TL (
    GANTT_VIEW_ID,
    NAME,
    DESCRIPTION,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    l_gantt_view_id,
    X_NAME,
    X_DESCRIPTION,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
   (select NULL
    from  PA_GANTT_VIEWS_TL T
    where T.GANTT_VIEW_ID = l_gantt_view_id
    and   T.LANGUAGE = L.LANGUAGE_CODE
   );

Line: 182


end INSERT_ROW;

Line: 222


  cursor c is select
      GANTT_VIEW_USAGE,
      ENABLE_FLAG,
      SHOW_SUMMARY_ROOT_FLAG,
      SHOW_DEPENDENCIES_FLAG,
      SHOW_SPLIT_TASK_FLAG,
      BAR_HEIGHT,
      TABLE_BACKGROUND,
      TABLE_FOREGROUND,
      CHART_BACKGROUND,
      COMPARISON_FLAG,
      GANTT_BAR_TEXT_LEFT,
      GANTT_BAR_TEXT_RIGHT,
      GANTT_BAR_TEXT_TOP,
      GANTT_BAR_TEXT_BOTTOM,
      GANTT_BAR_TEXT_INSIDE,
      RECORD_VERSION_NUMBER,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    from PA_GANTT_VIEWS_B
    where GANTT_VIEW_ID = X_GANTT_VIEW_ID
    for update of GANTT_VIEW_ID nowait;

Line: 260


  cursor c1 is select
      NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from PA_GANTT_VIEWS_TL
    where GANTT_VIEW_ID = X_GANTT_VIEW_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of GANTT_VIEW_ID nowait;

Line: 273


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 355


procedure UPDATE_ROW (
  X_GANTT_VIEW_ID             in NUMBER,
  X_GANTT_VIEW_USAGE          in VARCHAR2,
  X_ENABLE_FLAG               in VARCHAR2,
  X_SHOW_SUMMARY_ROOT_FLAG    in VARCHAR2,
  X_SHOW_DEPENDENCIES_FLAG    in VARCHAR2,
  X_SHOW_SPLIT_TASK_FLAG      in VARCHAR2,
  X_BAR_HEIGHT                in NUMBER,
  X_TABLE_BACKGROUND          in NUMBER,
  X_TABLE_FOREGROUND          in NUMBER,
  X_CHART_BACKGROUND          in NUMBER,
  X_COMPARISON_FLAG           in VARCHAR2,
  X_GANTT_BAR_TEXT_LEFT       in VARCHAR2,
  X_GANTT_BAR_TEXT_RIGHT      in VARCHAR2,
  X_GANTT_BAR_TEXT_TOP        in VARCHAR2,
  X_GANTT_BAR_TEXT_BOTTOM     in VARCHAR2,
  X_GANTT_BAR_TEXT_INSIDE     in VARCHAR2,
  X_RECORD_VERSION_NUMBER     in NUMBER,
  X_ATTRIBUTE_CATEGORY        in VARCHAR2,
  X_ATTRIBUTE1                in VARCHAR2,
  X_ATTRIBUTE2                in VARCHAR2,
  X_ATTRIBUTE3                in VARCHAR2,
  X_ATTRIBUTE4                in VARCHAR2,
  X_ATTRIBUTE5                in VARCHAR2,
  X_ATTRIBUTE6                in VARCHAR2,
  X_ATTRIBUTE7                in VARCHAR2,
  X_ATTRIBUTE8                in VARCHAR2,
  X_ATTRIBUTE9                in VARCHAR2,
  X_ATTRIBUTE10               in VARCHAR2,
  X_ATTRIBUTE11               in VARCHAR2,
  X_ATTRIBUTE12               in VARCHAR2,
  X_ATTRIBUTE13               in VARCHAR2,
  X_ATTRIBUTE14               in VARCHAR2,
  X_ATTRIBUTE15               in VARCHAR2,
  X_NAME                      in VARCHAR2,
  X_DESCRIPTION               in VARCHAR2,
  X_LAST_UPDATE_DATE          in DATE,
  X_LAST_UPDATED_BY           in NUMBER,
  X_LAST_UPDATE_LOGIN         in NUMBER
)
is
begin
  update PA_GANTT_VIEWS_B set
    GANTT_VIEW_USAGE          = X_GANTT_VIEW_USAGE,
    ENABLE_FLAG               = X_ENABLE_FLAG,
    SHOW_SUMMARY_ROOT_FLAG    = X_SHOW_SUMMARY_ROOT_FLAG,
    SHOW_DEPENDENCIES_FLAG    = X_SHOW_DEPENDENCIES_FLAG,
    SHOW_SPLIT_TASK_FLAG      = X_SHOW_SPLIT_TASK_FLAG,
    BAR_HEIGHT                = X_BAR_HEIGHT,
    TABLE_BACKGROUND          = X_TABLE_BACKGROUND,
    TABLE_FOREGROUND          = X_TABLE_FOREGROUND,
    CHART_BACKGROUND          = X_CHART_BACKGROUND,
    COMPARISON_FLAG           = X_COMPARISON_FLAG,
    GANTT_BAR_TEXT_LEFT       = X_GANTT_BAR_TEXT_LEFT,
    GANTT_BAR_TEXT_RIGHT      = X_GANTT_BAR_TEXT_RIGHT,
    GANTT_BAR_TEXT_TOP        = X_GANTT_BAR_TEXT_TOP,
    GANTT_BAR_TEXT_BOTTOM     = X_GANTT_BAR_TEXT_BOTTOM,
    GANTT_BAR_TEXT_INSIDE     = X_GANTT_BAR_TEXT_INSIDE,
    RECORD_VERSION_NUMBER     = nvl(X_RECORD_VERSION_NUMBER,0) + 1,
    ATTRIBUTE_CATEGORY        = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1                = X_ATTRIBUTE1,
    ATTRIBUTE2                = X_ATTRIBUTE2,
    ATTRIBUTE3                = X_ATTRIBUTE3,
    ATTRIBUTE4                = X_ATTRIBUTE4,
    ATTRIBUTE5                = X_ATTRIBUTE5,
    ATTRIBUTE6                = X_ATTRIBUTE6,
    ATTRIBUTE7                = X_ATTRIBUTE7,
    ATTRIBUTE8                = X_ATTRIBUTE8,
    ATTRIBUTE9                = X_ATTRIBUTE9,
    ATTRIBUTE10               = X_ATTRIBUTE10,
    ATTRIBUTE11               = X_ATTRIBUTE11,
    ATTRIBUTE12               = X_ATTRIBUTE12,
    ATTRIBUTE13               = X_ATTRIBUTE13,
    ATTRIBUTE14               = X_ATTRIBUTE14,
    ATTRIBUTE15               = X_ATTRIBUTE15,
    LAST_UPDATE_DATE          = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY           = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN         = X_LAST_UPDATE_LOGIN
  where GANTT_VIEW_ID         = X_GANTT_VIEW_ID;

Line: 439


  update PA_GANTT_VIEWS_TL set
    NAME                 = X_NAME,
    DESCRIPTION          = X_DESCRIPTION,
    LAST_UPDATE_DATE     = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY      = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN    = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG          = userenv('LANG')
  where GANTT_VIEW_ID    = X_GANTT_VIEW_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 452


end UPDATE_ROW;

Line: 454


procedure DELETE_ROW (
  X_GANTT_VIEW_ID        in NUMBER
)
is
begin
  delete from PA_GANTT_VIEWS_TL
  where GANTT_VIEW_ID = X_GANTT_VIEW_ID;

Line: 466


  delete from PA_GANTT_VIEWS_B
  where GANTT_VIEW_ID = X_GANTT_VIEW_ID;

Line: 472


end DELETE_ROW;

Line: 477


  delete from PA_GANTT_VIEWS_TL T
  where not exists
    (select NULL
    from PA_GANTT_VIEWS_B B
    where B.GANTT_VIEW_ID = T.GANTT_VIEW_ID
    );

Line: 484


  update PA_GANTT_VIEWS_TL T set (
      NAME,
      DESCRIPTION
    ) = (select
      B.NAME,
      B.DESCRIPTION
    from PA_GANTT_VIEWS_TL B
    where B.GANTT_VIEW_ID = T.GANTT_VIEW_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.GANTT_VIEW_ID,
      T.LANGUAGE
  ) in (select
      SUBT.GANTT_VIEW_ID,
      SUBT.LANGUAGE
    from PA_GANTT_VIEWS_TL SUBB, PA_GANTT_VIEWS_TL SUBT
    where SUBB.GANTT_VIEW_ID = SUBT.GANTT_VIEW_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 508


  insert into PA_GANTT_VIEWS_TL (
    GANTT_VIEW_ID,
    NAME,
    DESCRIPTION,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.GANTT_VIEW_ID,
    B.NAME,
    B.DESCRIPTION,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from PA_GANTT_VIEWS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from PA_GANTT_VIEWS_TL T
    where T.GANTT_VIEW_ID = B.GANTT_VIEW_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 555


        update PA_GANTT_VIEWS_TL
          set
           LAST_UPDATE_DATE      = SYSDATE,
           LAST_UPDATED_BY       = l_user_id,
           LAST_UPDATE_LOGIN     = 0,
           name                  = X_NAME,
           description           = X_DESCRIPTION,
           source_lang           = userenv('LANG')
       	where  GANTT_VIEW_ID   = X_GANTT_VIEW_ID
             and USERENV('LANG') IN ( LANGUAGE , SOURCE_LANG );

Line: 621


     PA_GANTT_VIEWS_PKG.UPDATE_ROW (
             X_GANTT_VIEW_ID             =>  X_GANTT_VIEW_ID
            ,X_GANTT_VIEW_USAGE          =>  X_GANTT_VIEW_USAGE
            ,X_ENABLE_FLAG               =>  X_ENABLE_FLAG
            ,X_SHOW_SUMMARY_ROOT_FLAG    =>  X_SHOW_SUMMARY_ROOT_FLAG
            ,X_SHOW_DEPENDENCIES_FLAG    =>  X_SHOW_DEPENDENCIES_FLAG
            ,X_SHOW_SPLIT_TASK_FLAG      =>  X_SHOW_SPLIT_TASK_FLAG
            ,X_BAR_HEIGHT                =>  X_BAR_HEIGHT
            ,X_TABLE_BACKGROUND          =>  X_TABLE_BACKGROUND
            ,X_TABLE_FOREGROUND          =>  X_TABLE_FOREGROUND
            ,X_CHART_BACKGROUND          =>  X_CHART_BACKGROUND
            ,X_COMPARISON_FLAG           =>  X_COMPARISON_FLAG
            ,X_GANTT_BAR_TEXT_LEFT       =>  X_GANTT_BAR_TEXT_LEFT
            ,X_GANTT_BAR_TEXT_RIGHT      =>  X_GANTT_BAR_TEXT_RIGHT
            ,X_GANTT_BAR_TEXT_TOP        =>  X_GANTT_BAR_TEXT_TOP
            ,X_GANTT_BAR_TEXT_BOTTOM     =>  X_GANTT_BAR_TEXT_BOTTOM
            ,X_GANTT_BAR_TEXT_INSIDE     =>  X_GANTT_BAR_TEXT_INSIDE
            ,X_RECORD_VERSION_NUMBER     =>  X_RECORD_VERSION_NUMBER
            ,X_ATTRIBUTE_CATEGORY        =>  X_ATTRIBUTE_CATEGORY
            ,X_ATTRIBUTE1                =>  X_ATTRIBUTE1
            ,X_ATTRIBUTE2                =>  X_ATTRIBUTE2
            ,X_ATTRIBUTE3                =>  X_ATTRIBUTE3
            ,X_ATTRIBUTE4                =>  X_ATTRIBUTE4
            ,X_ATTRIBUTE5                =>  X_ATTRIBUTE5
            ,X_ATTRIBUTE6                =>  X_ATTRIBUTE6
            ,X_ATTRIBUTE7                =>  X_ATTRIBUTE7
            ,X_ATTRIBUTE8                =>  X_ATTRIBUTE8
            ,X_ATTRIBUTE9                =>  X_ATTRIBUTE9
            ,X_ATTRIBUTE10               =>  X_ATTRIBUTE10
            ,X_ATTRIBUTE11               =>  X_ATTRIBUTE11
            ,X_ATTRIBUTE12               =>  X_ATTRIBUTE12
            ,X_ATTRIBUTE13               =>  X_ATTRIBUTE13
            ,X_ATTRIBUTE14               =>  X_ATTRIBUTE14
            ,X_ATTRIBUTE15               =>  X_ATTRIBUTE15
            ,X_NAME                      =>  X_NAME
            ,X_DESCRIPTION               =>  X_DESCRIPTION
            ,X_LAST_UPDATE_DATE          =>  sysdate
            ,X_LAST_UPDATED_BY           =>  l_user_id
            ,X_LAST_UPDATE_LOGIN         =>  0
     );

Line: 663


          PA_GANTT_VIEWS_PKG.INSERT_ROW (
                 X_ROWID                     =>  l_rowid
                ,X_GANTT_VIEW_ID             =>  X_GANTT_VIEW_ID
                ,X_GANTT_VIEW_USAGE          =>  X_GANTT_VIEW_USAGE
                ,X_ENABLE_FLAG               =>  X_ENABLE_FLAG
                ,X_SHOW_SUMMARY_ROOT_FLAG    =>  X_SHOW_SUMMARY_ROOT_FLAG
                ,X_SHOW_DEPENDENCIES_FLAG    =>  X_SHOW_DEPENDENCIES_FLAG
                ,X_SHOW_SPLIT_TASK_FLAG      =>  X_SHOW_SPLIT_TASK_FLAG
                ,X_BAR_HEIGHT                =>  X_BAR_HEIGHT
                ,X_TABLE_BACKGROUND          =>  X_TABLE_BACKGROUND
                ,X_TABLE_FOREGROUND          =>  X_TABLE_FOREGROUND
                ,X_CHART_BACKGROUND          =>  X_CHART_BACKGROUND
                ,X_COMPARISON_FLAG           =>  X_COMPARISON_FLAG
                ,X_GANTT_BAR_TEXT_LEFT       =>  X_GANTT_BAR_TEXT_LEFT
                ,X_GANTT_BAR_TEXT_RIGHT      =>  X_GANTT_BAR_TEXT_RIGHT
                ,X_GANTT_BAR_TEXT_TOP        =>  X_GANTT_BAR_TEXT_TOP
                ,X_GANTT_BAR_TEXT_BOTTOM     =>  X_GANTT_BAR_TEXT_BOTTOM
                ,X_GANTT_BAR_TEXT_INSIDE     =>  X_GANTT_BAR_TEXT_INSIDE
                ,X_RECORD_VERSION_NUMBER     =>  X_RECORD_VERSION_NUMBER
                ,X_ATTRIBUTE_CATEGORY        =>  X_ATTRIBUTE_CATEGORY
                ,X_ATTRIBUTE1                =>  X_ATTRIBUTE1
                ,X_ATTRIBUTE2                =>  X_ATTRIBUTE2
                ,X_ATTRIBUTE3                =>  X_ATTRIBUTE3
                ,X_ATTRIBUTE4                =>  X_ATTRIBUTE4
                ,X_ATTRIBUTE5                =>  X_ATTRIBUTE5
                ,X_ATTRIBUTE6                =>  X_ATTRIBUTE6
                ,X_ATTRIBUTE7                =>  X_ATTRIBUTE7
                ,X_ATTRIBUTE8                =>  X_ATTRIBUTE8
                ,X_ATTRIBUTE9                =>  X_ATTRIBUTE9
                ,X_ATTRIBUTE10               =>  X_ATTRIBUTE10
                ,X_ATTRIBUTE11               =>  X_ATTRIBUTE11
                ,X_ATTRIBUTE12               =>  X_ATTRIBUTE12
                ,X_ATTRIBUTE13               =>  X_ATTRIBUTE13
                ,X_ATTRIBUTE14               =>  X_ATTRIBUTE14
                ,X_ATTRIBUTE15               =>  X_ATTRIBUTE15
                ,X_NAME                      =>  X_NAME
                ,X_DESCRIPTION               =>  X_DESCRIPTION
                ,X_CREATION_DATE             =>  sysdate
                ,X_CREATED_BY                =>  l_user_id
                ,X_LAST_UPDATE_DATE          =>  sysdate
                ,X_LAST_UPDATED_BY           =>  l_user_id
                ,X_LAST_UPDATE_LOGIN         =>  0
          );