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.0.12000000.2 2007/03/07 10:58:33 asgugupt ship $ */
3: ------------------------------------------------------------------------------
4: FUNCTION get_subordinates(p_view_all_orgs VARCHAR2
5: ,p_org_id_parent NUMBER

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

568: if get_details%found then
569: --
570: -- Lock the row
571: --
572: PER_ORG_STRUCTURE_ELEMENTS_PKG.Lock_Row(p_Rowid => Recinfo.ROWID,
573: p_Org_Structure_Element_Id =>Recinfo.Org_Structure_Element_Id,
574: p_Business_Group_Id =>Recinfo.Business_Group_Id,
575: p_Organization_Id_Parent =>Recinfo.Organization_Id_Parent,
576: p_Org_Structure_Version_Id=>Recinfo.Org_Structure_Version_Id,

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

578: p_pos_control_enabled_flag => Recinfo.position_control_enabled_flag);
579: --
580: -- Update the row
581: --
582: PER_ORG_STRUCTURE_ELEMENTS_PKG.Update_Row(p_Rowid=> Recinfo.ROWID,
583: p_Org_Structure_Element_Id =>Recinfo.Org_Structure_Element_Id,
584: p_Business_Group_Id => Recinfo.Business_Group_Id,
585: p_Organization_Id_Parent =>p_Organization_Id_Parent,
586: p_Org_Structure_Version_Id =>Recinfo.Org_Structure_Version_Id,

Line 634: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id

630: -- Post-insert code
631: -- Maintains org_list security profiles
632: --
633: if p_view_all_orgs = 'N' then
634: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id
635: ,p_security_profile_id
636: ,p_Organization_Id_Parent
637: );
638: end if;

Line 760: per_org_structure_elements_pkg.delete_validation(

756: BEGIN
757: --
758: -- Do pre-delete validation
759: --
760: per_org_structure_elements_pkg.delete_validation(
761: p_org_structure_version_id =>p_org_structure_version_id
762: ,p_org_structure_element_id => p_org_structure_element_id
763: ,p_org_id_child => p_organization_id_child
764: ,p_org_id_parent => p_organization_id_parent

Line 778: if per_org_structure_elements_pkg.post_delete_check(

774: end if;
775: --
776: -- Post-delete checking
777: --
778: if per_org_structure_elements_pkg.post_delete_check(
779: p_org_structure_version_id => p_org_structure_version_id
780: ,p_organization_id => p_organization_id_parent) then
781: p_exists_in_hierarchy :='Y';
782: else

Line 787: END PER_ORG_STRUCTURE_ELEMENTS_PKG;

783: p_exists_in_hierarchy :='N';
784: end if;
785: END Delete_Row;
786: -------------------------------------------------------------------------------
787: END PER_ORG_STRUCTURE_ELEMENTS_PKG;