1 PACKAGE PO_UNITEFF_PKG as
2 /* $Header: POXPMUES.pls 120.0.12010000.1 2008/09/18 12:21:05 appldev noship $ */
3
4
5 /* GET_UNIT_NUMBER
6 * ---------------
7 * This function is called by PO_SHIP_RCV_SUPPLY_VIEW and
8 * PO_SHIP_SUPPLY_VIEW. Given a shipment_line_id and an item id,
9 * this function will return the end item unit number that is
10 * stored in MTL_SERIAL_NUMBERS.
11 */
12 FUNCTION GET_UNIT_NUMBER(p_shipment_line_id NUMBER, p_item_id NUMBER)
13 RETURN VARCHAR2;
14
15
16 -- PRAGMA RESTRICT_REFERENCES(get_unit_number, WNDS, WNPS, RNPS);
17
18
19
20 END PO_UNITEFF_PKG;