1 PACKAGE GMIPAPI AS
2 /* $Header: GMIPAPIS.pls 120.1 2006/10/04 18:30:56 pxkumar noship $ */
3 /*#
4 * This is the public interface for OPM Inventory API
5 * This API can be used for creation of Items, creation of Lots,
6 * creation of Item/lot/sublot conversions, setting and posting of
7 * Inventory journal
8 * @rep:scope private
9 * @rep:product GMI
10 * @rep:displayname GMI Inventory API
11 * @rep:lifecycle active
12 * @rep:category BUSINESS_ENTITY GMI_API
13 */
14
15 /*#
16 * Inventory Item Creation API
17 * This API Creates a new Inventory Item in the OPM Inventory Item Master Table
18 * @param p_api_version Version number of the API
19 * @param p_init_msg_list Flag for initializing message list
20 * @param p_commit Flag for commiting the data
21 * @param p_validation_level Indicator for validation level
22 * @param p_item_rec Item details record type
23 * @param x_ic_item_mst_row Item master row type
24 * @param x_ic_item_cpg_row Item details row type
25 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
26 * @param x_msg_count Number of messages on message stack
27 * @param x_msg_data Actual message data from message stack
28 * @rep:scope private
29 * @rep:lifecycle active
30 * @rep:displayname Create Inventory Item API
31 */
32 PROCEDURE Create_Item
33 ( p_api_version IN NUMBER
34 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
35 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
36 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
37 , p_item_rec IN GMIGAPI.item_rec_typ
38 , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
39 , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
40 , x_return_status OUT NOCOPY VARCHAR2
41 , x_msg_count OUT NOCOPY NUMBER
42 , x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45 /*#
46 * Inventory Lot Creation API
47 * This API Creates a new Inventory Lot in the Lot Master Table
48 * @param p_api_version Version number of the API
49 * @param p_init_msg_list Flag for initializing message list
50 * @param p_commit Flag for commiting the data
51 * @param p_validation_level Indicator for validation level
52 * @param p_lot_rec Lot details record type
53 * @param x_ic_lots_mst_row Lot master row type
54 * @param x_ic_lots_cpg_row Lot details row type
55 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
56 * @param x_msg_count Number of messages on message stack
57 * @param x_msg_data Actual message data from message stack
58 * @rep:scope private
59 * @rep:lifecycle active
60 * @rep:displayname Create Inventory Lot API
61 */
62 PROCEDURE Create_Lot
63 ( p_api_version IN NUMBER
64 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
65 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
66 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
67 , p_lot_rec IN GMIGAPI.lot_rec_typ
68 , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
69 , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_msg_count OUT NOCOPY NUMBER
72 , x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 /*#
76 * Item/Lot/Sublot Conversion API
77 * This API Creates a new Inventory Item/lot/sublot conversion
78 * in Item/lot conversion table
79 * @param p_api_version Version number of the API
80 * @param p_init_msg_list Flag for initializing message list
81 * @param p_commit Flag for commiting the data
82 * @param p_validation_level Indicator for validation level
83 * @param p_conv_rec Conversion details record type
84 * @param x_ic_item_cnv_row Item/lot conversion details row type
85 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
86 * @param x_msg_count Number of messages on message stack
87 * @param x_msg_data Actual message data from message stack
88 * @rep:scope private
89 * @rep:lifecycle active
90 * @rep:displayname Create Inventory Item/Lot/Sublot Conversion API
91 */
92 PROCEDURE Create_Item_Lot_Conv
93 ( p_api_version IN NUMBER
94 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
95 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
96 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
97 , p_conv_rec IN GMIGAPI.conv_rec_typ
98 , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE
99 , x_return_status OUT NOCOPY VARCHAR2
100 , x_msg_count OUT NOCOPY NUMBER
101 , x_msg_data OUT NOCOPY VARCHAR2
102 );
103
104 /*#
105 * Setting up and Posting Inventory Journal API
106 * This API sets up and posts inventory journal in
107 * Journal master header table
108 * @param p_api_version Version number of the API
109 * @param p_init_msg_list Flag for initializing message list
110 * @param p_commit Flag for commiting the data
111 * @param p_validation_level Indicator for validation level
112 * @param p_qty_rec Quantity details record type
113 * @param x_ic_jrnl_mst_row Journal master header row type
114 * @param x_ic_adjs_jnl_row1 Inventory adjustment detail row type
115 * @param x_ic_adjs_jnl_row2 Inventory adjustment detail row type
116 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
117 * @param x_msg_count Number of messages on message stack
118 * @param x_msg_data Actual message data from message stack
119 * @rep:scope private
120 * @rep:lifecycle active
121 * @rep:displayname Setup and Post Inventory Journal API
122 */
123 PROCEDURE Inventory_Posting
124 ( p_api_version IN NUMBER
125 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
126 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
127 , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
128 , p_qty_rec IN GMIGAPI.qty_rec_typ
129 , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE
130 , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%ROWTYPE
131 , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%ROWTYPE
132 , x_return_status OUT NOCOPY VARCHAR2
133 , x_msg_count OUT NOCOPY NUMBER
134 , x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137 PROCEDURE Inventory_Transfer
138 ( p_api_version IN NUMBER
139 , p_init_msg_list IN VARCHAR2
140 , p_commit IN VARCHAR2
141 , p_validation_level IN NUMBER
142 , p_xfer_rec IN GMIGAPI.xfer_rec_typ
143 , x_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
144 , x_return_status OUT NOCOPY VARCHAR2
145 , x_msg_count OUT NOCOPY NUMBER
146 , x_msg_data OUT NOCOPY VARCHAR2
147 );
148
149 END GMIPAPI;