50: )
51: IS
52:
53: l_api_name CONSTANT VARCHAR2(30):= 'Build_Organization_List';
54: l_org_id_tbl INV_ORGHIERARCHY_PVT.OrgID_tbl_type;
55:
56: BEGIN
57:
58: IF G_DEBUG = 'Y' THEN
66: x_organization_tbl.DELETE;
67:
68: -- bug#2563291 fix use the performance enhancement api
69: -- get organization list
70: INV_ORGHIERARCHY_PVT.get_organization_List
71: ( p_hierarchy_id => p_hierarchy_id
72: , p_origin_org_id => p_hierarchy_level_id
73: , x_org_id_tbl => l_org_id_tbl
74: , p_include_origin => 'Y'