1 PACKAGE GML_MLT_CNTR_RCPT AUTHID CURRENT_USER AS
2 /* $Header: GMLMTCRS.pls 115.1 2003/08/11 19:02:35 pbamb noship $*/
3
4 /*+========================================================================+
5 | Copyright (c) 1998 Oracle Corporation |
6 | Redwood Shores, CA, USA |
7 | All rights reserved. |
8 +==========================================================================+
9 | FILE NAME |
10 | GMLMTCRS.pls |
11 | |
12 | PACKAGE NAME |
13 | GML_MLT_CNTR_RCPT |
14 | |
15 | DESCRIPTION |
16 | This package procedure is use to create new lots depending on the |
17 | parameters passed and returns the new lots in the plsql table back to |
18 | RCVGMLCR.pld which then populates the LOT ENTRY screen with all the |
19 | lots.
20 | |
21 | CONTENTS |
22 | Create_Lots |
23 | |
24 | HISTORY |
25 | Created - Preetam Bamb 07/28/2003 |
26 | |
27 +==========================================================================+
28 Body end of comments*/
29
30 TYPE lotrec IS RECORD (
31 lot_id NUMBER,
32 lot_no VARCHAR2(32),
33 sublot_no VARCHAR2(32),
34 expire_date DATE);
35
36 TYPE lot_table IS TABLE OF lotrec
37 index by BINARY_INTEGER;
38
39
40 FUNCTION Create_Lots
41 ( p_item_id IN NUMBER
42 , p_lot_no IN VARCHAR2
43 , p_no_of_lots IN NUMBER
44 , p_no_of_sublots IN NUMBER
45 , p_expire_date IN DATE
46 , p_lot_spec_conv IN VARCHAR2
47 , p_primary_uom IN VARCHAR2
48 , p_primary_qty IN VARCHAR2
49 , p_secondary_uom IN VARCHAR2
50 , p_secondary_qty IN VARCHAR2
51 , p_shipvend_id IN NUMBER
52 , p_vendor_lot_no IN VARCHAR2
53 , x_lot_table IN OUT NOCOPY lot_table
54 , x_return_status OUT NOCOPY VARCHAR2
55 , x_msg_count OUT NOCOPY NUMBER
56 , x_msg_data OUT NOCOPY VARCHAR2
57 ) RETURN VARCHAR2;
58
59 --Function used to create a warapper to the qty_rec_typ to use for
60 --GMI_MOVE_DIFF_STAT profile option enhancements for value 2
61 FUNCTION GMIGAPI_QTY_FORMAT RETURN GMIGAPI.qty_rec_typ;
62
63 END GML_MLT_CNTR_RCPT;