APPS.INV_LOT_API_PKG dependencies on DUAL

Line 1286: FROM DUAL;

1282: END IF;
1283:
1284: SELECT SYSDATE + l_shelf_life_days
1285: INTO l_expiration_date
1286: FROM DUAL;
1287:
1288: IF TRUNC(l_expiration_date) <> trunc(p_expiration_date) THEN
1289: fnd_message.set_name('INV', 'INV_EXP_DATE_NOT_CONSIDER');
1290: fnd_msg_pub.ADD;

Line 1526: -- SELECT MTL_GEN_OBJECT_ID_S.NEXTVAL INTO l_mtl_gen_obj_no FROM dual;

1522: IF( g_debug = 1 ) THEN
1523: print_debug('Populate OUT lot record parameter', 9);
1524: END IF;
1525:
1526: -- SELECT MTL_GEN_OBJECT_ID_S.NEXTVAL INTO l_mtl_gen_obj_no FROM dual;
1527:
1528: -- Replace the INSERT INTO mtl_lot_numbers statement with population of OUT lot record parameter.
1529:
1530: x_lot_rec.inventory_item_id := p_inventory_item_id;