The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
Select Node_Type, Entity_id
from Per_Gen_hierarchy_Nodes
Where Hierarchy_Node_Id = P_Parent_Hierarchy_Node_id;
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;
Update Per_Gen_Hierarchy_Nodes
Set REQUEST_ID = 0
Where REQUEST_ID = -999;
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;
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;
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;
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;
Per_Hierarchy_Nodes_api.DELETE_HIERARCHY_NODES
(P_Hierarchy_Node_Id => C3rec.Hierarchy_Node_id,
P_Object_Version_Number => l_Object_Version_Number);
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);
Per_Hierarchy_api.Delete_Hierarchy
(P_Hierarchy_Id => C2rec.Hierarchy_id,
P_Object_Version_Number => l_Object_Version_Number);
/* 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); */
/* 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); */
/* 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); */
/* 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); */
/* 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); */
/* 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); */
Per_Hierarchy_Nodes_Api.DELETE_HIERARCHY_NODES
(P_HIERARCHY_NODE_ID => C1rec.Hierarchy_Node_Id,
P_OBJECT_VERSION_NUMBER => l_Object_Version_Number);
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;
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)));
Select Hierarchy_Node_id
From Per_Gen_Hierarchy_Nodes
Where Hierarchy_Version_id = C_Hierarchy_version_id
and Parent_Hierarchy_Node_Id is NULL;