[Home] [Help]
PACKAGE: APPS.GMI_AUTO_ALLOC_BATCH_PKG
Source
1 PACKAGE GMI_AUTO_ALLOC_BATCH_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMIALLCS.pls 120.1 2005/06/17 15:04:03 appldev $ */
3
4 /* ===========================================================================
5 | Copyright (c) 2000 Oracle Corporation |
6 | TVP, Reading, England |
7 | All rights reserved |
8 ===========================================================================
9 | FILENAME |
10 | GMIALLCS.pls |
11 | |
12 | DESCRIPTION |
13 | |
14 | |
15 | HISTORY |
16 | - Auto_Allocate_Batch |
17 ===========================================================================
18 */
19
20 PROCEDURE Auto_Allocate_Batch (
21 errbuf OUT NOCOPY VARCHAR2
22 ,retcode OUT NOCOPY VARCHAR2
23 ,p_api_version IN NUMBER
24 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
25 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
26 ,p_batch_id IN NUMBER);
27
28
29 PROCEDURE Auto_Alloc_Wdd_Line (
30 p_api_version IN NUMBER
31 ,p_init_msg_list IN VARCHAR2
32 ,p_commit IN VARCHAR2
33 ,p_wdd_rec IN wsh_delivery_details%rowtype
34 ,p_batch_rec IN gmi_auto_allocation_batch%rowtype
35 ,x_number_of_rows OUT NOCOPY NUMBER
36 ,x_qc_grade OUT NOCOPY VARCHAR2
37 ,x_detailed_qty OUT NOCOPY NUMBER
38 ,x_qty_UM OUT NOCOPY VARCHAR2
39 ,x_detailed_qty2 OUT NOCOPY NUMBER
40 ,x_qty_UM2 OUT NOCOPY VARCHAR2
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY NUMBER
43 ,x_msg_data OUT NOCOPY VARCHAR2);
44
45
46 PROCEDURE Call_Pick_Confirm
47 ( p_mo_line_id IN NUMBER
48 , p_delivery_detail_id IN NUMBER DEFAULT NULL
49 , p_init_msg_list IN NUMBER
50 , p_move_order_type IN NUMBER
51 , x_delivered_qty OUT NOCOPY NUMBER
52 , x_qty_UM OUT NOCOPY VARCHAR2
53 , x_delivered_qty2 OUT NOCOPY NUMBER
54 , x_qty_UM2 OUT NOCOPY VARCHAR2
55 , x_return_status OUT NOCOPY VARCHAR2
56 , x_msg_count OUT NOCOPY NUMBER
57 , x_msg_data OUT NOCOPY VARCHAR2
58 );
59 PROCEDURE Get_Allocation_Record
60 ( p_wdd_line IN wsh_delivery_details%rowtype
61 , x_allocation_rec OUT NOCOPY GMI_Auto_Allocate_PUB.gmi_allocation_rec
62 , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
63 , x_return_status OUT NOCOPY VARCHAR2
64 , x_msg_count OUT NOCOPY NUMBER
65 , x_msg_data OUT NOCOPY VARCHAR2
66 ) ;
67
68
69 PROCEDURE Insert_Row (
70 p_auto_alloc_batch_rec IN gmi_auto_allocation_batch%ROWTYPE );
71
72 FUNCTION Submit_Allocation_Request(P_Batch_Id NUMBER)
73 RETURN NUMBER;
74
75
76
77 END GMI_AUTO_ALLOC_BATCH_PKG;