DBA Data[Home] [Help]

APPS.PER_ORG_STRUCTURE_ELEMENTS_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS_PKG

Line 1: PACKAGE BODY PER_ORG_STRUCTURE_ELEMENTS_PKG as

1: PACKAGE BODY PER_ORG_STRUCTURE_ELEMENTS_PKG as
2: /* $Header: peose01t.pkb 120.1.12010000.2 2009/02/25 08:33:18 sidsaxen ship $ */
3: ------------------------------------------------------------------------------
4: FUNCTION get_subordinates(p_view_all_orgs VARCHAR2
5: ,p_org_id_parent NUMBER

Line 606: PER_ORG_STRUCTURE_ELEMENTS_PKG.Lock_Row(p_Rowid => Recinfo.ROWID,

602: if get_details%found then
603: --
604: -- Lock the row
605: --
606: PER_ORG_STRUCTURE_ELEMENTS_PKG.Lock_Row(p_Rowid => Recinfo.ROWID,
607: p_Org_Structure_Element_Id =>Recinfo.Org_Structure_Element_Id,
608: p_Business_Group_Id =>Recinfo.Business_Group_Id,
609: p_Organization_Id_Parent =>Recinfo.Organization_Id_Parent,
610: p_Org_Structure_Version_Id=>Recinfo.Org_Structure_Version_Id,

Line 616: PER_ORG_STRUCTURE_ELEMENTS_PKG.Update_Row(p_Rowid=> Recinfo.ROWID,

612: p_pos_control_enabled_flag => Recinfo.position_control_enabled_flag);
613: --
614: -- Update the row
615: --
616: PER_ORG_STRUCTURE_ELEMENTS_PKG.Update_Row(p_Rowid=> Recinfo.ROWID,
617: p_Org_Structure_Element_Id =>Recinfo.Org_Structure_Element_Id,
618: p_Business_Group_Id => Recinfo.Business_Group_Id,
619: p_Organization_Id_Parent =>p_Organization_Id_Parent,
620: p_Org_Structure_Version_Id =>Recinfo.Org_Structure_Version_Id,

Line 669: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id

665: -- Post-insert code
666: -- Maintains org_list security profiles
667: --
668: if p_view_all_orgs = 'N' then
669: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id
670: ,p_security_profile_id
671: ,p_Organization_Id_Parent
672: );
673: end if;

Line 795: per_org_structure_elements_pkg.delete_validation(

791: BEGIN
792: --
793: -- Do pre-delete validation
794: --
795: per_org_structure_elements_pkg.delete_validation(
796: p_org_structure_version_id =>p_org_structure_version_id
797: ,p_org_structure_element_id => p_org_structure_element_id
798: ,p_org_id_child => p_organization_id_child
799: ,p_org_id_parent => p_organization_id_parent

Line 813: if per_org_structure_elements_pkg.post_delete_check(

809: end if;
810: --
811: -- Post-delete checking
812: --
813: if per_org_structure_elements_pkg.post_delete_check(
814: p_org_structure_version_id => p_org_structure_version_id
815: ,p_organization_id => p_organization_id_parent) then
816: p_exists_in_hierarchy :='Y';
817: else

Line 822: END PER_ORG_STRUCTURE_ELEMENTS_PKG;

818: p_exists_in_hierarchy :='N';
819: end if;
820: END Delete_Row;
821: -------------------------------------------------------------------------------
822: END PER_ORG_STRUCTURE_ELEMENTS_PKG;