1 PACKAGE GMI_OM_ALLOC_API_PUB AS
2 /* $Header: GMIOMAPS.pls 120.0 2005/05/25 16:02:38 appldev noship $ */
3 /*#
4 * This is the public interface for Allocate OPM Orders API.
5 * It contains the API for the creation, modification and deletion
6 * of OPM allocation information for Order Management,
7 * depending on an action code of INSERT, UPDATE or DELETE.
8 * @rep:scope public
9 * @rep:product GMI
10 * @rep:displayname GMI Allocate OPM Orders API
11 * @rep:lifecycle active
12 * @rep:category BUSINESS_ENTITY GMI_OM_ALLOC_API_PUB
13 */
14
15 TYPE Ic_Tran_Rec_Type IS RECORD (
16 trans_id IC_TRAN_PND.TRANS_ID%TYPE
17 ,line_id IC_TRAN_PND.LINE_ID%TYPE
18 ,lot_id IC_LOTS_MST.LOT_ID%TYPE
19 ,lot_no IC_LOTS_MST.LOT_NO%TYPE
20 ,sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE
21 ,location VARCHAR2(50)
22 ,trans_qty IC_TRAN_PND.TRANS_QTY%TYPE
23 ,trans_qty2 IC_TRAN_PND.TRANS_QTY2%TYPE
24 ,trans_um IC_TRAN_PND.TRANS_UM%TYPE
25 ,reason_code SY_REAS_CDS.REASON_CODE%TYPE
26 ,trans_date DATE
27 ,line_detail_id IC_TRAN_PND.LINE_DETAIL_ID%TYPE
28 ,action_code VARCHAR2(10));
29
30
31 /* ========================================================================
32 | PARAMETERS:
33 | p_api_version Known api versionerror buffer
34 | p_init_msg_list FND_API.G_TRUE to reset list
35 | p_commit Commit flag. API commits if this is set.
36 | p_tran_rec Input transaction record
37 | x_msg_count number of messages in the list
38 | x_msg_lst text of messages
39 | x_return_status return status
40 |
41 | VERSION : current version 1.0
42 | initial version 1.0
43 | COMMENT : Creates,updates or deletes an opm reservation (allocation) in ic_tran_pnd
44 | table with information specified in p_tran_rec.
45 |
46 | ======================================================================== */
47
48 /*#
49 * Allocate OPM Orders API
50 * This API creates, updates or deletes an opm allocation in the ic_tran_pnd
51 * table with information specified in p_tran_rec.
52 * @param p_api_version Version Number of the API
53 * @param p_init_msg_list Flag for initializing message list (default 'F')
54 * @param p_commit Flag for commiting the data or not (default 'F')
55 * @param p_tran_rec Input transaction record plus action code.
56 * @param x_msg_count Number of messages on message stack
57 * @param x_msg_data Actual message data from message stack
58 * @param x_return_status Return status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
59 * @rep:scope public
60 * @rep:lifecycle active
61 * @rep:displayname GMI Allocate OPM Orders API
62 */
63
64
65 PROCEDURE Allocate_OPM_Orders (
66 p_api_version IN NUMBER
67 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
68 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
69 ,p_tran_rec IN ic_tran_rec_type
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2 );
73
74 PROCEDURE Get_Item_Details (
75 p_organization_id IN NUMBER
76 , p_inventory_item_id IN NUMBER
77 , x_ic_item_mst_rec OUT NOCOPY IC_ITEM_MST_B%ROWTYPE
78 , x_return_status OUT NOCOPY VARCHAR2
79 , x_msg_count OUT NOCOPY NUMBER
80 , x_msg_data OUT NOCOPY VARCHAR2 );
81
82 PROCEDURE Get_Lot_Details (
83 p_item_id IN ic_lots_mst.item_id%TYPE
84 , p_lot_no IN ic_lots_mst.lot_no%TYPE
85 , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
86 , p_lot_id IN ic_lots_mst.lot_id%TYPE
87 , x_ic_lots_mst OUT NOCOPY ic_lots_mst%ROWTYPE
88 , x_return_status OUT NOCOPY VARCHAR2
89 , x_msg_count OUT NOCOPY NUMBER
90 , x_msg_data OUT NOCOPY VARCHAR2 );
91
92 PROCEDURE PrintMsg (
93 p_msg IN VARCHAR2
94 , p_file_name IN VARCHAR2 DEFAULT '0');
95 END GMI_OM_ALLOC_API_PUB;