[Home] [Help]
PACKAGE: APPS.INV_MGD_POS_ITEM_MDTR
Source
1 PACKAGE INV_MGD_POS_ITEM_MDTR AUTHID CURRENT_USER AS
2 /* $Header: INVMPITS.pls 115.1 2002/12/24 23:08:02 vjavli ship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVMPITS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Inventory Position View and Export: Item Mediator |
13 --| HISTORY |
14 --| 09/05/2000 Paolo Juvara Created |
15 --+======================================================================*/
16
17
18 --===================
19 -- PROCEDURES AND FUNCTIONS
20 --===================
21
22 --========================================================================
23 -- PROCEDURE : Build_Item_List PUBLIC
24 -- PARAMETERS: p_organization_tbl list of organization
25 -- p_master_org_id master item organization
26 -- p_item_from item from range
27 -- p_item_to item to range
28 -- p_category_id category id
29 -- x_item_tbl item list
30 -- COMMENT : Builds the list of items to view
31 -- PRE-COND : p_organization_tbl is not empty
32 -- POST-COND : x_item_tbl is not empty
33 --========================================================================
34 PROCEDURE Build_Item_List
35 ( p_organization_tbl IN INV_MGD_POS_UTIL.organization_tbl_type
36 , p_master_org_id IN NUMBER DEFAULT NULL
37 , p_item_from IN VARCHAR2 DEFAULT NULL
38 , p_item_to IN VARCHAR2 DEFAULT NULL
39 , p_category_id IN NUMBER DEFAULT NULL
40 , x_item_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.item_tbl_type
41 );
42
43
44
45 END INV_MGD_POS_ITEM_MDTR;