1 PACKAGE INV_PO_ITEMVALID_MDTR AUTHID CURRENT_USER AS
2 -- $Header: INVMPO1S.pls 115.1 2003/08/21 08:31:57 dpenmats noship $ --
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVMPO1S.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Check the VMI/Consigned Enabled for a given item/organization |
13 --| combinations. |
14 --| This mediator package is used to access PO objects from |
15 --| INV product. |
16 --| |
17 --| HISTORY |
18 --| 2003/21/07 dpenmats Created |
19 --+=======================================================================+
20
21 --=============================================================================
22 -- CONSTANTS
23 --=============================================================================
24
25 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_PO_ITEMVALID_MDTR';
26
27 --=============================================================================
28 -- PUBLIC VARIABLES
29 --=============================================================================
30
31 --=========================================================================
32 -- PROCEDURES AND FUNCTIONS
33 --=========================================================================
34
35 --=========================================================================
36 -- PROCEDURE : Check_VmiOrConsign_Enabled
37 -- PARAMETERS:
38 -- p_api_version REQUIRED. API version
39 -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the message list
40 -- FND_API.G_FALSE to not reset it.
41 -- If pass NULL, it means FND_API.G_FALSE.
42 -- x_return_status REQUIRED. Value can be
43 -- FND_API.G_RET_STS_SUCCESS
44 -- FND_API.G_RET_STS_ERROR
45 -- FND_API.G_RET_STS_UNEXP_ERROR
46 -- x_msg_count REQUIRED. Number of messages on the message list
47 -- x_msg_data REQUIRED. Return message data if message count is 1
48 -- p_item_id REQUIRED. Inventory Item Id
49 -- p_organization_id REQUIRED. Inventory organization ID
50 -- x_vmiorconsign_flag REQUIRED. Vmi or consigned enabled flag
51 -- 'Y' indicates a valid vmi or cosigned
52 -- inventory exists
53 -- 'N' indicates no valid vmi or consigned
54 -- COMMENT : This procedure is called by Items form and Item open interface
55 -- to decide whether there exist a valid vmi or consigned
56 -- for a particular item/organization combination
57 --=========================================================================
58
59 PROCEDURE Check_VmiOrConsign_Enabled
60 ( p_api_version IN NUMBER
61 , p_init_msg_list IN VARCHAR2
62 , x_return_status OUT NOCOPY VARCHAR2
63 , x_msg_count OUT NOCOPY NUMBER
64 , x_msg_data OUT NOCOPY VARCHAR2
65 , p_item_id IN NUMBER
66 , p_organization_id IN NUMBER
67 , x_vmiorconsign_flag OUT NOCOPY VARCHAR2
68 );
69
70 --=========================================================================
71 -- PROCEDURE : Check_Consign_Enabled
72 -- PARAMETERS:
73 -- p_api_version REQUIRED. API version
74 -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the message list
75 -- FND_API.G_FALSE to not reset it.
76 -- If pass NULL, it means FND_API.G_FALSE.
77 -- x_return_status REQUIRED. Value can be
78 -- FND_API.G_RET_STS_SUCCESS
79 -- FND_API.G_RET_STS_ERROR
80 -- FND_API.G_RET_STS_UNEXP_ERROR
81 -- x_msg_count REQUIRED. Number of messages on the message list
82 -- x_msg_data REQUIRED. Return message data if message count is 1
83 -- p_item_id REQUIRED. Inventory Item Id
84 -- p_organization_id REQUIRED. Inventory organization ID
85 -- x_consign_flag REQUIRED. Consigned enabled flag
86 -- 'Y' indicates a valid vmi or cosigned
87 -- inventory exists
88 -- 'N' indicates no valid vmi or consigned
89 -- COMMENT : This procedure is called by Items form and Item open interface
90 -- to decide whether there exist a valid consigned Inventory
91 -- for a particular item/organization combination
92 --=========================================================================
93
94 PROCEDURE Check_Consign_Enabled
95 ( p_api_version IN NUMBER
96 , p_init_msg_list IN VARCHAR2
97 , x_return_status OUT NOCOPY VARCHAR2
98 , x_msg_count OUT NOCOPY NUMBER
99 , x_msg_data OUT NOCOPY VARCHAR2
100 , p_item_id IN NUMBER
101 , p_organization_id IN NUMBER
102 , x_consign_flag OUT NOCOPY VARCHAR2
103 );
104
105 END INV_PO_ITEMVALID_MDTR;
106