[Home] [Help]
585: Procedure chk_entity_id
586: ( p_entity_id in per_gen_hierarchy_nodes.entity_id%TYPE
587: , p_business_group_id in hr_all_organization_units.business_group_id%TYPE
588: , p_node_type in per_gen_hierarchy_nodes.node_type%TYPE
589: , p_hierarchy_version_id in per_gen_hierarchy_versions.hierarchy_version_id%TYPE
590: ) IS
591: --
592: l_ent_exists varchar2(1) := 'Y';
593: --
594: cursor csr_org_exists is
595: select 'Y'
596: from hr_all_organization_units hou
597: , hr_organization_information hoi
598: , per_gen_hierarchy_versions pgv
599: where hou.organization_id = p_entity_id
600: and (hou.business_group_id = p_business_group_id or p_business_group_id is null)
601: and pgv.hierarchy_version_id = p_hierarchy_version_id
602: and hou.organization_id = hoi.organization_id
721: -- |---------------------------< chk_hierarchy_version_id >-------------------|
722: -- ----------------------------------------------------------------------------
723: --
724: Procedure chk_hierarchy_version_id
725: ( p_hierarchy_version_id in per_gen_hierarchy_versions.hierarchy_version_id%TYPE
726: , p_hierarchy_node_id in per_gen_hierarchy_nodes.hierarchy_node_id%TYPE
727: , p_object_version_number in per_gen_hierarchy_nodes.object_version_number%TYPE
728: ) IS
729: --
734: l_api_updating BOOLEAN;
735: --
736: cursor csr_hier_vers is
737: select 'Y'
738: from per_gen_hierarchy_versions
739: where hierarchy_version_id = p_hierarchy_version_id;
740: --
741: Begin
742: --
774: -- ----------------------------------------------------------------------------
775: --
776: PROCEDURE chk_seq
777: (p_seq IN per_gen_hierarchy_nodes.seq%TYPE
778: ,p_hierarchy_version_id IN per_gen_hierarchy_versions.hierarchy_version_id%TYPE
779: ,p_parent_hierarchy_node_id IN per_gen_hierarchy_nodes.parent_hierarchy_node_id%TYPE
780: ,p_hierarchy_node_id IN per_gen_hierarchy_nodes.hierarchy_node_id%TYPE
781: ,p_object_version_number IN per_gen_hierarchy_nodes.object_version_number%TYPE
782: )