1 PACKAGE INV_MGD_POS_ORGANIZATION_MDTR AUTHID CURRENT_USER AS
2 /* $Header: INVMPORS.pls 115.1 2002/12/24 23:16:36 vjavli ship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVMPORS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Inventory Position View and Export: Organization Mediator |
13 --| HISTORY |
14 --| 09/05/2000 Paolo Juvara Created |
15 --+======================================================================*/
16
17
18 --===================
19 -- PROCEDURES AND FUNCTIONS
20 --===================
21
22 --========================================================================
23 -- PROCEDURE : Build_Organization_List PUBLIC
24 -- PARAMETERS: p_init_msg_list FND_API.G_TRUE to reset list
25 -- x_return_status return status
26 -- x_msg_count number of messages in the list
27 -- x_msg_data text of messages
28 -- p_hierarchy_id organization hierarchy
29 -- p_hierarchy_level_id organization ID identifying the level
30 -- x_organization_tbl list of organization
31 -- COMMENT : Builds the list of organizations that belong to a hierarchy level
32 -- POST-COND : x_organization_tbl is not empty
33 --========================================================================
34 PROCEDURE Build_Organization_List
35 ( p_hierarchy_id IN NUMBER
36 , p_hierarchy_level_id IN NUMBER
37 , x_organization_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.organization_tbl_type
38 );
39
40
41
42 END INV_MGD_POS_ORGANIZATION_MDTR;