45: --========================================================================
46: PROCEDURE Build_Organization_List
47: ( p_hierarchy_id IN NUMBER
48: , p_hierarchy_level_id IN NUMBER
49: , x_organization_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.organization_tbl_type
50: )
51: IS
52:
53: l_api_name CONSTANT VARCHAR2(30):= 'Build_Organization_List';
55:
56: BEGIN
57:
58: IF G_DEBUG = 'Y' THEN
59: INV_MGD_POS_UTIL.Log
60: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
61: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
62: );
63: END IF;
56: BEGIN
57:
58: IF G_DEBUG = 'Y' THEN
59: INV_MGD_POS_UTIL.Log
60: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
61: , p_msg => '> '||G_PKG_NAME||'.'||l_api_name
62: );
63: END IF;
64:
73: , x_org_id_tbl => l_org_id_tbl
74: , p_include_origin => 'Y'
75: );
76: IF G_DEBUG = 'Y' THEN
77: INV_MGD_POS_UTIL.Log
78: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
79: , p_msg => 'organization list retrieved'
80: );
81: END IF;
74: , p_include_origin => 'Y'
75: );
76: IF G_DEBUG = 'Y' THEN
77: INV_MGD_POS_UTIL.Log
78: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
79: , p_msg => 'organization list retrieved'
80: );
81: END IF;
82:
92: FROM mtl_parameters
93: WHERE organization_id = l_org_id_tbl(l_Idx);
94: END LOOP;
95: IF G_DEBUG = 'Y' THEN
96: INV_MGD_POS_UTIL.Log
97: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
98: , p_msg => 'organization information retrieved'
99: );
100:
93: WHERE organization_id = l_org_id_tbl(l_Idx);
94: END LOOP;
95: IF G_DEBUG = 'Y' THEN
96: INV_MGD_POS_UTIL.Log
97: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
98: , p_msg => 'organization information retrieved'
99: );
100:
101: INV_MGD_POS_UTIL.Log
97: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
98: , p_msg => 'organization information retrieved'
99: );
100:
101: INV_MGD_POS_UTIL.Log
102: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
103: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
104: );
105: END IF;
98: , p_msg => 'organization information retrieved'
99: );
100:
101: INV_MGD_POS_UTIL.Log
102: ( p_priority => INV_MGD_POS_UTIL.G_LOG_PROCEDURE
103: , p_msg => '< '||G_PKG_NAME||'.'||l_api_name
104: );
105: END IF;
106: