APPS.PQH_DE_OPR_GRP SQL Statements

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

Line: 9

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: 32

 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: 45

 Select Node_Type, Entity_id
   from Per_Gen_hierarchy_Nodes
  Where Hierarchy_Node_Id    = P_Parent_Hierarchy_Node_id;

Line: 51

 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: 226

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

Line: 254

 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: 261

 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: 268

 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: 276

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: 318

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

Line: 324

       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: 331

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

Line: 339

  /*  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: 362

 /*    PQH_DE_OPERATION_GROUPS_API.UPDATE_OPERATION_GROUPS
     (P_EFFECTIVE_DATE          => P_EFFECTIVE_DATE,
      P_OPERATION_GROUP_ID      => P_Code_Id,
      P_OBJECT_VERSION_NUMBER   => l_Object_Version_Number,
      P_OPERATION_GROUP_CODE    => P_Code,
      P_DESCRIPTION             => P_Description); */

Line: 372

  /*  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: 394

  /*  PQH_DE_OPERATIONS_API.UPDATE_OPERATIONS
    (P_EFFECTIVE_DATE           => P_EFFECTIVE_DATE,
     P_OPERATION_NUMBER         => P_Code,
     P_DESCRIPTION              => P_Description,
     P_OPERATION_ID             => P_Code_Id,
     P_OBJECT_VERSION_NUMBER    => l_Object_Version_Number); */

Line: 403

  /*  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: 425

   /*   PQH_DE_TKTDTLS_API.UPDATE_TKT_DTLS
     (P_EFFECTIVE_DATE          => P_EFFECTIVE_DATE,
      P_TATIGKEIT_NUMBER        => P_Code,
      P_DESCRIPTION             => P_Description,
      P_TATIGKEIT_DETAIL_ID     => P_Code_Id,
      P_OBJECT_VERSION_NUMBER   => l_Object_Version_Number); */

Line: 463

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

Line: 486

 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: 497

 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: 510

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