1 PACKAGE GMD_COMMON_GRP AS
2 --$Header: GMDGCOMS.pls 120.0 2005/06/17 08:15:00 sxfeinst noship $ */
3
4 --+=======================================================================================================+
5 --| Copyright (c) 1998 Oracle Corporation
6 --| Redwood Shores, CA, USA
7 --| All rights reserved.
8 --+========================================================================================================+
9 --| File Name : GMDGCOMS.pls
10 --| Package Name : GMD_COMMON_GRP
11 --| Type : Group
12 --|
13 --| Notes
14 --| This package contains common group layer APIs for Quality
15 --|
16 --| HISTORY
17 --| S. Feinstein 05-Jan-2004 Created.
18 --|
19 --+========================================================================================================+
20
21 PROCEDURE item_is_locator_controlled (
22 p_organization_id IN NUMBER
23 ,p_subinventory IN VARCHAR2
24 ,p_inventory_item_id IN NUMBER
25 ,x_locator_type OUT NOCOPY NUMBER
26 ,x_return_status OUT NOCOPY VARCHAR2
27 ) ;
28
29 PROCEDURE Get_organization_type (
30 p_organization_id IN Number
31 ,x_plant OUT NOCOPY NUMBER
32 ,x_lab OUT NOCOPY NUMBER
33 ,x_return_status OUT NOCOPY VARCHAR2);
34
35 PROCEDURE Get_lot_attributes ( p_organization_id IN NUMBER
36 ,p_inventory_item_id IN NUMBER
37 ,p_lot_number IN VARCHAR2
38 ,p_parent_lot_number IN VARCHAR2
39 ,x_lot_status_code OUT NOCOPY VARCHAR2
40 ,x_grade_code OUT NOCOPY VARCHAR2
41 ,x_return_status OUT NOCOPY VARCHAR2);
42 END GMD_COMMON_GRP;
[Home] [Help]