1 PACKAGE WMS_ASN_LOT_ATT AUTHID CURRENT_USER AS
2 /* $Header: WMSINTLS.pls 115.2 2002/12/01 04:05:04 rbande ship $ */
3
4 -- Record Type for the lot number attributes columns
5 TYPE lot_sel_attributes_rec_type IS RECORD
6 (
7 COLUMN_NAME VARCHAR2(50) :=NULL
8 , COLUMN_TYPE VARCHAR2(20) :=NULL
9 , COLUMN_VALUE fnd_descr_flex_col_usage_vl.default_value%TYPE :=NULL
10 , REQUIRED VARCHAR2(10) :='NULL'
11 , PROMPT VARCHAR2(100) :=NULL
12 , COLUMN_LENGTH NUMBER :=NULL
13 );
14
15 -- Table type definition for an array of cb_chart_status_rec_type records.
16 TYPE lot_sel_attributes_tbl_type is TABLE OF lot_sel_attributes_rec_type
17 INDEX BY BINARY_INTEGER;
18
19 TYPE n_attribute_table_type IS TABLE OF mtl_lot_numbers.n_attribute1%TYPE INDEX BY BINARY_INTEGER;
20 TYPE d_attribute_table_type IS TABLE OF mtl_lot_numbers.d_attribute1%TYPE INDEX BY BINARY_INTEGER;
21 TYPE c_attribute_table_type IS TABLE OF mtl_lot_numbers.c_attribute1%TYPE INDEX BY BINARY_INTEGER;
22
23 g_lot_attributes_tbl lot_sel_attributes_tbl_type;
24
25 g_serial_attributes_tbl lot_sel_attributes_tbl_type;
26
27
28 --
29 -- Validate Lot sets the default values
30 -- validates and inserts rows into
31 -- mtl_lot_numbers from wms_lpn_contents_interface
32 --
33
34 procedure validate_lot (
35 x_return_status OUT NOCOPY VARCHAR2
36 , x_msg_count OUT NOCOPY NUMBER
37 , x_msg_data OUT NOCOPY VARCHAR2
38 , p_interface_transaction_id IN NUMBER
39 );
40
41 PROCEDURE insert_range_serial
42 (p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_inventory_item_id IN NUMBER,
44 p_organization_id IN NUMBER,
45 p_from_serial_number IN VARCHAR2,
46 p_to_serial_number IN VARCHAR2,
47 p_initialization_date IN DATE,
48 p_completion_date IN DATE,
49 p_ship_date IN DATE,
50 p_revision IN VARCHAR2,
51 p_lot_number IN VARCHAR2,
52 p_current_locator_id IN NUMBER,
53 p_subinventory_code IN VARCHAR2,
54 p_trx_src_id IN NUMBER,
55 p_unit_vendor_id IN NUMBER,
56 p_vendor_lot_number IN VARCHAR2,
57 p_vendor_serial_number IN VARCHAR2,
58 p_receipt_issue_type IN NUMBER,
59 p_txn_src_id IN NUMBER,
60 p_txn_src_name IN VARCHAR2,
61 p_txn_src_type_id IN NUMBER,
62 p_transaction_id IN NUMBER,
63 p_current_status IN NUMBER,
64 p_parent_item_id IN NUMBER,
65 p_parent_serial_number IN VARCHAR2,
66 p_cost_group_id IN NUMBER,
67 p_serial_transaction_intf_id IN NUMBER,
68 p_status_id IN NUMBER,
69 p_inspection_status IN NUMBER,
70 x_object_id OUT NOCOPY NUMBER,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2)
74 ;
75
76 end WMS_ASN_LOT_ATT;