1 PACKAGE INV_SERIAL_NUMBER_ATTR AUTHID CURRENT_USER AS
2 /* $Header: INVSATRS.pls 115.1 2004/01/26 19:36:11 yssingh noship $ */
3
4 ---------------------------------------------------------------------------------------------
5 --This API is created for bug 3303197. After the serial range enhancement, serial numbers are
6 --not stored on the wsh_delivery_details(WDD) table after pick confirm. Hence, users does not
7 --have serial number information on WDD. ATT uses WDD attributes to identify the serials
8 --being shipped. Now, since WDD does not have serials, ct will have to use serial number
9 --attributes for this purpose. This API will fulfill ct's requirement of populating serial
10 --attributes in mtl_serial_numbers table during pick release process.
11 --
12 --Name : validate_update_serial_attr
13 --
14 --Desc : procedure to update serial attributes in the mtl_serial_numbers table
15 --Input: p_serial_number - Serial Number
16 -- p_inventory_item_id - Inventory Item id
17 -- p_attributes_tbl - Table of enabled serial attributes
18 -- p_attribute_category - Attribute category(Optional) for valueset validations
19 ---------------------------------------------------------------------------------------------
20
21 TYPE char_table IS TABLE OF VARCHAR2(500)
22 INDEX BY BINARY_INTEGER;
23
24 g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
25
26 procedure Update_Serial_number_attr(
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30
31 p_serial_number IN VARCHAR2,
32 p_inventory_item_id IN NUMBER,
33 p_attribute_category IN VARCHAR2 DEFAULT NULL,
34 p_attributes_tbl IN inv_serial_number_attr.char_table);
35
36 END INV_SERIAL_NUMBER_ATTR;