APPS.PQH_GENERIC_HIERARCHY_PACKAGE SQL Statements

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

Line: 21

Select '1'
from   FND_DESCR_FLEX_CONTEXTS_VL
where  GLOBAL_FLAG = 'N'
AND    APPLICATION_ID = 800
AND    DESCRIPTIVE_FLEXFIELD_NAME = p_flexfield_name
AND    DESCRIPTIVE_FLEX_CONTEXT_CODE = p_type
AND    ENABLED_FLAG = 'Y';

Line: 75

Select '1'
from
per_gen_hier_node_types
Where
    ( parent_node_type = p_node_type
      Or
      parent_node_type is null and p_node_type is null)
and hierarchy_type   = p_hierarchy_type;

Line: 186

Select hier_node_type_id
From   per_gen_hier_node_types
Where  hierarchy_type   = p_hierarchy_type
And    ( parent_node_type = p_parent_node_type
         Or
        (parent_node_type is null and p_parent_node_type is null)
        )
And    child_node_type  = p_child_node_type;

Line: 265

Select Node_Type
From   per_gen_hierarchy_nodes
Where  hierarchy_node_id = p_hierarchy_node_id;

Line: 302

Select ghr.type
from
per_gen_hierarchy ghr,
per_gen_hierarchy_versions gvr,
per_gen_hierarchy_nodes gnd
where
    gnd.hierarchy_node_id    = p_hierarchy_node_id
and gnd.hierarchy_version_id = gvr.hierarchy_version_id
and gvr.hierarchy_id         = ghr.hierarchy_id;

Line: 349

Select FLEX_VALUE_SET_ID
From   FND_FLEX_VALUE_SETS
Where  validation_type         = 'F'
And
FLEX_VALUE_SET_NAME    = p_value_set_name;

Line: 357

Select CHILD_VALUE_SET
from   per_gen_hier_node_types
where  CHILD_NODE_TYPE           = p_child_node_type
and    ( (PARENT_NODE_TYPE  = p_parent_node_type)
        Or
         (PARENT_NODE_TYPE is null And p_parent_node_type is null) )
and    HIERARCHY_TYPE            = p_hierarchy_type;

Line: 436

  l_str := rtrim('select '||l_v_r.table_info.id_column_name    ||' Entityid, '
                          ||l_v_r.table_info.value_column_name ||' Nodename from '
                          ||l_v_r.table_info.table_name        ||' '||l_whr);

Line: 465

Select 'x'
From Per_Gen_Hier_Node_Types
Where Hierarchy_Type = p_hierarchy_type;

Line: 502

select '1'
from
per_gen_hierarchy_versions
Where
hierarchy_id = p_hierarchy_id
and p_effective_date between date_from and nvl(date_to,p_effective_date);

Line: 639

  select 'x' from HR_LOOKUPS
  where lookup_type = p_lookup_type
  and lookup_code = p_lookup_code;

Line: 647

  select 'x' from HR_LOOKUPS
  where lookup_type = p_lookup_type
  and meaning = p_meaning;

Line: 736

    fnd_lookup_values_pkg.INSERT_ROW(X_ROWID                => l_rowid,
                                     X_SECURITY_GROUP_ID    => 0,
                                     X_LOOKUP_TYPE          => p_lookup_type,
                                     X_VIEW_APPLICATION_ID  => 3,
                                     X_LOOKUP_CODE          => l_lookup_code,
                                     X_TAG                  => null,
                                     X_ATTRIBUTE_CATEGORY   => null,
                                     X_ATTRIBUTE1           => null,
                                     X_ATTRIBUTE2           => null,
                                     X_ATTRIBUTE3           => null,
                                     X_ATTRIBUTE4           => null,
                                     X_ENABLED_FLAG         => 'Y',
                                     X_START_DATE_ACTIVE    => null,
                                     X_END_DATE_ACTIVE      => null,
                                     X_TERRITORY_CODE       => null,
                                     X_ATTRIBUTE5           => null,
                                     X_ATTRIBUTE6           => null,
                                     X_ATTRIBUTE7           => null,
                                     X_ATTRIBUTE8           => null,
                                     X_ATTRIBUTE9           => null,
                                     X_ATTRIBUTE10          => null,
                                     X_ATTRIBUTE11          => null,
                                     X_ATTRIBUTE12          => null,
                                     X_ATTRIBUTE13          => null,
                                     X_ATTRIBUTE14          => null,
                                     X_ATTRIBUTE15          => null,
                                     X_MEANING              => p_meaning,
                                     X_DESCRIPTION          => p_description,
                                     X_CREATION_DATE        => SYSDATE ,
                                     X_CREATED_BY           => fnd_global.user_id,
                                     X_LAST_UPDATED_BY      => fnd_global.user_id,
                                     X_LAST_UPDATE_DATE     => SYSDATE,
                                     X_LAST_UPDATE_LOGIN    => fnd_global.login_id);

Line: 809

Procedure update_lookup_value
  ( p_lookup_type                   in     varchar2
   ,p_lookup_code                   in     varchar2
   ,p_meaning                       in     varchar2
   ,p_description                   in     varchar2
  ) IS
--
-- Declare Cursors and local variables
--
  l_proc                   varchar2(80);

Line: 825

     l_proc := g_package||'update_lookup_value';

Line: 829

  fnd_lookup_values_pkg.UPDATE_ROW(X_LOOKUP_TYPE          => p_lookup_type,
                                   X_SECURITY_GROUP_ID    => 0,
                                   X_VIEW_APPLICATION_ID  => 3,
                                   X_LOOKUP_CODE          => p_lookup_code,
                                   X_TAG                  => null,
                                   X_ATTRIBUTE_CATEGORY   => null,
                                   X_ATTRIBUTE1           => null,
                                   X_ATTRIBUTE2           => null,
                                   X_ATTRIBUTE3           => null,
                                   X_ATTRIBUTE4           => null,
                                   X_ENABLED_FLAG         => 'Y',
                                   X_START_DATE_ACTIVE    => null,
                                   X_END_DATE_ACTIVE      => null,
                                   X_TERRITORY_CODE       => null,
                                   X_ATTRIBUTE5           => null,
                                   X_ATTRIBUTE6           => null,
                                   X_ATTRIBUTE7           => null,
                                   X_ATTRIBUTE8           => null,
                                   X_ATTRIBUTE9           => null,
                                   X_ATTRIBUTE10          => null,
                                   X_ATTRIBUTE11          => null,
                                   X_ATTRIBUTE12          => null,
                                   X_ATTRIBUTE13          => null,
                                   X_ATTRIBUTE14          => null,
                                   X_ATTRIBUTE15          => null,
                                   X_MEANING              => p_meaning,
                                   X_DESCRIPTION          => p_description,
                                   X_LAST_UPDATE_DATE     => SYSDATE,
                                   X_LAST_UPDATED_BY      => fnd_global.user_id,
                                   X_LAST_UPDATE_LOGIN    => fnd_global.login_id);

Line: 865

end update_lookup_value;

Line: 883

  select 'x' from PER_SHARED_TYPES
  where lookup_type = 'HIERARCHY_TYPE'
  and system_type_cd   = p_lookup_code
  and shared_type_code = p_lookup_code;

Line: 986

Procedure update_shared_type
   (p_lookup_code                   in     varchar2,
    p_information2		    in	   varchar2,
    p_information3		    in	   varchar2
  ) IS
--
-- Declare Cursors and local variables
--
--
-- Check if the lookup exists already
--
  CURSOR csr_shared_type_entry IS
  select shared_type_id, object_version_number
  from PER_SHARED_TYPES
  where lookup_type = 'HIERARCHY_TYPE'
  and system_type_cd   = p_lookup_code
  and shared_type_code = p_lookup_code;

Line: 1013

   l_proc := g_package||'update_shared_type';

Line: 1019

  savepoint update_shared_type;

Line: 1050

       per_shared_types_api.update_shared_type
       ( p_shared_type_id        =>  l_shared_type_id
        ,p_language_code         =>  userenv('LANG')
        ,p_information2		 =>  p_information2
        ,p_information3		 =>  p_information3
        ,p_object_version_number =>  l_object_version_number
        ,p_effective_date        =>   sysdate
        );

Line: 1068

    rollback to update_shared_type;

Line: 1073

end update_shared_type;

Line: 1087

Select '1'
from per_gen_hier_node_types
where
hierarchy_type = p_hierarchy_type
and ( (parent_node_type = p_parent_node_type)
     or
      (parent_node_type is null and p_parent_node_type is null))
and child_node_type = p_child_node_type;

Line: 1099

Select Parent_node_type
From per_gen_hier_node_types
Start with child_node_type = p_parent_node_type
And hierarchy_type = p_hierarchy_type
Connect by child_node_type = prior parent_node_type
And hierarchy_type = p_hierarchy_type;

Line: 1109

select per_gen_hier_node_types_s.nextval
from sys.dual;

Line: 1114

select '1'
from per_gen_hier_node_types
     where hier_node_type_id = p_next_id_val;

Line: 1179

 l_sql := 'Insert into per_gen_hier_node_types
                 (hierarchy_type,
                  parent_node_type,
                  child_node_type,
                  child_value_set,
                  hier_node_type_id,
                  object_version_number)
          Values (
                  :p_hierarchy_type    ,
                  :p_parent_node_type  ,
                  :p_child_node_type   ,
                  :p_child_value_set   ,
                  per_gen_hier_node_types_s.nextval ,
                  1 )';

Line: 1217

Procedure update_node_type (p_hierarchy_type   in varchar2,
                            p_child_value_set  in varchar2,
                            p_child_node_type  in varchar2,
                            p_parent_node_type in varchar2 ,
                            p_object_version_number in out NOCOPY number)
is
--

Cursor csr_node_type_entry
is
Select object_version_number
From
per_gen_hier_node_types
Where
hierarchy_type = p_hierarchy_type
And ( (parent_node_type = p_parent_node_type)
      Or
      (parent_node_type is null and p_parent_node_type is null))
And child_node_type = p_child_node_type
For update nowait;

Line: 1247

 l_proc := g_package||'update_node_type';

Line: 1253

  Savepoint update_node_type;

Line: 1293

  l_sql := 'Update per_gen_hier_node_types
            Set child_value_set = :p_child_value_set,
                object_version_number = :p_object_version_number
            Where hierarchy_type = :p_hierarchy_type
            and   ( (parent_node_type = :p_parent_node_type)
                     Or
                    (parent_node_type is null and :p_parent_node_type is null))
            and child_node_type = :p_child_node_type';

Line: 1332

 rollback to update_node_type;

Line: 1334

end update_node_type;

Line: 1341

Procedure delete_node_type (p_hierarchy_type   in varchar2,
                            p_child_node_type  in varchar2,
                            p_parent_node_type in varchar2)
is
--
Cursor csr_node_type_entry
is
Select object_version_number
From
per_gen_hier_node_types
Where
hierarchy_type = p_hierarchy_type
And ( (parent_node_type = p_parent_node_type)
      Or
      (parent_node_type is null and p_parent_node_type is null))
And child_node_type = p_child_node_type
For update nowait;

Line: 1361

Select child_node_type,parent_node_type
from per_gen_hier_node_types
start with hierarchy_type = p_hierarchy_type
and ( (parent_node_type = p_parent_node_type)
      Or
	  (parent_node_type is null And p_parent_node_type is null))
and child_node_type = p_child_node_type
Connect by
prior child_node_type = parent_node_type
and ((prior child_node_type <> prior parent_node_type) or(prior child_node_type is not null and prior parent_node_type is null))
and hierarchy_type  = p_hierarchy_type
order by level desc;

Line: 1383

 l_proc := g_package||'delete_node_type';

Line: 1389

  Savepoint delete_node_type;

Line: 1418

  l_sql := 'Delete from per_gen_hier_node_types
            Where
            hierarchy_type = :p_hierarchy_type
            And ( (parent_node_type = :p_parent_node_type)
                  Or
                  (parent_node_type is null and :p_parent_node_type is null))
            And child_node_type = :p_child_node_type';

Line: 1436

    hr_utility.set_location('Deleted a Row, Trying another...', 40);

Line: 1457

 rollback to delete_node_type;

Line: 1459

End delete_node_type;

Line: 1467

Procedure delete_type_structure (p_hierarchy_type   in varchar2)
Is
--
Cursor csr_top_node_types
is
Select child_node_type
From
per_gen_hier_node_types
where
hierarchy_type = p_hierarchy_type
and parent_node_type is null;

Line: 1485

 l_proc := g_package||'delete_type_structure';

Line: 1495

 Savepoint delete_type_structure;

Line: 1505

    delete_node_type(p_hierarchy_type   => p_hierarchy_type,
                     p_parent_node_type => null,
                     p_child_node_type  => c_rec.child_node_type);

Line: 1509

     hr_utility.set_location('Deleted a row.Trying another..', 20);

Line: 1523

 Rollback to delete_type_structure;

Line: 1525

End delete_type_structure;

Line: 1560

 Select Type,     ATTRIBUTE_CATEGORY, ATTRIBUTE1   , ATTRIBUTE2   , ATTRIBUTE3   , ATTRIBUTE4   ,
ATTRIBUTE5   , ATTRIBUTE6   , ATTRIBUTE7   , ATTRIBUTE8   ,
        ATTRIBUTE9   , ATTRIBUTE10  , ATTRIBUTE11  , ATTRIBUTE12  , ATTRIBUTE13  , ATTRIBUTE14  ,
ATTRIBUTE15  , ATTRIBUTE16  , ATTRIBUTE17  , ATTRIBUTE18  ,
        ATTRIBUTE19  , ATTRIBUTE20  , ATTRIBUTE21  , ATTRIBUTE22  , ATTRIBUTE23  , ATTRIBUTE24  ,
ATTRIBUTE25  , ATTRIBUTE26  , ATTRIBUTE27  , ATTRIBUTE28  ,
        ATTRIBUTE29  , ATTRIBUTE30  , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 ,
INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
        INFORMATION9 , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14,
INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
        INFORMATION19, INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24,
INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
        INFORMATION29, INFORMATION30, INFORMATION_CATEGORY
   From Per_Gen_Hierarchy
  Where Hierarchy_id = P_Hierarchy_Id;

Line: 1577

 Select Hierarchy_Version_id, VERSION_NUMBER, HIERARCHY_ID , DATE_FROM    , DATE_TO      , STATUS
      , VALIDATE_FLAG, ATTRIBUTE_CATEGORY,
        ATTRIBUTE1    , ATTRIBUTE2   , ATTRIBUTE3   , ATTRIBUTE4   , ATTRIBUTE5   , ATTRIBUTE6   , ATTRIBUTE7   , ATTRIBUTE8   ,
        ATTRIBUTE9    , ATTRIBUTE10  , ATTRIBUTE11  , ATTRIBUTE12  , ATTRIBUTE13  , ATTRIBUTE14  , ATTRIBUTE15  , ATTRIBUTE16  , ATTRIBUTE17  , ATTRIBUTE18  ,
        ATTRIBUTE19   , ATTRIBUTE20  , ATTRIBUTE21  , ATTRIBUTE22  , ATTRIBUTE23  , ATTRIBUTE24  , ATTRIBUTE25  , ATTRIBUTE26  , ATTRIBUTE27  , ATTRIBUTE28  ,
        ATTRIBUTE29   , ATTRIBUTE30  , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 , INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
        INFORMATION9  , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
        INFORMATION19 , INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24, INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
        INFORMATION29 , INFORMATION30, INFORMATION_CATEGORY
   From Per_Gen_Hierarchy_Versions
  Where ((P_Hierarchy_Version_Id is not NULL and Hierarchy_Version_Id = p_Hierarchy_Version_Id)
   or (Hierarchy_Id = P_Hierarchy_Id and  P_Effective_Date between Date_From and Nvl(Date_To,p_Effective_Date)));

Line: 1591

  Select Hierarchy_Node_id
    From Per_Gen_Hierarchy_Nodes
   Where Hierarchy_Version_id = C_Hierarchy_version_id
     and Parent_Hierarchy_Node_Id is NULL;

Line: 1825

  l_sql := 'select ''Y'' from ('||p_sql||') where rownum < 1';

Line: 1856

Select level, node_type
From   Per_Gen_Hierarchy_Nodes
Where  hierarchy_version_id = p_hierarchy_version_id
Start   With parent_hierarchy_node_id is null
Connect By   prior hierarchy_node_id = parent_hierarchy_node_id;

Line: 1911

   SELECT flex_value_set_id
   FROM   fnd_flex_value_sets
   WHERE  validation_type      = 'F'
   AND    flex_value_set_name  = (SELECT pgt.child_value_set
                                  FROM per_gen_hier_node_types pgt
                                  WHERE pgt.hier_node_type_id = p_node_type_id);

Line: 1941

    l_str := 'select '||substr(l_v_r.table_info.id_column_name,1,instr(l_v_r.table_info.id_column_name||' ',' '))||','
                      ||substr(l_v_r.table_info.value_column_name,1,instr(l_v_r.table_info.value_column_name||' ',' '))
                      ||' from '
                      ||l_v_r.table_info.table_name||' '||l_whr;

Line: 1983

    l_id_column := SUBSTR(l_UPPER_SQL_statement,(INSTR(l_UPPER_SQL_statement,'SELECT')
                     +7) ,INSTR(l_UPPER_SQL_statement,',') -
                         (INSTR(l_UPPER_SQL_statement,'SELECT')+ 7));

Line: 2054

  select 'Y'
  from per_gen_hierarchy
  where type = p_hierarchy_type
  and rownum = 1;

Line: 2091

Select 'Y'
From  per_gen_hierarchy_versions
Where hierarchy_id = p_hierarchy_id
And   rownum < 3;

Line: 2126

Select Nvl(max(SEQ),0) + 1
  From Per_gen_Hierarchy_Nodes
 Where Hierarchy_Version_Id     = p_Hierarchy_Version_id
   and Parent_Hierarchy_Node_Id = P_Parent_Hierarchy_Id;

Line: 2162

 Select Hierarchy_Node_id, Object_version_number
   From Per_gen_Hierarchy_Nodes a
  Start with Hierarchy_Node_Id        = P_Hierarchy_Id
 Connect  by Parent_Hierarchy_Node_Id = Prior Hierarchy_Node_id
 Order By Nvl(Parent_Hierarchy_Node_Id,0) Desc;

Line: 2169

 Select Pgh.Hierarchy_id, pgh.Object_version_number hovn,
        pgv.Hierarchy_version_id, pgv.Object_Version_number vovn
   From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh
  Where Hierarchy_Version_id = P_Hierarchy_version_id
    and pgv.Hierarchy_id = pgh.Hierarchy_id;

Line: 2176

 Select Hierarchy_Node_Id, Object_Version_Number
   From Per_Gen_Hierarchy_Nodes
  Start With Hierarchy_Version_id = P_Hierarchy_Version_id
    and Parent_hierarchy_node_id is NULL
Connect By Parent_hierarchy_Node_id = Prior Hierarchy_Node_id
  Order By Nvl(Parent_Hierarchy_Node_id,0) Desc;

Line: 2184

Select count(*)
  From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh
 Where pgh.Hierarchy_id = (Select Hierarchy_id
                           From   Per_Gen_Hierarchy_Versions
                           Where Hierarchy_Version_Id = P_Hierarchy_Version_Id)
   and pgv.hierarchy_id = pgh.hierarchy_id;

Line: 2226

         Per_Hierarchy_Nodes_api.DELETE_HIERARCHY_NODES
        (P_Hierarchy_Node_Id      => C3rec.Hierarchy_Node_id,
         P_Object_Version_Number  => l_Object_Version_Number);

Line: 2232

       Per_Hierarchy_versions_api.DELETE_HIERARCHY_VERSIONS
       (P_HIERARCHY_VERSION_ID   => C2rec.Hierarchy_version_id,
        P_OBJECT_VERSION_NUMBER  => l_Object_version_Number,
        P_EFFECTIVE_DATE         => P_Effective_Date);

Line: 2239

         Per_Hierarchy_api.Delete_Hierarchy
         (P_Hierarchy_Id          => C2rec.Hierarchy_id,
          P_Object_Version_Number => l_Object_Version_Number);

Line: 2247

    PQH_DE_OPERATION_GROUPS_API.INSERT_OPERATION_GROUPS
   (P_EFFECTIVE_DATE            => P_EFFECTIVE_DATE,
    P_OPERATION_GROUP_CODE      => P_Code,
    P_DESCRIPTION               => P_Description,
    P_BUSINESS_GROUP_ID         => P_BUSINESS_GROUP_ID,
    P_OPERATION_GROUP_ID        => l_Node_id,
    P_OBJECT_VERSION_NUMBER     => l_Object_version_Number);

Line: 2269

   PQH_DE_OPERATIONS_API.INSERT_OPERATIONS
    (P_EFFECTIVE_DATE           => P_EFFECTIVE_DATE,
     P_OPERATION_NUMBER         => P_Code,
     P_DESCRIPTION              => P_Description,
     P_OPERATION_ID             => L_Node_id,
     P_OBJECT_VERSION_NUMBER    => l_Object_version_Number);

Line: 2290

    PQH_DE_TKTDTLS_API.INSERT_TKT_DTLS
    (P_EFFECTIVE_DATE           => P_EFFECTIVE_DATE,
     P_TATIGKEIT_NUMBER         => P_Code,
     P_DESCRIPTION              => P_Description,
     P_TATIGKEIT_DETAIL_ID      => L_Node_id,
     P_OBJECT_VERSION_NUMBER    => l_Object_version_Number);

Line: 2328

      Per_Hierarchy_Nodes_Api.DELETE_HIERARCHY_NODES
      (P_HIERARCHY_NODE_ID      =>  C1rec.Hierarchy_Node_Id,
       P_OBJECT_VERSION_NUMBER  =>  l_Object_Version_Number);

Line: 2345

 Select Node_Type     , Entity_Id    , Hierarchy_Node_id           , Parent_Hierarchy_Node_Id    , Hierarchy_Version_Id        , ATTRIBUTE_CATEGORY,
        ATTRIBUTE1    , ATTRIBUTE2   , ATTRIBUTE3   , ATTRIBUTE4   , ATTRIBUTE5   , ATTRIBUTE6   , ATTRIBUTE7   , ATTRIBUTE8   ,
        ATTRIBUTE9    , ATTRIBUTE10  , ATTRIBUTE11  , ATTRIBUTE12  , ATTRIBUTE13  , ATTRIBUTE14  , ATTRIBUTE15  , ATTRIBUTE16  , ATTRIBUTE17  , ATTRIBUTE18  ,
        ATTRIBUTE19   , ATTRIBUTE20  , ATTRIBUTE21  , ATTRIBUTE22  , ATTRIBUTE23  , ATTRIBUTE24  , ATTRIBUTE25  , ATTRIBUTE26  , ATTRIBUTE27  , ATTRIBUTE28  ,
        ATTRIBUTE29   , ATTRIBUTE30  , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 , INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
        INFORMATION9  , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
        INFORMATION19 , INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24, INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
        INFORMATION29 , INFORMATION30, INFORMATION_CATEGORY
   From Per_gen_Hierarchy_Nodes a
Start with Hierarchy_Node_Id        = P_Hierarchy_Id
Connect by Parent_Hierarchy_Node_Id = Prior Hierarchy_Node_id;

Line: 2358

 Select Node_Type, Entity_id
   from Per_Gen_hierarchy_Nodes
  Where Hierarchy_Node_Id    = P_Parent_Hierarchy_Node_id;

Line: 2364

 Select hierarchy_Node_Id
   from Per_Gen_Hierarchy_Nodes
  Where Hierarchy_version_Id = p_Hierarchy_version_id
    and Node_type            = P_Node_Type
    and Entity_Id            = P_Entity_Id
    and Request_Id           = -999;

Line: 2541

Update Per_Gen_Hierarchy_Nodes
   Set REQUEST_ID = 0
 Where REQUEST_ID = -999;