APPS.FND_APPTREE SQL Statements

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

Line: 14

    select obj_name, node_label, folder_type,
           value, sequence, parent_folder_id, created_by, public_flag
    from   fnd_tree_folders
    where  folder_id = l_folder_id;

Line: 28

FUNCTION insert_folder(l_obj_name         VARCHAR2,
                       l_node_label       VARCHAR2,
                       l_folder_type      VARCHAR2,
                       l_value            VARCHAR2,
                       l_parent_folder_id NUMBER,
                       l_public_flag      VARCHAR2,
                       l_language         VARCHAR2,
                       l_user_id          NUMBER,
                       after_folder_id    NUMBER default null) RETURN NUMBER IS
  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 42

      select max(sequence)
      from   fnd_tree_folders
      where  created_by = l_user_id
      and    parent_folder_id is null
      and    obj_name = l_obj_name;

Line: 48

      select max(sequence)
      from   fnd_tree_folders
      where  parent_folder_id = l_parent_folder_id;

Line: 52

      select sequence
      from   fnd_tree_folders
      where  folder_id = after_folder_id;

Line: 56

      select min(sequence)
      from   fnd_tree_folders
      where  created_by = l_user_id
      and    parent_folder_id is null
      and    obj_name = l_obj_name
      and    sequence > l_after_seq;

Line: 63

      select min(sequence)
      from   fnd_tree_folders
      where  parent_folder_id = l_parent_folder_id
      and    sequence > l_after_seq;

Line: 68

    select fnd_tree_folders_s.nextval
    from dual;

Line: 135

  insert into fnd_tree_folders(
    folder_id,
    obj_name,
    node_label,
    folder_type,
    value,
    sequence,
    parent_folder_id,
    public_flag,
    language,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by)
  values (
    l_folder_id,
    l_obj_name,
    l_node_label,
    l_folder_type,
    l_value,
    l_next_seq,
    l_parent_folder_id,
    l_public_flag,
    l_language,
    sysdate,
    l_user_id,
    sysdate,
    l_user_id);

Line: 168

END insert_folder;

Line: 170

PROCEDURE update_folder (l_folder_id        number,
                         l_user_id          number,
                         l_obj_name         varchar2 default 'APPTREE_NULL',
                         l_node_label       VARCHAR2 default 'APPTREE_NULL',
                         l_folder_type      VARCHAR2 default 'APPTREE_NULL',
                         l_value            VARCHAR2 default 'APPTREE_NULL',
                         l_sequence         NUMBER   default -99,
                         l_parent_folder_id NUMBER   default -99,
                         l_public_flag      VARCHAR2 default 'APPTREE_NULL',
                         l_language         VARCHAR2 default 'APPTREE_NULL') IS
  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 182

  update fnd_tree_folders
  set
    obj_name         = decode(l_obj_name,         'APPTREE_NULL', obj_name,         l_obj_name),
    node_label       = decode(l_node_label,       'APPTREE_NULL', node_label,       l_node_label),
    folder_type      = decode(l_folder_type,      'APPTREE_NULL', folder_type,      l_folder_type),
    value            = decode(l_value,            'APPTREE_NULL', value,            l_value),
    sequence         = decode(l_sequence,         -99,            sequence,         l_sequence),
    parent_folder_id = decode(l_parent_folder_id, -99,            parent_folder_id, l_parent_folder_id),
    public_flag      = decode(l_public_flag,      'APPTREE_NULL', public_flag,      l_public_flag),
    language         = decode(l_language,         'APPTREE_NULL', language,         l_language),
    last_update_date = sysdate,
    last_updated_by = l_user_id
  where
    folder_id = l_folder_id;

Line: 197

END update_folder;

Line: 204

    select '1'
    from fnd_tree_folders
    where  ((l_parent_folder_id is null and parent_folder_id is null)
           or (l_parent_folder_id is not null and parent_folder_id = l_parent_folder_id))
    and    obj_name = l_obj_name
    and    created_by = l_user_id
    and    folder_type IN ('Q', 'F')
    and    node_label = requested_folder_name;

Line: 224

PROCEDURE delete_folder(l_folder_id number) is
  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 227

  delete
  from fnd_tree_folders f
  where f.folder_id in
    (select h.folder_id
     from fnd_tree_folders h
     start with h.folder_id = l_folder_id
     connect by prior h.folder_id = h.parent_folder_id);

Line: 236

END delete_folder;

Line: 247

      select max(sequence)
      from   fnd_tree_folders
      where  created_by = l_user_id
      and    parent_folder_id is null
      and    obj_name = l_obj_name;

Line: 253

      select max(sequence)
      from   fnd_tree_folders
      where  parent_folder_id = l_parent_folder_id;

Line: 257

      select sequence
      from   fnd_tree_folders
      where  folder_id = after_folder_id;

Line: 261

      select min(sequence)
      from   fnd_tree_folders
      where  created_by = l_user_id
      and    parent_folder_id is null
      and    obj_name = l_obj_name
      and    sequence > l_after_seq;

Line: 268

      select min(sequence)
      from   fnd_tree_folders
      where  parent_folder_id = l_parent_folder_id
      and    sequence > l_after_seq;

Line: 331

  UPDATE fnd_tree_folders
    SET parent_folder_id = l_parent_folder_id
       ,sequence = l_next_seq
       ,last_update_date = sysdate
       ,last_updated_by  = l_user_id
  WHERE folder_id = l_folder_id;