DBA Data[Home] [Help]

PACKAGE: APPS.GMI_PICK_RELEASE_UTIL

Source


1 PACKAGE GMI_Pick_Release_Util AUTHID CURRENT_USER AS
2 /*  $Header: GMIUPKRS.pls 115.9 2004/01/12 21:34:28 lswamy ship $
3  +=========================================================================+
4  |                Copyright (c) 2000 Oracle Corporation                    |
5  |                        TVP, Reading, England                            |
6  |                         All rights reserved                             |
7  +=========================================================================+
8  | FILENAME                                                                |
9  |    GMIUPKRS.pls                                                         |
10  |                                                                         |
11  | DESCRIPTION                                                             |
12  |     This package contains Utilities procedures relating to GMI          |
13  |     Pick Release process.                                               |
14  |                                                                         |
15  | - Get_Delivery_Details                                                  |
16  | - Create_Pick_Slip_and_Print                                            |
17  |                                                                         |
18  |                                                                         |
19  | HISTORY                                                                 |
20  |     04-May-2000  odaboval        Created                                |
21  |   								            |
22  +=========================================================================+
23   API Name  : GMI_Pick_Release_Util
24   Type      : Global
25  -
26   Pre-reqs  : N/A
27   Parameters: Per function
28 
29   Current Vers  : 1.0
30 
31 */
32 
33 
34 PROCEDURE Get_Delivery_Details
35    ( p_mo_line_id                    IN  NUMBER
36    , x_inv_delivery_details          OUT NOCOPY WSH_INV_DELIVERY_DETAILS_V%ROWTYPE
37    , x_return_status                 OUT NOCOPY VARCHAR2
38    , x_msg_count                     OUT NOCOPY NUMBER
39    , x_msg_data                      OUT NOCOPY VARCHAR2
40    );
41 
42 -- Bug3294071 Getting Rid of this one.
43 /* The following procedure is created for enhancement 1928979 */
44 /* PROCEDURE Create_Pick_Slip_and_Print
45    ( p_mo_line_rec                   IN  GMI_Move_Order_Global.mo_line_rec
46    , p_inv_delivery_details          IN  WSH_INV_DELIVERY_DETAILS_V%ROWTYPE
47    , p_pick_slip_mode                IN  VARCHAR2
48    , p_grouping_rule_id              IN  NUMBER
49    , p_allow_partial_pick            IN  VARCHAR2 DEFAULT FND_API.G_TRUE
50    , p_pick_slip_number              OUT NOCOPY NUMBER
51    , p_sub_code                      IN  VARCHAR2
52    , x_return_status                 OUT NOCOPY VARCHAR2
53    , x_msg_count                     OUT NOCOPY NUMBER
54    , x_msg_data                      OUT NOCOPY VARCHAR2
55    ) ; */
56 
57 /* The following procedure is created for enhancement 1928979 */
58 PROCEDURE Create_Manual_Alloc_Pickslip
59    ( p_organization_id       IN NUMBER
60    , p_line_id               IN NUMBER
61    , x_return_status        OUT NOCOPY VARCHAR2
62    , x_msg_count            OUT NOCOPY NUMBER
63    , x_msg_data             OUT NOCOPY VARCHAR2
64    , x_pick_slip_number     OUT NOCOPY NUMBER
65    );
66 
67 PROCEDURE Create_Pick_Slip_and_Print
68    ( p_mo_line_rec                   IN  GMI_Move_Order_Global.mo_line_rec
69    , p_inv_delivery_details          IN  WSH_INV_DELIVERY_DETAILS_V%ROWTYPE
70    , p_pick_slip_mode                IN  VARCHAR2
71    , p_grouping_rule_id              IN  NUMBER
72    , p_allow_partial_pick            IN  VARCHAR2 DEFAULT FND_API.G_TRUE
73    , x_return_status                 OUT NOCOPY VARCHAR2
74    , x_msg_count                     OUT NOCOPY NUMBER
75    , x_msg_data                      OUT NOCOPY VARCHAR2
76    );
77 
78 -- Bug3294071 (following procedure added)
79 PROCEDURE UPDATE_TXN_WITH_PICK_SLIP
80    (   p_mo_line_rec                   IN  GMI_Move_Order_Global.mo_line_rec
81      , p_pick_slip_number              IN  NUMBER
82      , x_return_status                 OUT NOCOPY VARCHAR2
83      , x_msg_count                     OUT NOCOPY NUMBER
84      , x_msg_data                      OUT NOCOPY VARCHAR2
85    );
86 
87 END GMI_Pick_Release_Util;