1 package gmialloc AUTHID CURRENT_USER as
2 -- $Header: gmialocs.pls 115.3 2004/03/15 20:10:52 jsrivast noship $
3
4 /* ===========================================================
5 This package is only for the use of Inventory module
6 and will be used for validating/updating the pending
7 transactions which will be drawing from the inventory when
8 there is a mass move immediate or move immediate
9 Jalaj Srivastava Bug 3282770
10 Modified signatures of procedures update_pending_allocations
11 and CHECK_ALLOC_QTY.
12 Added procedure VALIDATE_MOVEALLOC_FORMASSMOVE.
13 =========================================================== */
14
15 procedure update_pending_allocations
16 ( p_api_version IN NUMBER
17 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
19 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2
23 ,pdoc_id IN NUMBER
24 ,pto_whse_code IN VARCHAR2
25 ,pto_location IN VARCHAR2
26 );
27
28 procedure CHECK_ALLOC_QTY
29 ( p_api_version IN NUMBER
30 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
31 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
32 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,pfrom_whse_code IN VARCHAR2
37 ,pfrom_location IN VARCHAR2
38 ,plot_id IN NUMBER
39 ,pitem_id IN NUMBER
40 ,pmove_qty IN NUMBER
41 ,pto_whse_code IN VARCHAR2
42 ,x_move_allocations OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE VALIDATE_MOVEALLOC_FORMASSMOVE
46 ( p_api_version IN NUMBER
47 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
48 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
49 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
50 ,x_return_status OUT NOCOPY VARCHAR2
51 ,x_msg_count OUT NOCOPY NUMBER
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 ,pfrom_whse_code IN VARCHAR2
54 ,pto_whse_code IN VARCHAR2
55 ,pjournal_id IN NUMBER
56 );
57
58
59 END GMIALLOC;