DBA Data[Home] [Help]

APPS.GMO_VBATCH_TASK_PVT dependencies on MTL_LOT_NUMBERS

Line 1246: l_lot_rec mtl_lot_numbers%ROWTYPE;

1242: ,x_message_count OUT NOCOPY NUMBER
1243: ,x_message_data OUT NOCOPY VARCHAR2
1244: )
1245: IS
1246: l_lot_rec mtl_lot_numbers%ROWTYPE;
1247: l_char_tbl inv_lot_api_pub.char_tbl;
1248: l_number_tbl inv_lot_api_pub.number_tbl;
1249: l_date_tbl inv_lot_api_pub.date_tbl;
1250: BEGIN

Line 1389: select gen_object_id into x_lot_event_key from mtl_lot_numbers

1385: )
1386: IS
1387: BEGIN
1388:
1389: select gen_object_id into x_lot_event_key from mtl_lot_numbers
1390: where organization_id = p_organization_id
1391: and inventory_item_id = p_inventory_item_id
1392: and lot_number = p_lot_number;
1393: