1 PACKAGE INV_DETAIL_SERIAL_PUB AS
2 /* $Header: INVSRSTS.pls 120.0 2005/05/24 18:37:01 appldev noship $ */
3
4 -- Start of comments
5 -- API name: Get_User_Serial_Numbers
6 -- Type : Public
7 -- Pre-reqs: None.
8 -- Function: Given the item/organization, inventory controls,
9 -- quantity for a autodetailed row and also from/to
10 -- serial number range info. Allows for custom sql
11 -- statements to be used when detailing serials
12 --
13 -- Parameters:
14 -- IN: p_organization_id IN NUMBER Required
15 -- Item organization id. Part of the unique key
16 -- that uniquely identifies an item record.
17 -- p_inventory_item_id IN NUMBER Required
18 -- inventory_item_id of item that serials should
19 -- be selected for
20 -- p_revision IN VARCHAR2
21 -- item revision
22 -- p_lot_number IN VARCHAR2
23 -- item lot number
24 -- p_subinventory_code IN VARCHAR2
25 -- source subinventory of serials
26 -- p_locator_id IN NUMBER
27 -- source locator of serials
28 -- p_required_sl_qty IN NUMBER
29 -- required number of serials to be retrieved
30 -- p_from_range IN VARCHAR2
31 -- serial_number_start from mtl_txn_request_lines
32 -- p_to_range IN VARCHAR2
33 -- serial_number_end from mtl_txn_request_lines
34 -- p_unit_number IN VARCHAR2
35 -- unit_number from mtl_txn_request_lines
36 -- p_cost_group_id IN NUMBER
37 -- cost group id of item
38 -- p_transaction_type_id IN NUMBER
39 -- transaction_type_id from mtl_txn_request_lines
40 -- p_demand_source_type_id IN NUMBER
41 -- transaction_source_type_id from mtl_txn_request_lines
42 -- p_demand_source_header_id IN NUMBER
43 -- transaction_header_id from mtl_txn_request_lines
44 -- p_demand_source_line_id IN NUMBER
45 -- txn_source_line_id from mtl_txn_request_lines
46 -- OUT: x_serial_numbers OUT NOCOPY VARCHAR2
47 -- Table of records returned with serials to be allocated
48 -- Version : Current version 1.0
49 -- End of comments
50
51 PROCEDURE Get_User_Serial_Numbers (
52 x_return_status OUT NOCOPY VARCHAR2
53 , x_msg_count OUT NOCOPY NUMBER
54 , x_msg_data OUT NOCOPY VARCHAR2
55 , p_organization_id IN NUMBER
56 , p_inventory_item_id IN NUMBER
57 , p_revision IN VARCHAR2
58 , p_lot_number IN VARCHAR2
59 , p_subinventory_code IN VARCHAR2
60 , p_locator_id IN NUMBER
61 , p_required_sl_qty IN NUMBER
62 , p_from_range IN VARCHAR2
63 , p_to_range IN VARCHAR2
64 , p_unit_number IN VARCHAR2
65 , p_cost_group_id IN NUMBER
66 , p_transaction_type_id IN NUMBER
67 , p_demand_source_type_id IN NUMBER
68 , p_demand_source_header_id IN NUMBER
69 , p_demand_source_line_id IN NUMBER
70 , x_serial_numbers OUT NOCOPY INV_DETAIL_UTIL_PVT.G_SERIAL_ROW_TABLE_REC
71 );
72
73 END INV_DETAIL_SERIAL_PUB;