APPS.CSF_GANTT_ICONS_PVT SQL Statements

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

Line: 3

  procedure update_row
  ( p_seq_id                IN OUT NOCOPY number
  , p_object_version_number IN OUT NOCOPY number
  , p_RANKING               IN number
  , p_ACTIVE                IN VARCHAR2
  , p_last_updated_by       IN  number
  , p_last_update_date      IN   date
  , p_last_update_login     IN   number
  )
  is
    l_last_updated_by   number;

Line: 14

  l_last_update_date        date;

Line: 15

  l_last_update_login       number	;

Line: 18

    if p_last_updated_by is null then
      l_last_updated_by   := fnd_global.user_id;

Line: 22

    if p_last_update_login is null then
      l_last_update_login := fnd_global.login_id;

Line: 26

    if p_last_update_date is null then
      l_last_update_date  := sysdate;

Line: 30

    update csf_gnticons_setup_b
    set
        last_updated_by        = l_last_updated_by
    ,   last_update_date       = l_last_update_date
    ,   last_update_login      = l_last_update_login
    ,   object_version_number  = object_version_number + 1
    ,   ranking                = p_ranking
    ,   active                 = p_active
    where seq_id = p_seq_id;

Line: 44

  end update_row;