DBA Data[Home] [Help]

APPS.INV_RMA_SERIAL_PVT dependencies on MTL_SERIAL_CHECK

Line 51: -- from mtl_serial_check.inv_serial_info for Bug 4312849

47: l_lot_number VARCHAR2(80);
48: l_fm_serial_number VARCHAR2(30);
49: l_to_serial_number VARCHAR2(30);
50: l_prefix VARCHAR2(30); -- Increased the field width to 30 to match with the return value X_PREFIX
51: -- from mtl_serial_check.inv_serial_info for Bug 4312849
52: l_fm_num VARCHAR2(30); -- Increased the field width to 30
53: l_to_num VARCHAR2(30); -- Increased the field width to 30
54: l_serial_number VARCHAR2(30);
55:

Line 159: IF NOT mtl_serial_check.inv_serial_info(

155:
156: EXIT WHEN oe_lot_serials%NOTFOUND;
157:
158:
159: IF NOT mtl_serial_check.inv_serial_info(
160: P_FROM_SERIAL_NUMBER => l_fm_serial_number,
161: P_TO_SERIAL_NUMBER => l_to_serial_number,
162: X_PREFIX => l_prefix,
163: X_QUANTITY => l_qty,