[Home] [Help]
PACKAGE: APPS.GMI_AUTO_ALLOCATE_PUB
Source
1 PACKAGE GMI_AUTO_ALLOCATE_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMIPALLS.pls 120.0 2005/05/25 15:49:39 appldev noship $
3 +=========================================================================+
4 | Copyright (c) 1998 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIPALLS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains public procedures controling auto-allocation |
13 | of OPM inventory against order/shipment lines. |
14 | |
15 | HISTORY |
16 | 15-DEC-1999 K.Y.Hunt |
17 +=========================================================================+
18 API Name : GMI_AUTO_ALLOCATE_PUB
19 Type : Public
20 Function : This package contains public procedures controling auto-
21 allocation of OPM inventory against order/shipment lines.
22 Pre-reqs : N/A
23 Parameters: Per function
24
25 Current Vers : 1.0
26
27 Previous Vers : 1.0
28
29 Initial Vers : 1.0
30 Notes
31
32 API specific parameters to be presented in SQL RECORD format
33 */
34
35
36 TYPE gmi_allocation_rec is RECORD
37 ( doc_id IC_TRAN_PND.DOC_ID%TYPE
38 , line_id IC_TRAN_PND.LINE_ID%TYPE
39 , doc_line IC_TRAN_PND.DOC_LINE%TYPE
40 , line_detail_id IC_TRAN_PND.LINE_DETAIL_ID%TYPE
41 , item_no IC_ITEM_MST.ITEM_NO%TYPE
42 , whse_code IC_WHSE_MST.WHSE_CODE%TYPE
43 , co_code OP_CUST_MST.CO_CODE%TYPE
44 , cust_no OP_CUST_MST.CUST_NO%TYPE
45 , prefqc_grade OP_ORDR_DTL.QC_GRADE_WANTED%TYPE
46 , order_qty1 OP_ORDR_DTL.ORDER_QTY1%TYPE
47 , order_qty2 OP_ORDR_DTL.ORDER_QTY2%TYPE
48 , order_um1 OP_ORDR_DTL.ORDER_UM1%TYPE
49 , order_um2 OP_ORDR_DTL.ORDER_UM2%TYPE
50 , ship_to_org_id oe_order_lines_all.SHIP_TO_ORG_ID%TYPE
51 , of_cust_id oe_order_lines_all.sold_to_org_id%TYPE
52 , org_id oe_order_lines_all.org_id%TYPE
53 , trans_date IC_TRAN_PND.TRANS_DATE%TYPE
54 , user_id FND_USER.USER_ID%TYPE
55 , user_name FND_USER.USER_NAME%TYPE
56 );
57
58
59
60 PROCEDURE ALLOCATE_INVENTORY
61 ( p_api_version IN NUMBER
62 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
63 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
64 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
65 , p_allocation_rec IN gmi_allocation_rec
66 , x_reservation_id OUT NOCOPY NUMBER
67 , x_allocated_qty1 OUT NOCOPY NUMBER
68 , x_allocated_qty2 OUT NOCOPY NUMBER
69 , x_return_status OUT NOCOPY VARCHAR2
70 , x_msg_count OUT NOCOPY NUMBER
71 , x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74
75 END GMI_AUTO_ALLOCATE_PUB;