APPS.CSF_GANTT_SETUP_PKG SQL Statements

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

Line: 3

  procedure insert_row
  ( p_seq_id                IN OUT NOCOPY number
  , p_created_by            IN OUT NOCOPY number
  , p_creation_date         IN OUT NOCOPY date
  , p_last_updated_by       IN OUT NOCOPY number
  , p_last_update_date      IN OUT NOCOPY date
  , p_last_update_login     IN OUT NOCOPY number
  , p_object_version_number IN OUT NOCOPY number
  , p_icon_file_name        IN varchar2
  , p_description           IN varchar2
  , P_RANKING               IN number
  , P_ACTIVE                IN VARCHAR2
  )
  is
  begin
    if p_created_by is null then
      p_created_by        := fnd_global.user_id;

Line: 22

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

Line: 26

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

Line: 34

    if p_last_update_date is null then
      p_last_update_date  := sysdate;

Line: 38

    insert into csf_gnticons_setup_b
    ( seq_id
    , created_by
    , creation_date
    , last_updated_by
    , last_update_date
    , last_update_login
    , object_version_number
    , icon_file_name
    , description
    , ranking
    , active
    )
    values
    ( p_seq_id
    , p_created_by
    , p_creation_date
    , p_last_updated_by
    , p_last_update_date
    , p_last_update_login
    , p_object_version_number
    , p_icon_file_name
    , p_description
    , p_ranking
    , p_active
    );

Line: 64

  end insert_row;

Line: 66

  procedure update_row
  ( p_seq_id                IN OUT NOCOPY number
  , p_created_by            IN OUT NOCOPY number
  , p_creation_date         IN OUT NOCOPY date
  , p_last_updated_by       IN OUT NOCOPY number
  , p_last_update_date      IN OUT NOCOPY date
  , p_last_update_login     IN OUT NOCOPY number
  , p_object_version_number IN OUT NOCOPY number
  , p_icon_file_name        IN varchar2
  , p_description           IN varchar2
  , p_RANKING                  IN number
  , p_ACTIVE                   IN VARCHAR2
  )
  is
  begin

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

Line: 86

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

Line: 90

    if p_last_update_date is null then
      p_last_update_date  := sysdate;

Line: 94

    update csf_gnticons_setup_b
    set
        last_updated_by        = p_last_updated_by
    ,   last_update_date       = p_last_update_date
    ,   last_update_login      = p_last_update_login
    ,   object_version_number  = p_object_version_number
    ,   icon_file_name         = p_icon_file_name
    ,   description            = p_description
    ,   ranking                = p_ranking
    ,   active                 = p_active
    where seq_id = p_seq_id;

Line: 110

  end update_row;

Line: 125

    l_update_date           date         ;

Line: 136

    l_update_date             := sysdate;

Line: 140

    update_row
    ( p_seq_id                 => l_seq_id
    , p_created_by             => l_user
    , p_creation_date          => l_update_date
    , p_last_updated_by        => l_user
    , p_last_update_date       => l_update_date
    , p_last_update_login      => l_user
    , p_object_version_number  => l_object_version_number
    , p_icon_file_name         => p_icon_file_name
    , p_description            => p_description
    , p_ranking                => to_number(p_ranking)
    , p_active                 =>  p_active
    );

Line: 155

      insert_row
      ( p_seq_id                 => l_seq_id
      , p_created_by             => l_user
      , p_creation_date          => l_update_date
      , p_last_updated_by        => l_user
      , p_last_update_date       => l_update_date
      , p_last_update_login      => l_user
      , p_object_version_number  => l_object_version_number
      , p_icon_file_name         => p_icon_file_name
      , p_description            => p_description
      , p_ranking                => to_number(p_ranking)
      , p_active                 =>  p_active
      );